Code Not Recognizing Value in Drop-Down Menu

[Paige]

I'm using VBA to put a drop-down list in a cell, with the following items a
user can select from: 1,2,3,4,5,6,7,8,9,10,11+

In later code, when I try to reference the response for this cell by saying:
If Target.Address = $C$1 Then
If Target.Value = "1", Then unhide rows xx:xx
If Target.Value = "2", Then unhide rows xx:xx
If Target.Value = "3", Then unhide rows xx:xx
.....it works fine. But when I get to
If Target.Value = "11+"
.....Excel does not recognize what to do. I need to keep the cell (C1)
formatted as a number.

Can someone advise how to fix this?

 

[Leith Ross]

Hello Paige,

Try this trick. Use the VAL(<string>) method to convert "11+" to a
number. VAL will convert upto the first non numeric character. Except
for things like scientific notation, exponents and sign prefixes.

This should work with no problem
If Val(Taget.Value) = 11 Then

Sincerely,
Leith Ross

 

[Paige]

Leith, you are WONDERFUL...works like a charm! Thanks so much!