It is a control toolbox combo. I just inserted a module. Is this incorrect?

The combo box will effect other objects on the worksheet. The module isn't
reading the combo box so i know it won't read the other objects as well. Is
there a similar way to do this in a module or should i just make it a
procedure for the worksheet location?

"Bob Phillips" wrote:

What sort of combobox, and where is your module?

If it is a forms combobox, the assigned macro should go in a standard code
module.

If it is a control toolbox combo, you should check it the control's click
event.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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?