Help makeing text boxes apear if a combo box shows a certain result in a userform?

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
3,210
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Hi Everyone,

got a big question for you,

I have a user form I created and I want to make it a little better,
I'd like to be able to get it so if one of the words is selected from the combo box dropdown the 3 other cells appear but if they select a different word from the drop down the 3 text boxes stay hidden. I'd also like to make it compulsory for the 3 cells to have data in them if they are visible?
I'm a complete novice with user forms so any instruction please advise me where I insert the code as well if you don't mind, thanks

so what I want is if "Railways" is selected in "cboExpensetype" combo box then

Label8,

Label9,

Label10,

Textbox1,
Textbox2,
Textbox3,
or all visible and required fields,
but if anything else is selected
they are invisible.

can anyone tell me how to do this?

Thanks

Tony
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,225,072
Messages
6,182,699
Members
453,132
Latest member
nsnodgrass73

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top