I'm new to VBA and have really been struggling to get this to work!
I have a sheet that has a list of customer contract names in "A" and a user form that has a drop down with all those names in. I've managed to write a VBA to find the row corresponding to the contract name but then want to copy the data from a textbox into the next blank column in that row.
Example
Contract Name: Test (Row 1)
Next Blank Cell in row 1: D
Data in text box : 23/11/96
So when i click the save button on my user form i want it to match the dropdown selection with the corresponding contract in column A, then find the next blank cell in that row (D) and put the date (23/11/96) into that cell.
I'm not great at explaining this but would appreciate someones help.
I have a sheet that has a list of customer contract names in "A" and a user form that has a drop down with all those names in. I've managed to write a VBA to find the row corresponding to the contract name but then want to copy the data from a textbox into the next blank column in that row.
Example
Contract Name: Test (Row 1)
Next Blank Cell in row 1: D
Data in text box : 23/11/96
So when i click the save button on my user form i want it to match the dropdown selection with the corresponding contract in column A, then find the next blank cell in that row (D) and put the date (23/11/96) into that cell.
I'm not great at explaining this but would appreciate someones help.