Refer to Forms Combo Box

[tiredofit]

If my worksheet has an ActiveX combo box, I can refer to its value as follows:

Sheet1.ComboBox1.Value

How can I refer to a Combo Box's value if it's a Forms combo box and not an ActiveX combo box?

Thanks

 

[Fluff]

How about

With Sheet1.Shapes("Drop Down 1").ControlFormat
   Debug.Print .list(.Value)
End With

 

[tiredofit]

How about

With Sheet1.Shapes("Drop Down 1").ControlFormat
   Debug.Print .list(.Value)
End With

Thanks, worked as expected.

Happy holidays!

 

[Fluff]

You're welcome & thanks for the feedback.