Jim
Could you direct me to where I can get more information about hot key
macros? Thanks. Otto
"Jim Thomlinson" wrote in message
...
I would be more inclined to use hot key macro's. The last line of the macro
would take the user to the next cell in the range. That would be my 2
cents...

--
HTH...

Jim Thomlinson


"Otto Moehrbach" wrote:

The only way I can think of for what you say to work is to use an
InputBox.
Basically you would have a Worksheet_SelectionChange event macro that
would
do something when you click on a cell in a specific range (chosen by
you).
What it would do is present an InputBox and ask you to enter something
(what??). If you enter a "b" the macro would bold the cell, an "i" and
it
would italicize the cell, and so forth. Would this work for you? HTH
Otto
"Oshtruck user" wrote in message
...
I am looking for a macro that will run through a selected range of cells
that
will stop at each cell and wait for a keyboard button to be pressed,
and
depending on the button pressed will do different types of formatting.
Can
anyone help. I don't want this to work with a Dialog box or anything,
I
want
it to work with keyboard buttons. For example the first cell in the
range
it
waits for me to press a button. I press the b button and it bolds it.
The
second cell in the range it waits for me to press a button. I press
the i
button and it puts the cell in italics. And so on..