Just imagine if you could.....

[Climber]

.....allow many months to go by between each occasion you use VBA.

You'd get so rusty that you'd forget how to do the simplest things.

I've a simple textbox collects a variable between 1-18. All I want to do is use that variable to point to a workbook sheet bearing a generic text name before that number.

So in other words, my code would look something like this ??????

Or am I way off ....?????

Private Sub CommandButton1_Click()
Dim myvar As Integer
myvar = TextBox1.Value
Sheets("name" + myvar).Select
UserForm1.Hide

End Sub

 

[patrickmuldoon99]

Untested, but I would use your code, adapted like so:

Private Sub CommandButton1_Click()
Dim myvar As string
myvar = TextBox1.Text
Sheets("name" & myvar).Select
UserForm1.Hide

End Sub

Hope this helps, Patrick.

 

[Climber]

One symbol makes all the difference, thanks

 

[erik.van.geit]

Hi, climber,

the only real mistake is your "plus"sign
Sheets("name" + myvar).Select
you can not "addup" strings

you need the "&" sign
Sheets("name" & myvar).Select

remark: in most of the case, you don't need to select anything within your code

example

Sheets(1).Range("A1") = 1

kind regards,
Erik