View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
jbjtc jbjtc is offline
external usenet poster
 
Posts: 17
Default vbYesNo, change carriage return

Thanks Kevin
Thats done the trick.
--
jj


"Kevin B" wrote:


MsgBox "Message Text", vbYesNo + vbDefaultButton2, "Titlebar Text"
--
Kevin Backmann


"jbjtc" wrote:

Hie, can anyone help with the following:

When you create a message box using vbYesNo function, when the box appears
on screen, is it possible to change the set-up so that when you press return
(carriage return) it will automatically select the "No" option. Standard
vbYesNo defaults to "Yes" option when you hit carriage return.

Any help would be much appreciated.

Thank you
--
jj