MarioMagnus
New Member
- Joined
- Jul 8, 2021
- Messages
- 14
- Office Version
- 2019
- Platform
- MacOS
Hi,
I need to loop with a value from a userform combobox.
I have a comboBox, that will be filled with different items. The selected item I will use it within a loop.
The error message are Variable required - can't start assign to this expression
I have no idea, how can I use the selected variable of the combo box for this loop.
Thanks and regards, Mario.
I need to loop with a value from a userform combobox.
I have a comboBox, that will be filled with different items. The selected item I will use it within a loop.
VBA Code:
For Each ComboBox_Familie.Value In NachName
vorlageWs.Cells(x, 6) = WorksheetFunction.XLookup(ComboBox_Familie.Value, NachName, VorName)
Next ComboBox_Familie.Value
The error message are Variable required - can't start assign to this expression
I have no idea, how can I use the selected variable of the combo box for this loop.
Thanks and regards, Mario.