Hello,
I am creating a dropdown. And I have 2 quick questions.

Lets say I create like this

Sub bbb()

Dim objDD As Excel.DropDown

Set objRange = Range("J13")
Set objDD = ActiveSheet.DropDowns.Add( _
Range(objRange.Address).Left, _
Range(objRange.Address).Top, Range(objRange.Address).Width,
Range(objRange.Address).Height)

objDD.Display3DShading = True
objDD.AddItem ("11")
objDD.AddItem ("22")
objDD.Name = "combobox1"

End Sub




How can I set the default displayed value, to "22"?

From some cell. Lets say A1. How can I display the value? I tried: A1
"=combobox1". and did not work.

thanks for any help