'Floating' UserForm

P

paulw

Afternoon!
Does anyone know if it is possible to create a UserForm, which then
'floats' on the screen.
ie, you can still play around on the Excel sheet behind it, whilst it
is still on the screen.
Ta,:confused:
 
C

Chip Pearson

Paul,

You can do this in Excel 2000 and later by showing the form modelessly.
E.g.,

Userform1.Show vbModeless


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Create a dynamic list on a userform outside of a list control 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Avoid compile error if userform doesn't exists??? 1
Floating userform appears on task bar??? 7
flash movie on userform doesn't play when code is running 0
Always on top and Deactivate event 0
Userform leaving a trail 7

Top