Selecting values in sheet list box using vba
 

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

Selecting values in sheet list box using vba
 

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

Selecting values in sheet list box using vba
 

On Sep 1, 12:41*am, jamesdavey wrote:
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...

Hi,

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

Thanks and Regards,
Raj