tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,210
- Office Version
- 365
- 2019
- 2016
- Platform
- 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
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