Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
am trying to get a combo box to appear when a specified cell is visble
through selection via a filter list am trying this code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) With ActiveSheet.CommandButton3 If Workbooks("Ward").Range("B9").Visible = True Then .Visible = True .Top = Range("f2").Top .Left = Range("f2").Left Else: .Visible = False End If End With End Sub But excell doesnt like the "if visible = true" I know this works for envelopevisible but not in this instance!! any inspiration? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to apply filter based on list or combo box?? | Excel Discussion (Misc queries) | |||
Move a single combo box from one cell to another... | Excel Programming | |||
Help please - List/Filter/Combo Box? | Excel Discussion (Misc queries) | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
Combo box to filter | Excel Programming |