LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Time entry macro (entering times via the keypad)

Pretty simple. I thought for sure I had tried that, but I obviously
overlooked it. It works. Thanks to both that helped.

Frank

On Wed, 20 Sep 2006 11:36:45 +0100, "Bob Phillips"
wrote:

Change

If Application.Intersect(Target, Range("A1:AV10000")) Is Nothing Then

to

If Application.Intersect(Target, Range("F1:G10000")) Is Nothing Then

 
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 enter time into cell using keypad only: MULTIPLE COLUMNS michaelberrier Excel Discussion (Misc queries) 1 January 2nd 09 03:34 PM
Automatically entering time and date to an entry Ashlee Excel Discussion (Misc queries) 2 October 4th 06 12:49 AM
Entering Time Macro [email protected] Excel Worksheet Functions 2 September 10th 05 09:09 AM
enter a time into a cell, have the cell show two times the entry johnp Excel Worksheet Functions 3 May 2nd 05 12:08 AM
Data Entry With Drop down Keypad cap Excel Discussion (Misc queries) 1 May 1st 05 09:10 PM


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