Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to view the VBA code dynamically...i.e., while usingthe record macro tool
Hello - I believe that I read that it is possible to see the VBA code
in the visual basic editor simultaneous to the actions that one is doing in Excel. If I understand right, this will likely involve using the record macro option. However, when I try viewing the module or sheet's macro code by opening both windows (and using the record macro option), I do not see the code. Could someone please let me know which windows exactly I need to open, and which steps I need to take, in order to accomplish this? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to view the VBA code dynamically...i.e., whileusing the record macro tool
On Apr 19, 7:06*am, Mike C wrote:
Hello - I believe that I read that it is possible to see the VBA code in the visual basic editor simultaneous to the actions that one is doing in Excel. If I understand right, this will likely involve using the record macro option. However, when I try viewing the module or sheet's macro code by opening both windows (and using the record macro option), I do not see the code. Could someone please let me know which windows exactly I need to open, and which steps I need to take, in order to accomplish this? Thanks. Hi, In the Excel application window use the middle button on the right hand side of the titlebar to "Restore" the window. Resize by dragging its sides to make it smaller. Press Alt+F11 to open VBE window and restore it in such a way that Excel window and VBE window share the screen side by side. Anant |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to view the VBA code dynamically...i.e., whileusing the record macro tool
On Apr 18, 9:32*pm, wrote:
On Apr 19, 7:06*am, Mike C wrote: Hello - I believe that I read that it is possible to see the VBA code in the visual basic editor simultaneous to the actions that one is doing in Excel. If I understand right, this will likely involve using the record macro option. However, when I try viewing the module or sheet's macro code by opening both windows (and using the record macro option), I do not see the code. Could someone please let me know which windows exactly I need to open, and which steps I need to take, in order to accomplish this? Thanks. Hi, In the Excel application window use the middle button on the right hand side of the titlebar to "Restore" the window. Resize by dragging its sides to make it smaller. Press Alt+F11 to open VBE window and restore it in such a way that Excel window and VBE window share the screen side by side. Anant Hello Anant - For some reason, when I follow those steps, I still don't see the code. I am looking at the VIEW CODE window within VBE. I am the selecting RECORD MACRO, and then when I make changes, I do not see any code in teh Code WIndoe (i.e., Showing General, and Declarations). Thanks for any suggestions. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to view the VBA code dynamically...i.e., whileusing the record macro tool
On 22 Apr., 04:09, Mike C wrote:
On Apr 18, 9:32*pm, wrote: On Apr 19, 7:06*am, Mike C wrote: Hello - I believe that I read that it is possible to see the VBA code in the visual basic editor simultaneous to the actions that one is doing in Excel. If I understand right, this will likely involve using the record macro option. However, when I try viewing the module or sheet's macro code by opening both windows (and using the record macro option), I do not see the code. Could someone please let me know which windows exactly I need to open, and which steps I need to take, in order to accomplish this? Thanks. Hi, In the Excel application window use the middle button on the right hand side of the titlebar to "Restore" the window. Resize by dragging its sides to make it smaller. Press Alt+F11 to open VBE window and restore it in such a way that Excel window and VBE window share the screen side by side. Anant Hello Anant - For some reason, when I follow those steps, I still don't see the code. I am looking at the VIEW CODE window within VBE. I am the selecting RECORD MACRO, and then when I make changes, I do not see any code in teh Code WIndoe (i.e., Showing General, and Declarations). Thanks for any suggestions.- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - Hi Mark When you record a macro it is usually placed in a new module. Start the macro recorder, goto the VBA window and open the correct module, then do what you need in excel. Regards, Per |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to clean up code that I did through a record macro | Excel Programming | |||
macro code to find last record in excel | Excel Programming | |||
vba code to record a macro | Excel Programming | |||
I am missing view tool bar from tool menu. | New Users to Excel | |||
How to use macro to dynamically add the VBA code and data together | Excel Programming |