Easy Macro question

[AussieRed]

I have to write a macro that does a calculation on a number entered into an input box. I must prevent 3 errors from occuring:
NullEntry error
TextEntry error
Range error
If 3 errors occur I must produce a message box that lists them. For example:

NullEntry error = 1
TextEntry error = 2
Range error = 0

I have been able to do all this, except that my counts are wrong. Any suggestions?

 

[Richie(UK)]

Hi AussieRed,

Please can you post your code so we can see what you have done?

Also, what do you mean by your 'counts are wrong' ?

 

[Andrew Poulsom]

Have you tried using Excel's InputBox Method instead of VBA's InputBox Function?

It includes a Type argument which specifies the return data type. Excel deals with any entry errors.

Example, to prompt for a number:

Answer = Application.InputBox(prompt:="Enter a number", Type:=1)