Get cells value in textbox according to combobox slection in simple way

hi, everyone

i am using below code to get cells value in textboxes according to combobox1 selection

Please Login or Register  to view this content.

i have 125 textboxes here and my offset is till 126

like
TextBox3 = bul.Offset(i, 4) to,,,,TextBox125 = bul.Offset(i, 126)

i want to do this process in simple way..

thanx a lot

Hi,

I assume your code is in part of the userform? How about:

Please Login or Register  to view this content.

Loop through the textboxes, this example assumes there are 4 textboxes with the name TextBox1,TextBox2, ect:

Please Login or Register  to view this content.

Thanx a lot for reply both of you

I will try tomorrow morning...

@Arkadi

Wroking as i wanted

thanx a ton to you

And how about this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Why do you need to empty the textboxes before you populate them?

hello, davesexcel
Because every time i need to change the data of textboxes after pass data to worksheet?

hello, davesexcel
Because every time i need to change the data of textboxes after pass data to worksheet?

Okay, but the code you are using is clearing the textboxes and populating them again. The code doesn't care if the textbox is empty or not, it is going to change the value regardless.