VBA loop on TextBoxes and give them a value

[makiwara]

Hi!

I'm stuck with my idea. I tried to figure out but seems complicated.

There is an Excel table where there are TextBoxes inserted, something like:

TEXTBOX
empty row
TEXTBOX
empty row
empty row
TEXTBOX

...

So the main thing is that there aren't overlapping textboxes.

Is it possible to loop through them? From above to down?

And give each a value?

Cells:

red apple healthy
yellow zitrone delicious
...

Textbox1: red
T2: apple
T3: healthy
T4:yellow
T5: zitrone
T6: delicious

(Every 3. TextBox has the same size, since we have 3 different data to put in)

Thank you very much for your help!

 

[ranman256]

Why do you need textboxes?
the sheet has a million cells. Can't you just use a cell?

 

[makiwara]

Thank you. I can't use cells, since I insert a picture as background and the textboxes are on the pictures. Every textbox has to have a different value, based on algorythm written above.

Thank you for your help!

 

[makiwara]

I tried to solve, but seems impossible to loop through userforms. (they have an ascendent order, so looping through 1-2-3 and so on would be great.
In my example I want to add Cells(2,2).Value to all textbox-es, through loop.

If I knew how to do this, I would be able to modify the code to suit my needs. Thank you if somebody have an idea! Have a very nice day!

Sub test()


Dim i As Integer
For i = 1 To 100 Step 1


temp = TextBox & i


temp.Text = Sheets("2").Cells(2, 2).Text


Next




End Sub

Why do you need textboxes?
the sheet has a million cells. Can't you just use a cell?

 

[makiwara]

Anybody? I am really sorry to ask this silly question, but I find solution just working with former versions of Excel, not 2016