Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 101
Default select [a1]cell when hotkey(ctrl+q) pressed, after userform load



i want following.
first userform load and activate in modaless
and then press the ctrl+q then select "a1" cell on the sheet.
my code is following

sub te()
userform1.show 0
Application.OnKey "^q", "sbow"
end sub

sub sbow()
activesheet.[a1].select
end sub

*** Sent via Developersdex http://www.developersdex.com ***
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
need to select the next row every time a CommanButton is pressed cj2k2k Excel Discussion (Misc queries) 4 August 14th 07 02:50 PM
detect ctrl-c was pressed (in copy mode) from vba? Mad Scientist Jr Excel Discussion (Misc queries) 3 October 29th 06 06:34 AM
LOAD userform JohnTheTemp Excel Programming 2 September 9th 05 12:45 AM
Excel 2000 Load Userform when clicking cell scain2004[_3_] Excel Programming 8 May 2nd 04 04:10 AM
Load a Userform Nick Excel Programming 1 September 10th 03 03:24 PM


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