Thread: ComboBox value?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dksaluki dksaluki is offline
external usenet poster
 
Posts: 48
Default 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