Capture Current Selection in a Combo Box

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

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
 
If you're working on a module, you need to refer to the combobox in its
container (form). So if your form is called UserForm1 you would have
something like this:

MySelection = UserForm1.ComboBox1.Value

Also if you're using Option Explicit at the top of your code, you need to
declare the dimension of MySelection.
 
Assuming you meant a worksheet based ComboBox from the
Control Toolbox toolbar:

Sub GetComboValue()
Dim txt As String
txt = ActiveSheet.OLEObjects("ComboBox1").Object.Value
MsgBox txt
End Sub

Regards,
Greg
 
Back
Top