Selecting values in sheet list box using vba

R

Raj

Hi,

A worksheet has several list boxes (values in drop down lists). Is
there a way to select values in these list boxes through vba code?


Regards,
Raj
 
J

jamesdavey

if they are in a drop down (as in data -> validation -> list) then in
code you just set the cell value...

Range("A1").Value = "x" - as long as "x" is a value in your list...
 
R

Raj

if they are in a drop down (as in data -> validation -> list) then in
code you just set the cell value...

Range("A1").Value = "x" - as long as "x" is a value in your list...
Click to expand...

Hi,

The values are not in cells (using data validations). They are in list
box controls placed in the sheet.

Thanks and Regards,
Raj
 
Top