Give this a look...

http://www.cpearson.com/excel/TextBox.htm
--
HTH...

Jim Thomlinson


"merritts" wrote:


I am writing a macro for the user to input a numeric value into a text
box. Is there a way to check to asure that the input value is
completely numeric?

thanks


--
merritts
------------------------------------------------------------------------
merritts's Profile: http://www.excelforum.com/member.php...o&userid=35803
View this thread: http://www.excelforum.com/showthread...hreadid=556594