Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Userform button - shortcut key?


Usually when creating a menu item or the such like an ampersand denotes
which letter you want as a shortcut key.

How can I emulate the same behaviour on a button on a userform?

Cheers in advance,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=542108

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Userform button - shortcut key?

Hi Matt,

Put your shortcut letter in the Accelerator property of the control. If the
letter is in the controls caption it will be underlined.

Regards,
Peter T

"MattShoreson"
wrote in message
...

Usually when creating a menu item or the such like an ampersand denotes
which letter you want as a shortcut key.

How can I emulate the same behaviour on a button on a userform?

Cheers in advance,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:

http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=542108



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Userform button - shortcut key?


thanks Peter T


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=542108

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
what is the shortcut for 1/2 using the Alt button ? hbmonrny Excel Discussion (Misc queries) 4 May 25th 09 08:08 PM
Save button-shortcut mhanley Excel Worksheet Functions 0 November 8th 06 03:13 PM
Looping procedure calls userform; how to exit loop (via userform button)? KR Excel Programming 6 July 27th 05 12:57 PM
Button Shortcut / Key Stroke Dan Excel Programming 4 May 27th 05 07:22 PM
how to send a workbook shortcut as attachement in an e-mail from a userform Valeria[_2_] Excel Programming 5 January 22nd 04 12:02 PM


All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"