About Us

Donkin[_7_]

I have a macro which I want to give an error message if text is entere
instead of a number.

I would like something like

If range("a1").value = istext then _

If range("a1").value = isnumber then _

I want to tell the user that they have not inputted a valid number.

Any help appreciate

--
Donki
-----------------------------------------------------------------------
Donkin's Profile: http://www.excelforum.com/member.php...fo&userid=2371
View this thread: http://www.excelforum.com/showthread.php?threadid=37703

mangesh_yadav[_271_]

You got a reply in another thread:
http://excelforum.com/showthread.php?t=377020

You could use:
If IsNumeric(Range("A1")) then

will return true for numbers and false for text

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=37703

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to tell if Cell is Text or Number	Donkin[_6_]	Excel Programming	3	June 7th 05 02:49 PM
Macro to change a number to text	Lori F.	Excel Programming	0	November 11th 03 04:28 PM
macro adding a number to a number already in a cell	Tom Ogilvy	Excel Programming	0	October 18th 03 04:34 PM
macro adding a number to a number already in a cell	Don Guillett[_4_]	Excel Programming	0	October 17th 03 05:21 PM
macro adding a number to a number already in a cell	Ron de Bruin	Excel Programming	0	October 17th 03 04:59 PM

Menu

About Us