View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ltyson[_4_] ltyson[_4_] is offline
external usenet poster
 
Posts: 1
Default variable help....


Bob thank you. The one word 'controls' was the missing peice. This ne
code pasted below now works perfect:

Sub CheckBox359_Click()
i = 359
If Controls("CheckBox" & i) = True Then
Sheets("Order_Entry").Shapes("Rectangle " & i).Select
Selection.ShapeRange.Fill.ForeColor.SchemeColor = 8
Selection.ShapeRange.Fill.Visible = msoTrue
Selection.ShapeRange.Fill.Solid
End If
If Controls("CheckBox" & i) = False Then
Sheets("Order_Entry").Shapes("Rectangle " & i).Select
Selection.ShapeRange.Fill.Visible = msoFalse
End If
End Sub

It is odd to me why i have to use:

If Controls("CheckBox" & i) = True Then

if I use the variable but:

if Checkbox359 = True Then

works fine if I don't use the variable. Looks like I have mor
learning to do. :)

Thanks for your help,

Larr

--
ltyso
-----------------------------------------------------------------------
ltyson's Profile: http://www.excelforum.com/member.php...nfo&userid=276
View this thread: http://www.excelforum.com/showthread.php?threadid=39758