Capture Current Selection in a Combo Box

[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

 

[Guest]

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.

 

[Greg Wilson]

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

 

[Randy]

Thanks, Greg. Exactly what I needed to know.