Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I am currently working on an Excel spreadsheet and I have been using the following type of coding for a number of CheckBoxes: Private Sub CheckBox174_Click() If CheckBox174.Value = True Then Rows("193").Hidden = False Rows("318").Hidden = False Else Rows("193").Hidden = True Rows("318").Hidden = True End If End Sub Am I able to name/label the rows so that I do not need to redo the coding every time I insert or delete a row into the spreadsheet? If so, how would I need to amend the above code? Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In visual basic | Excel Worksheet Functions | |||
Visual Basic | Excel Discussion (Misc queries) | |||
Visual Basic | Excel Discussion (Misc queries) | |||
Checkbox Basic Help | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |