Match ComboBox with dynamic range, then add Textbox1 to dynamic range

Hi,

I need to add a TextBox1 value (number, no decimals) to the correct cell in Sheet1. Which cell to add is dependant on choice made in ComboBox1 (numeric values). I have a code (attached) in UserForm1 that allows the user to add data to the range. The range is then populated in UserForm2, ComboBox1.

My problem is to match user choice in ComboBox1 with values in dynamic range ("L7").end(xlDown).Row, then add TextBox1 value to the adjacent cell to the right. I.e if the matching cell is L7 then the value of TextBox1 should be added to the existing value in cell M7.

I'm lost here and in need of an expert

Please Login or Register  to view this content.

Thank you very much Alphafrog. The code is perfect