Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter time into cell using keypad only: MULTIPLE COLUMNS
I found Chip Pearson's excellent code for entering times without
having to use the ":" key, but I am only able to do it in a single column. Is there a loop I can use so I can do it with multiple columns? Trying to insert another column reference or another sub generates an error. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter time into cell using keypad only: MULTIPLE COLUMNS
There's a line in Chip's code that looks like this:
If Application.Intersect(Target, Range("A1:A10")) Is Nothing Then Exit Sub End If Change it to whatever range you want: If Application.Intersect(Target, _ Range("A1:A10,b7:q13,x9,z1:ai17")) Is Nothing Then Exit Sub End If michaelberrier wrote: I found Chip Pearson's excellent code for entering times without having to use the ":" key, but I am only able to do it in a single column. Is there a loop I can use so I can do it with multiple columns? Trying to insert another column reference or another sub generates an error. Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
Lost ability to enter Carriage Returns using numeric keypad | Excel Discussion (Misc queries) | |||
how do I make a multiple columns in a single space? (press enter | Excel Discussion (Misc queries) | |||
HOW DO I enter today on a laptop that has no numeric keypad | Excel Discussion (Misc queries) | |||
enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions |