How to set a value in a list?
Is this a listbox control you are using or validation?
"ExcelMania" wrote:
Pl tell me how I can change the value on a list control. Currently when I say
Worksheets("A").Range("B2") = "1"
where B2 is actually a list with values (1,2,3), it does not actually change
the value of the list to 1..
How do I do this?
Thanks!!
|