ComboBox value variable from active cell

Hi all,

i have a UserForm with a ComboBox in it. When the UserForm is opened I want the value in the ComboBox to always equal the value in column D that is the same row as the active cell. For example, it would be irrelevant which cell i select in Row 10. If my active cell is H10, AF10, G10 etc. when the UserForm opens the ComboBox will always equal D10, or if my active cell is on row 100 it will always equal D100 etc.

In the same UserForm I also have a submit button which will take the values from TextBox and ComboBox and paste them to cell ranges. Upon hitting submitBtn i want the value in the ComboBox to always be pasted back to the D column on the activecell row. Again, for example it is irrelevant what cell I am in on that row, if I am in cell H10, AF10, G10, when I hit submit the value in D10 will update to the ComboBox value.

This way when I open the UserForm the ComboBox will be populated with whatever is in D on that row, however if i change the entry in the ComboBox and then hit the submit buttion, the value in D will be changed to the new ComboBox value.

Here is my code so far which shows two textboxes values on opening the userform based on activecell.

Please Login or Register  to view this content.

Here is my code so far which shows two textboxes posting data to the activecell when the submit button is clicked.

Please Login or Register  to view this content.

That worked perfectly! thanks! can't believe it was something as simple as that, i've been trying to do all kinds of offset/indirect/index formulas.

Marks as solved and rep added!