View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Anant.Basant@gmail.com is offline
external usenet poster
 
Posts: 14
Default 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