Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dialog List Box
Hi,
I am hoping to have a macro button initiate a pop up a dialog box that contains a drop-down list box displaying a certain range. When the user selects a name from the list VBA will record the selection as a string. I have been going through the help files and the only pop up boxes I can find are the inputbox and msgbox. Is there anyway to do this? Thanks for all your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dialog List Box
Just create a separate form with a drop-down list box
containing all the data that you need. Set the form visible property to false to start with. Then create a button that when pushed changest the form visible property to true so the list-box can be accesed. -----Original Message----- Hi, I am hoping to have a macro button initiate a pop up a dialog box that contains a drop-down list box displaying a certain range. When the user selects a name from the list VBA will record the selection as a string. I have been going through the help files and the only pop up boxes I can find are the inputbox and msgbox. Is there anyway to do this? Thanks for all your help . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File name list in the open dialog box. | Excel Discussion (Misc queries) | |||
advanced filter dialog box, "List Range" list two ranges? | Excel Worksheet Functions | |||
Is there a "create List dialog box" in Excel 2007 ? | New Users to Excel | |||
How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
How do I insert A drop down dialog box as a 'list to choose from'? | Excel Worksheet Functions |