Hello,
I'm seeking help on some VBA code. Should be fairly simple but I'm a little stumped. Here is what I'm looking for in plain language:

If cell K1 = 3 and if the value of any cell in column A is < 80000 or is > 86666, then a msg box will pop up stating "Invalid range".

The user will be manually inputting 5 digit numbers into column A, but if they've selected cell K1 to equal 3 from a dropdown menu (which the user also does), then values less than 80000 or greater than 86666 are out of range, and the user should be alerted.

Does this make sense?

Thank you,