Before the macro ends refer to the worksheet to take the focus off the textbox

range("A1").select



"Jim Palmer" wrote:


I don't know if this is related to your problem, but I made an
interesting discovery.

When I had a macro linked to a text box, the arrow keys stopped working
after the "Exit sub" line was reached.

When I had the macro linked to a button, the problem was no longer
encountered.

I would prefer it to be linked to a text box as it can be made to stand
out more than a button.

Sincerely

Jim Palmer


--
Jim Palmer
------------------------------------------------------------------------
Jim Palmer's Profile: http://www.excelforum.com/member.php...fo&userid=5210
View this thread: http://www.excelforum.com/showthread...hreadid=490740