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

  • Thread starter Thread starter NFL
  • Start date Start date
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!
 
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!
Click to expand...

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
 

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

userform program keeps crashing 4
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel 2003 - VBA - UserForm Help 3
Userform won't show after closing another file 8
Userform Rangebutton 3
Userform won't show when file re-opened 2
multiple user in excel to edit a userform 2
keep on working while userform is active 2

Back
Top