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