If Then Statement - number above 25 - Excel VBA

[eemiller1997]

I have written IF Then Statements that said if a specific answer was selected, then take the following steps. But, how would I write an If Then Statement to state if any answer above 25 (so 26, 27, 28, 29, and so on) is given, then take the following steps?

The answer would always be a number or a range of numbers. Sometimes they will be 21 or another times 22-23, while another time a 27. If the number is above the number 25 then certain steps need to be taken and I want to create an if then statement to cover that.

Also, I want to create a dialog box that will warn the user they cannot combine 23-24. So, if they enter 23-24, I want a dialog box to pop-up and let them know they cannot use that number combination.

[oeldere]

Please Login or Register  to view this content.

Maybe you can use datavalidation for that.

Excel 2007 => data => datavalition.

[eemiller1997]

First I would like to tackle the if then for the answers 26 and above... any ideas on that one?

I'll have to look into this detavalidation option. Not yet familiar with it. Thank you for bringing it to my attention.

[AB33]

answer above 25 (so 26, 27, 28, 29, and so on) Are these names, or do they have cell addresses, if so,you can use the cell reference instead of numbers?

[eemiller1997]

I'm not following your question. What do you mean by names vs cell addresses. Basically, the user would enter into that text box on the UserForm the answer of a number.

[Norie]

Just test the value in the textbox.

This would work to chec if the value is more than a specific value, but you'll need to explain about the ranges
and where the 'limit' number comes from.

Please Login or Register  to view this content.

[eemiller1997]

Just test the value in the textbox.

This would work to chec if the value is more than a specific value, but you'll need to explain about the ranges
and where the 'limit' number comes from.

Please Login or Register  to view this content.

To make sure I understand this, the above limit = 26 would mean anything above 25 or above 26?

[Norie]

It's anything above 26 in the code I posted but you can change that to whatever you want.

[eemiller1997]

Thank you!