Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hello Everyone, I am new to this post. I am stumped and figured I would ask the gurus. I am using VBA Excel to create a UserForm that will allow the user to select a value from ComboBox1 and another Value from Combobox2 and based on the two selections Textbox3 is populated with a message that I define. For Example: If the user choose China from Combox1 and USA from Combobox2 Then the result display in Textbox3 would be "you will pay taxes here after 184 days" The problem is in column A and B of the spreadsheet I have 146 countries ( the fill for combo boxes 1&2), so to use an If..Than...Else statement would be extremely labor intensive. Could anyone help? ![]() -- Mr. Jay ------------------------------------------------------------------------ Mr. Jay's Profile: http://www.excelforum.com/member.php...o&userid=32350 View this thread: http://www.excelforum.com/showthread...hreadid=521070 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
searches slow on some computers fast on others? | Excel Discussion (Misc queries) | |||
Searches slow for some Fast for others? | Excel Worksheet Functions | |||
how do I set up a fast comparison table? | Excel Discussion (Misc queries) | |||
Fast Fourier Transform | Excel Worksheet Functions | |||
IS THERE A FAST WAY TO CHANGE THE ORDERS OF CONDITIONAL FORMATTIN. | Excel Discussion (Misc queries) |