View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default User variable to get object value

Dave,

That is nice.

Thank you,

Steven

"Dave Peterson" wrote:

dim iCtr as long
for ictr = 11 to 25
msgbox me.controls("Checkbox" & ictr).value
next ictr



Steven wrote:

Thank you for the response:

What I have is 15 checkboxes... CheckBox11 to CheckBox 25

Based on certain criteria will determine which checkbox I want the value of:

I would like to do it using the number 11 to 25 as a variable and then
creating a string for like

vCkBox = "Me.CheckBox " + vNumber
MsgBox vCkBox.Value

or something like that.

Thank you, Steven


--

Dave Peterson