I need to reference a cell in a worksheet from within an Excel Macro. I am using the following formula: lcFileNameDataGL = Admin!B9 but won’t work well inside the Macro. I can edit this in Macro but somebody else who is not knowledgeable in Macro will use the file so the revisions must be done in the worksheet and not in the Macro.
Â
Macro programming is difficult to create without haven’t sufficient knowledge and attention which was confused. Sometimes in a spreadsheet a cell will contain both numeric characters. You can test your own applications or when you want to treat particular condition as being equivalent to these errors.
Microsoft provides components for common user interfaces. However, you still have to do some of the work in selection the options that will be available on the dialogs and interpreting what to do with user’s selection.
These common u set interface dialogs work exactly the same as in any Microsoft application, but by manipulating the properties, you can use the values they produce in your code. In the development tab select run a macro, in the macro name box click the macro you want to run.
