Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have 50 Check Boxes and I'm trying to create a Sub that accepts an Integer parameter (1-50) and then changes the value of the check box to true. This is the code that I'm trying to do Sub chngVal(x) Dim thestring As String thestring = "CheckBox" & x & ".Value = True" thestring End Sub So if I called chngVal(25), it would call CheckBox25.Value = True. This code doesn't work but is there a way to create a String or some form of Object and then call the line? Thanks! Ilan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
dynamically created listbox | Excel Programming | |||
Scaling a chart that has been dynamically created in vb | Charts and Charting in Excel | |||
Back color of dynamically-created buttons | Excel Programming | |||
Assign macros to dynamically created form elements | Excel Programming |