Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding a dropdown menu
Hello,
I am stuck and would appreciate your input. I have an option button (Option Button 8566) and it is linked to cell T15 on SheetResults. When the first option from the option button is chosen and hence T15=1, Drop Down 573 should be visible. If T15 equals to anything else, Drop Down 573 should not be visible. I know I need to write a macro but I am not sure where to start. Any ideas? Many thanks in advance, Johanna |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding a dropdown menu
try;
Sub HideIt() Sheet1.Shapes _ ("Drop Down 573").Visible = _ Sheet1.Range("T51") = 1 End Sub -- Regards Dave Hawley www.ozgrid.com "Johanna Gronlund" wrote in message ... Hello, I am stuck and would appreciate your input. I have an option button (Option Button 8566) and it is linked to cell T15 on SheetResults. When the first option from the option button is chosen and hence T15=1, Drop Down 573 should be visible. If T15 equals to anything else, Drop Down 573 should not be visible. I know I need to write a macro but I am not sure where to start. Any ideas? Many thanks in advance, Johanna |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding a dropdown menu
Hi and thanks for reply. I've copied this into a new module and assigned the
macro on the option button. However, nothing happens. There is no error message but the dropdown menu is not hidden. Johanna -- "ozgrid.com" wrote: try; Sub HideIt() Sheet1.Shapes _ ("Drop Down 573").Visible = _ Sheet1.Range("T51") = 1 End Sub -- Regards Dave Hawley www.ozgrid.com "Johanna Gronlund" wrote in message ... Hello, I am stuck and would appreciate your input. I have an option button (Option Button 8566) and it is linked to cell T15 on SheetResults. When the first option from the option button is chosen and hence T15=1, Drop Down 573 should be visible. If T15 equals to anything else, Drop Down 573 should not be visible. I know I need to write a macro but I am not sure where to start. Any ideas? Many thanks in advance, Johanna . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Multiple Hiding Validation Dropdown Lists | Excel Worksheet Functions | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
dropdown menu or Jump menu | Excel Discussion (Misc queries) |