Okay. I understand how it works, but my macro is set up with relative
positioning and if I go down, left, or up to set the cell that runs
this macro when edited the relative positioning screws up and places
the stuff in the wrong cells. I can change the relative positioning in
the macro but no matter what it will only work correctly if you exit
the cell in the one direction that accounts for the relative
positioning. I was wondering if I could only make this work by exiting
the cell to the right, or if that just isn't possible. If not that is
fine as well.

STEVE BELL Wrote:
Not sure of what you mean by "if you do anything besides hit "enter" "

The macros are set up to check if the cell you enter has anything in
it.
If the cell is blank than the macro will execute after the cell is
changed.
If the cell already has anything in it, nothing should happen.

Any action that sets the cell contents should activate the macro.
This includes things like "Tab", "Arror Key", and maybe code.

I am not aware of any errors that might occur, but am not positive.

Write back if you need more help.

p.s.
please retain the previous emails in your replys. It helps follow what
has
already been
written. Thanks...
--
steveB

Remove "AYN" from email to respond
"mrpunkin"
wrote in
message ...

Thanks, that worked great.

The next thing I need to know is if there is a way to make sure that
it
dies if you do anything besides hit "enter" when done filling in
that
field.


--
mrpunkin

------------------------------------------------------------------------
mrpunkin's Profile:
http://www.excelforum.com/member.php...o&userid=24809
View this thread:
http://www.excelforum.com/showthread...hreadid=383663



--
mrpunkin
------------------------------------------------------------------------
mrpunkin's Profile: http://www.excelforum.com/member.php...o&userid=24809
View this thread: http://www.excelforum.com/showthread...hreadid=383663