LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 516
Default How can I check if the ActiveSheet has keyboard focus?

What I'm trying to accomplish is essentially the following:

If ActiveSheet.IsKeyboardFocused = True Then
[Do Something]
End If

Unfortunately, ActiveSheet/Worksheet does not have the IsKeyboardFocused
property (I pulled this property from a Button control as a functional
example).

Is there a way to accomplish this If statement?

Thanks,
Matt
 
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
How to change check box name using mouse and keyboard Naum Charts and Charting in Excel 2 December 4th 07 02:36 PM
how can I check for cell focus inside a spreadsheet ? EdwardAlanzo Excel Worksheet Functions 2 May 16th 07 12:41 AM
How do I get the focus on a check box? reneatwork New Users to Excel 1 September 15th 06 02:52 PM
Check for Enter key and change focus? NooK[_40_] Excel Programming 5 August 3rd 04 01:35 PM
Check if activesheet is protected freseh Excel Programming 1 January 30th 04 03:02 PM


All times are GMT +1. The time now is 10:46 AM.

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

About Us

"It's about Microsoft Excel"