View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] izimmer@gmail.com is offline
external usenet poster
 
Posts: 3
Default How do I call a dynamically created String in a VBA Sub

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