Working on Spread sheet while form shows ? 2

[Recce]

Good day, I am having a problem here. I would like to know how to have my form show while I edit my worksheet or how do I move he focus from the form to the Spread Sheet ?

 

[RobBroekhuis]

You can show your form modeless, which allows the user to switch between the form and other Excel work. Note that this includes going to another workbook altogether, so that the form needs to be explicit about which workbook it refers to (e.g., by using "thisworkbook&quot.

Try it:

MyForm.show vbModeless



Rob

 

[Recce]

Dude, that is exactly what I was looking for. Thanks a stack. Your star is on it's way...:->