Hi Ramit,

In addition to Joel's response, you can set the
CommanButton's Default property:

'===========
Private Sub UserForm_Initialize()
Me.CommandButton1.Default = True
End Sub
'<<==========

Then, hittting the Enter key will call the
Command_Button code.

Typically, you might set the default property
for a Cancel button on your form.


---
Regards.
Norman


"Ranjit kurian" wrote in message
...
I have developed a forms through excel VBA, and the forms contain text box,
option button, commandbutton etc....

I need a macro code to create shortcut key to my commandbutton and
optionalbutton, for example : if i have a commandbutton called as Cancel,
the
"C" of the Cancel button should be underlined, so that the user when they
select Alt+C that particular commandbutton should be activated/action to
be
performed.