ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to keep UserForm open at all times while excel is running (https://www.excelbanter.com/excel-discussion-misc-queries/236146-how-keep-userform-open-all-times-while-excel-running.html)

NFL

How to keep UserForm open at all times while excel is running
 
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!

dksaluki

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


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com