Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown Box On Worksheet
Hi,
With the dropdown box placed on the worksheet, I've got everything to work properly - by using the control format and assigning a macro. After running the first part of the macro, how do I reset the dropdown box so that it starts with the first item in the list? Sub DropDownBox10() '~~~Dim Variables~~~ '~~~Code~~~ '~~~Psuedo Code: 'ActiveSheet.Shapes("Drop Down 10").ListIndex = 1 End Sub Possibly it can't be done that way on a worksheet, but I thought I would run it by you all. Thanks, Rick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown Box On Worksheet
Hi Rick,
Rick wrote: With the dropdown box placed on the worksheet, I've got everything to work properly - by using the control format and assigning a macro. After running the first part of the macro, how do I reset the dropdown box so that it starts with the first item in the list? Sub DropDownBox10() '~~~Dim Variables~~~ '~~~Code~~~ '~~~Psuedo Code: 'ActiveSheet.Shapes("Drop Down 10").ListIndex = 1 End Sub Possibly it can't be done that way on a worksheet, but I thought I would run it by you all. use this Syntax: ActiveSheet.Shapes("Drop Down 10").ControlFormat.ListIndex = 1 -- Regards Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown Box On Worksheet
Melanie,
Wow! Thanks! Just when I think it can't be done, one of you have an answer. Thanks so much, Rick -----Original Message----- Hi Rick, Rick wrote: With the dropdown box placed on the worksheet, I've got everything to work properly - by using the control format and assigning a macro. After running the first part of the macro, how do I reset the dropdown box so that it starts with the first item in the list? Sub DropDownBox10() '~~~Dim Variables~~~ '~~~Code~~~ '~~~Psuedo Code: 'ActiveSheet.Shapes("Drop Down 10").ListIndex = 1 End Sub Possibly it can't be done that way on a worksheet, but I thought I would run it by you all. use this Syntax: ActiveSheet.Shapes("Drop Down 10").ControlFormat.ListIndex = 1 -- Regards Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown Box On Worksheet
One mo
ActiveSheet.dropdowns("Drop Down 10").ListIndex = 1 Rick wrote: Hi, With the dropdown box placed on the worksheet, I've got everything to work properly - by using the control format and assigning a macro. After running the first part of the macro, how do I reset the dropdown box so that it starts with the first item in the list? Sub DropDownBox10() '~~~Dim Variables~~~ '~~~Code~~~ '~~~Psuedo Code: 'ActiveSheet.Shapes("Drop Down 10").ListIndex = 1 End Sub Possibly it can't be done that way on a worksheet, but I thought I would run it by you all. Thanks, Rick -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock worksheet, based on dropdown selection prior worksheet | New Users to Excel | |||
dropdown list to a page in worksheet | New Users to Excel | |||
Referencing a dropdown box on a worksheet | Excel Discussion (Misc queries) | |||
How do I copy my dropdown box with data to another worksheet? | Excel Worksheet Functions | |||
Building a dropdown from a worksheet | Excel Programming |