LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Number Validation

if isnumeric(mydata) then
Range("M1").Value = mydata
else
' mydata contains non numeric information
' do nothing
End if

--
Regards,
Tom Ogilvy

"Tim" wrote in message
...

How would i do that.





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation of UK VAT Number Rob Excel Worksheet Functions 24 October 18th 13 05:25 PM
custom validation with number & text aditya New Users to Excel 3 May 25th 09 10:36 PM
custom validation number and text aditya Excel Discussion (Misc queries) 1 May 25th 09 02:37 PM
validation for phone number Candice Excel Discussion (Misc queries) 3 April 28th 06 08:51 PM
attach a label to number, like validation but follows the number Rickster Excel Worksheet Functions 0 February 2nd 06 08:58 PM


All times are GMT +1. The time now is 05:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"