Code to export value from ComboBox

macropod · #1 05-25-2011, 02:29 AM

Hi ilkks,

Try:

Code:

Private Sub cmdOK_Click()
Selection.Fields(1).Code.Text = "MACROBUTTON Update " & cboFood.Value
Unload Me
End Sub

where 'Update' is the name of the sub called by your MACROBUTTON.

ilkks · #2 05-25-2011, 03:16 AM

Thank you for your reply macropod.

I can see and choose all values in the UserForm/ComboBox, but when I press cmdOK_Click-button it says:

Code:

Run-time error: 5941
The requested member of the collection does not exists.

The sub called by my MacroButton is called FoodDropDownList, and it is like this:

Code:

Sub FoodDropDownList()

    frmTesti.Show
    
End Sub

And therefore here is the code I tested by your instructions which makes the run-time error:

Code:

Private Sub cmdOK_Click()

Selection.Fields(1).Code.Text = "MACROBUTTON FoodDropDownList" & cboFood.Value
Unload Me

End Sub

ilkks · #3 05-25-2011, 03:21 AM

Post removed

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Textbox updating from combobox selection	paxile2k	Word VBA	0	10-26-2010 02:30 PM
How to use the content of a combobox for {IF} field?	Melaanie	Word	0	06-14-2010 02:00 AM
Array into ComboBox + Macro-Text into ActiveDocument	Vivi	Word VBA	1	01-27-2010 07:03 AM
Combobox manipulation	vsempoux	Word VBA	3	10-31-2009 08:58 AM
Export/Import	Arkmom	Outlook	0	03-31-2009 02:47 PM