Message 1 of 2
combining variables VBA loop text number display concatenate
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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:
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