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

Macros do not pause to wait for keyboard input as you are requesting. There
are event that you can catch such as change, selection change or such. That
bieng said Ctrl+B is bold and Ctrl+I is italics...
--
HTH...

Jim Thomlinson


"Oshtruck user" wrote:

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

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

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

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

Jim
I realize now what you meant. Yes, that is a good idea for the OP.
Otto
"Otto Moehrbach" wrote in message
...
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..