ComboBox value?
I'm writing code in a module, and I want to get the value of a certain
ComboBox that I've added to Sheet1 tab. Is that possible, or can I
only reference the combobox while writing code IN THE PRIVATE SUB for
that control? ....as in:
Private Sub ComboBox1_Change()
//somewhere in here only
End Sub
If i'm outside the sub, how do i reference it? is it something like,
Sheet(1).Shapes(".....")....something something....?
I'd appreciate any help.
dck
|