| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I need a pop up message when a check box is checked
I have created a yes and no check box in an excel sheet. When anyone checks
the yes box, I want a pop up to appear saying 'you must also submit the main contract'. |
|
#2
|
|||
|
|||
|
I need a pop up message when a check box is checked
Hi, I don't know a lot about VBA but this should work for you. If CheckBox1.Value = True Then MsgBox "You must also submit the main contract", vbDefaultButton1 Else: Exit Sub End If insert this code into the checkbox code or into a macro. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=478025 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell Check Digit Formula | Excel Worksheet Functions | |||
| Check box so that only one box can be checked a time | Excel Discussion (Misc queries) | |||
| Preventing multiple check boxes from being checked | Excel Discussion (Misc queries) | |||
| check box, so when you click on it it inserts a check mark into t. | Excel Discussion (Misc queries) | |||
| Using a Check Box as a control item | Excel Discussion (Misc queries) | |||
Linear Mode
