How to keep UserForm open at all times while excel is running

N

NFL

Is there a way to keep the userform list visible at all times? The purpose
of the form is to keep a list available whenever needed. I was thinking of
using the vb command such as ... activecell = listbox.value or something...

Thank you!
 
D

dksaluki

Is there a way to keep the userform list visible at all times?  The purpose
of the form is to keep a list available whenever needed.  I was thinking of
using the vb command such as ... activecell = listbox.value or something...

Thank  you!

If you make the userform modeless, (or not modeless, i can never
remember which way it is) you can keep the userform open and still do
other things. Google modeless and find out for sure.

dk
 
Top