Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
NFL NFL is offline
external usenet poster
 
Posts: 31
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't open worksheet (XLS) unless excel is running. aengus Excel Discussion (Misc queries) 2 June 8th 09 08:28 PM
Can't open worksheet (XLS) unless excel is running. aengus Setting up and Configuration of Excel 1 June 8th 09 08:16 PM
Adding running times stormy weather Excel Discussion (Misc queries) 4 October 16th 07 03:20 PM
Windows Installer keeps running when i open excel laxfan1405 Excel Discussion (Misc queries) 1 July 31st 07 07:44 AM
Excel 2000 running on Windows XP SP2 does not properly open CSV fi Oscar Excel Discussion (Misc queries) 1 December 20th 04 10:10 PM


All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"