The ShowModal property of a form determines if it takes focus until it is
closed or if you can toggle between it and other windows. Set the UserForm's
ShowModal property to False and I think you will be able to do what you want.
--
- K Dales


"ecpl_3" wrote:

I am reposting my question to see if anybody can tell me if it is possible to
toggle between a macro running a "Form" and Excel. The comments below are
from my previous post.

thanks

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".

"Brad" wrote:

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

"ecpl_3" wrote:

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