| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel to take focus
With the following example messagebox the Ok button by default takes the
focus. What do I need to add to allow the Cancel button to take the focus? If IsEmpty(Cells(22, 11)) Then MsgBox "Cancel has the focus" Exit Sub End If Thank you if you can help out. Pat |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cancel to take focus
MsgBox "Cancel has the focus", vbOKCancel + vbDefaultButton2, ""
RBS "Pat" wrote in message ... With the following example messagebox the Ok button by default takes the focus. What do I need to add to allow the Cancel button to take the focus? If IsEmpty(Cells(22, 11)) Then MsgBox "Cancel has the focus" Exit Sub End If Thank you if you can help out. Pat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work | Setting up and Configuration of Excel | |||
| OK/Cancel box functionality? | Excel Discussion (Misc queries) | |||
| msgbox cancel? | Excel Discussion (Misc queries) | |||
| Cancel/Exit Sub | Excel Discussion (Misc queries) | |||
| Input Box Cancel | Excel Discussion (Misc queries) | |||
Hybrid Mode
