View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randy[_10_] Randy[_10_] is offline
external usenet poster
 
Posts: 16
Default Capture Current Selection in a Combo Box

Hi,

I'm trying capture the current selection from a combo box (from the
Control Toolbox, not Forms). Example:

MySelection = ComboBox1.Value

I don't know how to refer to the combo box. I'm getting a compile
error (variable not defined). Please note, I am not working in the
private subroutine. I am working outside of the combo box code in a
general module.

TIA
Randy Eastland