View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMania ExcelMania is offline
external usenet poster
 
Posts: 3
Default 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!!