Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
bw bw is offline
external usenet poster
 
Posts: 74
Default Hide UserForm with Keyboard?

Private Sub CmdClose_Click()
UserForm2.Hide
End Sub

Is there a way to accomplish this using the keyboard? For example, I'd like
to enter <ctrlc to accomplish the same thing.

Thanks,
Bernie


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 770
Default Hide UserForm with Keyboard?

Bernie,

Define an accelerator key in the properties window for the button. E.g., if
you use "C" as an accelerator that letter will be underlined on the button
and Alt-C will hide the Userform.

hth,

Doug

"bw" wrote in message
...
Private Sub CmdClose_Click()
UserForm2.Hide
End Sub

Is there a way to accomplish this using the keyboard? For example, I'd
like to enter <ctrlc to accomplish the same thing.

Thanks,
Bernie



  #3   Report Post  
Posted to microsoft.public.excel.programming
bw bw is offline
external usenet poster
 
Posts: 74
Default Hide UserForm with Keyboard?

Thanks a bunch, Doug!

Bernie

"Doug Glancy" wrote in message
...
Bernie,

Define an accelerator key in the properties window for the button. E.g.,
if you use "C" as an accelerator that letter will be underlined on the
button and Alt-C will hide the Userform.

hth,

Doug

"bw" wrote in message
...
Private Sub CmdClose_Click()
UserForm2.Hide
End Sub

Is there a way to accomplish this using the keyboard? For example, I'd
like to enter <ctrlc to accomplish the same thing.

Thanks,
Bernie





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
Hide Userform smokiibear Excel Programming 4 January 18th 05 06:54 PM
Hide Tab in TabSheet on UserForm bforster1[_18_] Excel Programming 1 October 4th 04 07:26 PM
Hide all images on userform Jason Morin[_3_] Excel Programming 3 April 26th 04 09:20 PM
Userform.hide / show papou[_7_] Excel Programming 0 September 15th 03 03:12 PM
hide a textbox on a userform? Bill Lunney Excel Programming 2 July 31st 03 08:57 AM


All times are GMT +1. The time now is 06:14 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"