How to set a value in a list?

  • Thread starter Thread starter ExcelMania
  • Start date Start date
E

ExcelMania

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!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Find string from column A in Range("B2:F7") list the header of that column/s 5
Arrays and scattered cell values or another way? 16
How to hide password? 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Iterating through a ComboBox's values 6
Combine 2 columns in a dynamic range into one 7
Code to change a named range 2

Back
Top