Eurekaonide
Active Member
- Joined
- Feb 1, 2010
- Messages
- 433
OK Apologies for this as I'm sure I have done this before but cannot think how 
I have some data that a user picks from a user form and drop down comboBox14, now I want the data chosen in the drop down combox14 to be populated back into a cell in the worksheet once the user form is closed down. The issue I have is its updating data which is already in place.
Therefore it needs to look to ListBox2 to see what data line (Row) its updating and then update (Lets say Column H) with the new data.
I can only get it to work by dropping to a new line using a NextRow count type of thing similar to the below;
Any suggetsions much appreciated
I have some data that a user picks from a user form and drop down comboBox14, now I want the data chosen in the drop down combox14 to be populated back into a cell in the worksheet once the user form is closed down. The issue I have is its updating data which is already in place.
Therefore it needs to look to ListBox2 to see what data line (Row) its updating and then update (Lets say Column H) with the new data.
I can only get it to work by dropping to a new line using a NextRow count type of thing similar to the below;
HTML:
Cells(RowSource, 27) = ComboBox14.ValueAny suggetsions much appreciated
