combining variables VBA loop text number display concatenate

combining variables VBA loop text number display concatenate

andrew_canfield
Collaborator Collaborator
414 Views
1 Reply
Message 1 of 2

combining variables VBA loop text number display concatenate

andrew_canfield
Collaborator
Collaborator

Thankyou - this is a pretty frustrating process but i think I've made 2% progress!

 

Breaking this down into tiny steps, this step is put a value in a box (will be part of a drawing number) - Go & find :

I've tested bits & can open & print drawings - just need input a list - this is what I have:

stepping1.JPG

 

 

 

The problem is :

 

For Y = 1 To 5
X = Y
xx = "a" & X
MsgBox xx
Next

 

Returns a1, a2, a3 etc - obviously

 

I'd like it to show the contents of textbox, a1, a2, a3.

 

If I replace   "a" & X with a4 - then it does show the contents of the text box a4 ?? 

 

I know it's pretty basic, this is crawling before walking, before running,

 

'Walking' would be typing in a list of unknown length - adding to an array then picking each entry out of the array.

 

Regards

 

Andrew

 

 

 

 

0 Likes
415 Views
1 Reply
Reply (1)
Message 2 of 2

tdant
Collaborator
Collaborator

Those textboxes have names, and you can use the .Text property of those boxes to get what they contain. In my case, TextBox1.Text would return a nil string.

Capture.PNG

0 Likes