Assign value to Excel ActiveX Combo Box from Access

[mmogul]

I am attempting to set the value of a combo box (ActiveX) on an excel file using Access vba. The worksheet is referenced as xlWS (defined as Worksheet). If the excel combo box is named "cmbSelectType", what is the code to reference the Excel combo box and update the selected value from Access?

Thanks.

 

[SkipVought]

hi,

with xlWS.Shapes("cmbSelectType").OLEFOrmat.Object

end with

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}