help code vlookup on userform

abdelfattah

Board Regular
Joined
May 3, 2019
Messages
87
hello

i have sheet1 contains data from a2:d10 and userform contains textbox1,2,3,4
i would when i write in textbox2 it shows me the rest data in textbox1,3,4 the textbox1 connect column a textbox2 column b textbox3 column c textbox4 column d with considering column b contains number and string like this 2400r35** 1200r20 ..etc
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,038
So when you enter a value in TextBox2 you want text to automatically appear in TextBox 1 3 and 4

So what do you plan to enter in TextBox2

Will it be the data in sheet1 column 2

So if you have in columns 1 to four

George Is Really Nice

You want to enter Is into Textbox2 and have George entered into TextBox 1 and Really entered into Textbox3

And Nice entered into TextBox4

Is that what you want?

If not please explain
 

abdelfattah

Board Regular
Joined
May 3, 2019
Messages
87
So when you enter a value in TextBox2 you want text to automatically appear in TextBox 1 3 and 4

So what do you plan to enter in TextBox2

Will it be the data in sheet1 column 2

So if you have in columns 1 to four

George Is Really Nice

You want to enter Is into Textbox2 and have George entered into TextBox 1 and Really entered into Textbox3

And Nice entered into TextBox4

Is that what you want?

If not please explain
yes

it's very simple buddy fill textbox2 automatically show the rest data in texbox1,3,4
 

Forum statistics

Threads
1,077,784
Messages
5,336,332
Members
399,076
Latest member
vullistax

Some videos you may like

This Week's Hot Topics

Top