Sheet1.Combobox1.Value

Worksheets("Sheet1").OleObjects("Combobox1").Objec t.Value

--
Regards,
Tom Ogilvy

"Monique" wrote in message
...
I have created a module that will handle when a change occurs to the excel
worksheet in a combo box.

Depending on the selection value in the combo box, it will go to the
module
and change the format of the worksheet.

The problem is the module is not recognizing the combo box.

How can the module recognize the objects that are related to the
worksheet?