Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with dropdown boxes and preset selections
My goal is to make a macro that will bring up window A (dropdown list selection) and has, in the window, preset selections on the dropdown list. So for example, a dropdown list of 5 selections numbered 1 to 5 (1 being the one at the top, 5 being the one at the bottom), could I have the macro be created to have lets say when the window opens, option 3 in the dropdown list is selected by default? This all takes place in the Custom AutoFilter and im trying to have "is greater than" selection on the top box and "is less than" selection on the bottom box. Thanks -- Keving ------------------------------------------------------------------------ Keving's Profile: http://www.excelforum.com/member.php...o&userid=35826 View this thread: http://www.excelforum.com/showthread...hreadid=559381 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with dropdown boxes and preset selections
bump | -- Keving ------------------------------------------------------------------------ Keving's Profile: http://www.excelforum.com/member.php...o&userid=35826 View this thread: http://www.excelforum.com/showthread...hreadid=559381 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with dropdown boxes and preset selections
I'm assuming you use a userform.
Syntax: object.Selected( index ) [= Boolean] For example: lstMyCustomList.Selected(2) = True - using index 2 selects the third item This what you wanted? Keving schreef: bump | -- Keving ------------------------------------------------------------------------ Keving's Profile: http://www.excelforum.com/member.php...o&userid=35826 View this thread: http://www.excelforum.com/showthread...hreadid=559381 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting dropdown list with multiple text selections | Excel Discussion (Misc queries) | |||
Enabling multiple selections in same cell from dropdown menu | Excel Discussion (Misc queries) | |||
multiple dropdown selections | Excel Worksheet Functions | |||
How can I allow users to make multiple selections from a dropdown. | Excel Worksheet Functions | |||
Dropdown Selections in Excel - creating and choosing | Excel Worksheet Functions |