access controls on the spreasheet
 

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,

access controls on the spreasheet
 

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,