Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to toggle visability of button
Where are you getting the value of the 'salestax' variable? Also,
it is bad programming practice to change the cell to which the Target variable points. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "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 | |||
Toggle Button | Excel Worksheet Functions | |||
Toggle Button | Excel Discussion (Misc queries) | |||
Toggle button | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Programming |