hi
tad sketchy on the details but try this.....
assuming the name of your combo box is cmbYear....

cmbYear.value

Regards
FSt1

"inungh" wrote:

I have a combo box on the spreadsheet to let user select the option.

I wanted to print a field base on the combo box.

Are there any way to reference the combo box?

I tried to use "occurrence " & cmbYear, but I got error.

Your help is great appreciated,