How to set a value in a list?
 

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!!

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!!