Using Forms

[Jietoh]

Hello All!

I use several custom made forms in excel. I have them all set to vbModeless so that I can interact with the worksheet at the same time. However, my issue is that when I open a worksheet that the form is attached to the program defaults to the form instead of the worksheet. So if I start to issue commands from the keyboard nothing happens. Is there a way to set the default to the worksheet instead?

Thanks,
Dan

[LJMetzger]

Hi JIetoh,

The following was tested in Excel 2003 and worked. I do get a 'Runtime Error 5' if the Debugger window is Open.

Please Login or Register  to view this content.

Lewis

[Jietoh]

Thanks. That worked great!