Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
string
In the following code, I'm attempting to make all my checkboxes clear t a .false state, using a for next loop, Instead of typing each box in. I'm new to vb and am unsure how I use a string variable with th checkbox objects. Have a look and see if you can help. Thanks Dennis Private Sub Cm1_Click() Dim x As String For c = 1 To 55 'Dim x As String x = "a" + c x.Value = False next c 'instead of below 'a1.Value = False 'a2.Value = False 'a3, a4, a5,... 't1.Text = "" End Su -- terrysoper197 ----------------------------------------------------------------------- terrysoper1973's Profile: http://www.excelforum.com/member.php...fo&userid=3016 View this thread: http://www.excelforum.com/showthread.php?threadid=49892 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
counting the number of instances of a string within another string | Excel Worksheet Functions | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
Create a formula into a String then assign string to a cell | Excel Programming |