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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to toggle visability of button
If 'salestax' is a named range, you need to use code like
Select Case Range("salestax").Value -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jim at Eagle" wrote in message ... salestax is a named cell value is generated by if() and vlookup. part of if() references cell D9 (unprotected override value for salestax) Trying to toggle visability of button based on change of cell D9 or change in salestax Thanks "Chip Pearson" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to toggle visability of button
There is no SheetChange event for a single worksheet. That event is in the
ThisWorkbook module and looks like this Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) End Sub The individual worksheet change event, found by right clicking on the sheet tab and selecting view code looks like this: Private Sub Worksheet_Change(ByVal Target As Range) End Sub It is always best to select your events from the dropdown at the top of the module. then you know the event will work if events are enabled. See Chip Pearson's page on events http://www.cpearson.com/excel/events.htm Also, to test which cell triggered the event it would be Private Sub Worksheet_Change(ByVal Target As Range) if Target.Address = "$D$4" then end if End Sub or if Target.Column = 1 then ' for the entire column as an example. -- Regards, Tom Ogilvy "Jim at Eagle" wrote in message ... Something is amiss I tried just the following: Private Sub Worksheet_SheetChange(ByVal Target As Range) Target.Address = "D9" ToggleButton1.Visible = False End Sub Nothing change on the unprotected woorsheet after changing the value of D9 "Jim at Eagle" wrote: Tried this. Still no responce. Private Sub Worksheet_SheetChange(ByVal Target As Range) Target = sheet1.Range("D9") Select Case Range("salestax").Value Case 0.00001 To 100 ToggleButton1.Visible = True Case Else ToggleButton1.Visible = False End Select End Sub Thanks for helping "Chip Pearson" wrote: If 'salestax' is a named range, you need to use code like Select Case Range("salestax").Value -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jim at Eagle" wrote in message ... salestax is a named cell value is generated by if() and vlookup. part of if() references cell D9 (unprotected override value for salestax) Trying to toggle visability of button based on change of cell D9 or change in salestax Thanks "Chip Pearson" wrote: 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 |
Reply |
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 |