keithaul
09-09-2016, 05:54 PM
I have a userform that has a combobox control on it. The rowsource property is set to a named range
My data source sheet has a column that is set up with a data validation where the criteria is set as a list and the source is the same named range as the combobox.
I have an update button on the userform for the purpose of updating my datasource sheet with the values from the user form
However when I want to update the field on the sheet that has the data validation on it, the value from my combobox does not get transferred to the sheet. Below is the code Im using:
Cells(currentrow, 2).Value = Me.cboCatg.Text
Why isn't the cell updating and how can I transfer the value I select from the combobox on the userform to the cell that has the data validation set?
I'm using similar code for the other form fields and my datasource sheet gets update with the values. However the other cells do not have the data validation set to a named range.
17064
My data source sheet has a column that is set up with a data validation where the criteria is set as a list and the source is the same named range as the combobox.
I have an update button on the userform for the purpose of updating my datasource sheet with the values from the user form
However when I want to update the field on the sheet that has the data validation on it, the value from my combobox does not get transferred to the sheet. Below is the code Im using:
Cells(currentrow, 2).Value = Me.cboCatg.Text
Why isn't the cell updating and how can I transfer the value I select from the combobox on the userform to the cell that has the data validation set?
I'm using similar code for the other form fields and my datasource sheet gets update with the values. However the other cells do not have the data validation set to a named range.
17064