Toggling between macro and excel

G

Guest

Hi,
Is is possible to run a macro and while that macro is active toggle to the
XL woorkbook without stoping the macro?
 
G

Guest

Toggling between the VB window and the xl spread sheet is not a problem.
When my vb code launches a "Form"--which manipulates the xl spreadsheet, I
can not toggle between the "Form" and the xl sheet. I would like to manually
manipulate the xl sheet w/o exiting from the "Form".
 
G

Guest

If you are in break mode there are two ways to do this.

if you have Excel2000 or newer, VB will be in another window, so you can
arrange the windows to see both the Excel sheet and the VB window

If you have 97 I believe you can use Alt+F11 to toggle back and forth.

I hope that is helpful
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top