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..