Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to toggle visability of button
Hi Jim,
Assuming your Toggle button is a worksheet control, try Dim bVis as boolean 'code for bVis = True or False Me.OLEObjects("ToggleButton1").Visible = bVis Regards, Peter T "Jim at Eagle" wrote in message ... Trying to toggle visability of button based on value of named range. Private Sub Worksheet_SheetChange(ByVal Target As Range) Target = sheet1.Range("d9") ToggleButton1.Visible = True Select Case salestax Case 0.00001 To 100 ToggleButton1.Visible = True Case Else ToggleButton1.Visible = False End Select End Sub Help Please -- Jim at Eagle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toggle Button | Excel Worksheet Functions | |||
Need to Use 1 Button to toggle On or Off | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Worksheet Functions | |||
Trying to toggle visability of button | Excel Programming | |||
Toggle Button | Excel Programming |