I have set columns to data-Validation, Formula-Custom, Formula=ISNUMBER(M:M) for say row M. The foemula does not allow me to enter text into the cells which is good but this column pull data from other sheets with a macro and it will take the text then. How can i have a column have and accept only numbers.

Tim wrote:
I have set columns to data-Validation, Formula-Custom,
Formula=ISNUMBER(M:M) for say row M. The foemula does not allow me to
enter text into the cells which is good but this column pull data
from other sheets with a macro and it will take the text then. How
can i have a column have and accept only numbers.

Hi Tim
one way: adapt the macro to test for text values for this cell.

Frank

How would i do that.

And some of the text values are inserted by other forms.

Hi Tim
as I don't know your code its difficult to say but somethere in the
code should be an insertion method. In this part of the code you have
to check if the entry is valid or not.
Another way would be to create a separate macro which will test your
column after the insertion and deletes invalid entries.

Frank

Tim wrote:
How would i do that.

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.