Toggle between excel sheet and user form

[Guest]

Gents,

How can I make my forms in a way that would allow me to select the active
sheet or move up and down the sheet while the user form is still shown in
front of the user.

Regards

 

[Robin Hammond]

Omar,

In XL2000 or above, show the form as modeless. You can't do it without a lot
of hacks in 97.

frmName.Show vbModeless

Robin Hammond
www.enhanceddatasystems.com

 

[Guest]

Robin,

You are the best - it works perfectly. Thanks.