S
Scott B
Hello,
I'm seeking help on some VBA code. Should be fairly simple but I'm a littlestumped. 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.
Column A will be blank until the user types in a 5 digit number, so the code only needs to trigger if the number typed into a cell in column A is outside of the aforementioned range.
So to sum it up once again, I'm looking for a msgbox if the following criteria is simultaneously met-
*If K1 = 3 (meaning that K1 equaling anything other than 3 wouldn't causethe msgbox)
*And values typed in column A are less than 80000 or are greater than 86666(meaning that values typed in between 80000 - 86666 wouldn't cause the msgbox.)
Does this make sense?
Thank you,
I'm seeking help on some VBA code. Should be fairly simple but I'm a littlestumped. 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.
Column A will be blank until the user types in a 5 digit number, so the code only needs to trigger if the number typed into a cell in column A is outside of the aforementioned range.
So to sum it up once again, I'm looking for a msgbox if the following criteria is simultaneously met-
*If K1 = 3 (meaning that K1 equaling anything other than 3 wouldn't causethe msgbox)
*And values typed in column A are less than 80000 or are greater than 86666(meaning that values typed in between 80000 - 86666 wouldn't cause the msgbox.)
Does this make sense?
Thank you,