Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capture Current Selection in a Combo Box
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capture Current Selection in a Combo Box
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 -----Original Message----- 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capture Current Selection in a Combo Box
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
In a range of months can I capture the most current month entry? | Excel Discussion (Misc queries) | |||
capture text typed in Combo Box | Excel Programming | |||
Update on Current Selection | Excel Programming | |||
Capture listbox selection to a cell in a different sheet | Excel Programming |