View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dksaluki dksaluki is offline
external usenet poster
 
Posts: 48
Default How to keep UserForm open at all times while excel is running

On Jul 7, 5:54*pm, NFL wrote:
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