ExcelBanter - Return key to "OK" a DialogBox

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Return key to "OK" a DialogBox (https://www.excelbanter.com/excel-programming/344688-return-key-ok-dialogbox.html)

donbowyer

Return key to "OK" a DialogBox

Could someone please remind me how to ensure hitting the RETURN key always
has the same effect as clicking the OK button on a UserForm.
--
donwb

Tom Ogilvy

Return key to "OK" a DialogBox

Set the Default property of the OK button to True.

--
Regards,
Tom Ogilvy

"donbowyer" wrote in message
...
Could someone please remind me how to ensure hitting the RETURN key always
has the same effect as clicking the OK button on a UserForm.
--
donwb

donbowyer

Return key to "OK" a DialogBox

Of course! Memory's not what it was. Thanks
--
donwb

"Tom Ogilvy" wrote:

Set the Default property of the OK button to True.

--
Regards,
Tom Ogilvy

"donbowyer" wrote in message
...
Could someone please remind me how to ensure hitting the RETURN key always
has the same effect as clicking the OK button on a UserForm.
--
donwb

All times are GMT +1. The time now is 12:18 PM.