VBA code to allow the user to enter only numeric data in excel range?

[ffantom]

I have an input range of 6 columns and 12 rows where the user can enter numbers which are to be calculated later. I am confused though how to determine whether the range has numerals only. Otherwise the output would throw an error. Is there a way to avoid this error?

 

[Smitty]

Welcome to the Board!

You can use Data Validation to force only numeric entries. Select the range in question and goto Data-->Validation-->Allow (choose Whole Number or Decimal), then input the range of numbers you want to be allowed for entry.

If a user tries to enter anything other than specified they'll get an error message.

HTH,

 

[ffantom]

Wow!!!!!

That was easy to do

Thanks sooo much!!!!!!