Show Userform

[moontho]

I was wondering if there is a way to have a form showing, but the user is still able to access excel behind it? Basically I'm wanting to create a type of navigation bar for a large excel document.

Many thanks

Thom

 

[xlbo]

in 2002, you can use the "modal" property of a form. Set it to vbmodeless and you should be able to play away whilst the form is showing. If you are running an earlier version of excel, you are probably outta luck

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[RobBroekhuis]

Works in XL2000 as well, not in earlier versions.

Rob

 

[xlbo]

thx for the update Rob - never had 2000 so wasn't sure

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[moontho]

Thanks Geoff.

Unfortunatly we're on 97, but hopefully not for too much longer, so i'll keep this filed.

Thom