Using varibles and object references in Userforms

[GiraffetheGeek]

I have a user form that has 80 text boxes and 20 control buttons that have similar names that vary with numbers.

ie WB_TxtBox_NameWeek1Appt1, and WB_TxtBox_NameWeek1Appt2 etc
ie Btn_Week1Appt1, Btn_Week1Appt2, Btn_Week2Appt1 etc.

I want to be able to use a varible when making references to these object in code,

ie Having a WeekCount varible and then instead of

WB_TxtBox_NameWeek1Appt1.Text

I tried to use

WeekCount = 1
ApptCount =1
WB_TextBox_NameWeek & WeekCount & Appt & ApptCount.Text

This obviously didn't work as the syntax is wrong.

Can someone let me know what the correct syntax is?

 

[repairman615]

Hello,

Try something like:

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> UserForm_Click()<br><br><SPAN style="color:#00007F">Dim</SPAN> WeekCount <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br><SPAN style="color:#00007F">Dim</SPAN> ApptCount <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br><SPAN style="color:#00007F">Dim</SPAN> varTextBox <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">String</SPAN><br>    WeekCount = 1<br>    ApptCount = 1<br>    varTextBox = "WB_TxtBox_NameWeek" & WeekCount & "Appt" & ApptCount<br>    <br>    Me.Controls(varTextBox).Text = "Hello"<br><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>