| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropping A DROPDOWN on set focus
hi all is this possible ive been searching all night to find out if i can
simply on focus of my msocontroldropdown for it to open up and display the list after running a macro? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dropping A DROPDOWN on set focus
Hi,
Try this Me.ComboBox1.SetFocus Me.ComboBox1.DropDown If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Rivers" wrote: hi all is this possible ive been searching all night to find out if i can simply on focus of my msocontroldropdown for it to open up and display the list after running a macro? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dropping A DROPDOWN on set focus
hi shane heres my code bt it says that it does not support this option
Application.CommandBars("saveas").Controls(6).SetF ocus Application.CommandBars("saveas").Controls(6).Drop Down "ShaneDevenshire" wrote: Hi, Try this Me.ComboBox1.SetFocus Me.ComboBox1.DropDown If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Rivers" wrote: hi all is this possible ive been searching all night to find out if i can simply on focus of my msocontroldropdown for it to open up and display the list after running a macro? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
| Dropping 0 | Excel Discussion (Misc queries) | |||
| populating a dropdown based on choice from a previous dropdown | Excel Programming | |||
| offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
| TAB and focus moving from unprotected cell in protected sheet til dropdown. | Excel Programming | |||
Linear Mode
