ComboBox Input

[girish.gv]

Hi... everyone in this blogspot will be very thank ful if u guys can solve this simple probs of mee...

i m trying to write a macro.....

i have a ComboBox and in that i have 1, 2, 3, 4,... and i have one TextBox

my question, if i click on 1 in ComboBox i should get some text msges in Textbox First line should say "MrExcel" second line should say "Thred" and third line should "ref No"... and same thing should continue if i click on 2 in combobox i should get "Post" in first line in second "New" in third line "Thread".....

Can u help me how to create this i will be very greatful for each and everyone who can help me out......

 

[Andrew Poulsom]

Please post real examples of what you want in the TextBox for each of the numbers chosen. You should be able to use a lookup table.

 

[girish.gv]

Hi,
I have a ComboBox and in that i have 1, 2, 3, 4,... and i have one TextBox

my question, if i click on "1" in ComboBox i should get some text msges in Textbox First line should say "DocumentName" in the next line "Dt of the Document" in the third line "Ref No" in the fourth line "List A doc" if i click on "2" i should get only "DocumentName" in the second line "Date" in the third line "List B" .. and so on...

However, wen i click on 1 all the things should appear in the text box and also if i click 2 i should get the different things wat i have mentioned and it should also remain the "1" items. it should not get clear.... so for this reason i m not looking lookup i m looking into a macro.. i think u got my question...

thanks for your patience and ask me about the dobuts wat u have i really appreciate if u can help me out this....

Thanks & Regards,
Girish