using IF with InputBox Value

[mastias]

Dear All,

Below is the code that I am using to do some formatting on a workbook with 12 sheets namely: JAN, FEB...etc
An input box is used to make an input for staff no which is located in column D. The code works fine, except, when I test it with an invalid staff no., It still goes on to execute the code with the previously selected cell.

Any ideas? to control this situation.

Please Login or Register  to view this content.

[AlphaFrog]

You should remove the On Error Resume Next line as it is ignoring any errors. It's best to resolve code errors.

This should validate the Staff No. in column D

Please Login or Register  to view this content.

[mastias]

That's it, thanks very much. It's working

[mastias]

All functions are working but, this line of code has a problem, I don't know what

Please Login or Register  to view this content.

It's exiting the sub even with a value and also if a zero is entered.

Any Ideas?

Please Login or Register  to view this content.

[mastias]

Please Login or Register  to view this content.

It's working now, thank you all