Allow a module sub to access a sheet object 1

[TRHorn]

I have a sub in a module, it has to be in this module so it can't be located in the sheet I'm operating in.

I have a combo box loacated on a sheet. I need to access the values in the combo box from the module.

Any Ideas? Can I some how dim the combo box in the module?

 

[jges]

If the sub always needs these values, you could pass the combobox to the sub when you call the sub.

SubDoSomething(cboComboBox)

 

[SkipVought]

hi,

  with Sheets("The Sheet with control").shapes("The control name")
    'now access the control's properties & methods.

  end with

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[TRHorn]

That is exactly what I needed thanks!