VBA for Warning on Button if Criteria in Another Cell is Not Within Defined Parameters

[Winston_Smith]

Hello People,

If cell A1 is not with pre-defined parameters, I would like code for a warning to pop up and cancel execution of the macro assigned to a format control button when clicked. Any takers?

Thanks in advance .....

 

[Joe4]

If cell A1 is not with pre-defined parameters

Please describe what you mean by this.

 

[Winston_Smith]

Sorry, I have a problem of being too verbose.

For simplicity's sake, the target cell A1 must be between 1 and 100, I can adapt to suit.

 

[Joe4]

Just wrap your VBA code in and IF...THEN block, i.e.

If Range("A1")>=1 and Range("A1)<=100 Then
    'Your code here
End If

Then it will only run when those conditions are met.