Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA code for drop down menu problem. | Excel Discussion (Misc queries) | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
recognizing double digit numbers in code | Excel Discussion (Misc queries) | |||
Data Validation - Code Not Recognizing Something | Excel Programming | |||
Recognizing something is being pasted in code. | Excel Programming |