Toggling between macro and excel

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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".
 
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

Similar Threads

Run Macro If Cell have "x" value 0
hide & unhide toggle button 3
Toggling between a macro running a "Form" and Excel 5
Toggle Event - 2 Commands on 1 Button 1
Excel TWO Instances of Excel One watching Other 3
Change workbook name to a generic name 4
Two macros at startup excel? 2
Macro to link data to template 0

Back
Top