ExcelHelpPls
New member
- Joined
- Aug 9, 2018
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
Hello,
I am looking for some help regarding a couple issues. The first, I have a form where there are several options which can be selected and require different fields to be submitted based on the selection. Is there a way to express these fields are required more than with data validation highlighting them based on the selected value?
The second issues, how can I make a tab flash or become highlighted if a choice is selected. For example, someone chooses choice B, I would like Tab B to flash or become highlighted to alert the user they must move to that tab next.
Referring to the first issue, another solution could be to create a message box with VBA depending on the selection of a cell where if Cell a1 = "Form3" then beforeclosing the worksheet a message box will pop up to remind users to go to tab 3.
Thanks for the help.
I am looking for some help regarding a couple issues. The first, I have a form where there are several options which can be selected and require different fields to be submitted based on the selection. Is there a way to express these fields are required more than with data validation highlighting them based on the selected value?
The second issues, how can I make a tab flash or become highlighted if a choice is selected. For example, someone chooses choice B, I would like Tab B to flash or become highlighted to alert the user they must move to that tab next.
Referring to the first issue, another solution could be to create a message box with VBA depending on the selection of a cell where if Cell a1 = "Form3" then beforeclosing the worksheet a message box will pop up to remind users to go to tab 3.
Thanks for the help.
Last edited: