how to deleteing the row of corresponding combobox value row.

[rrosa1]

hi all
thanks to this forum i created the simple workbook. one user form i need help to code the command button to delete the row after entering the data.As u can see in the code .i have first worksheet "Brought" it populate the two combo box in user form.
after entering the data in to the worksheet "Historical Data" i need to put the VB code to delete the same records Row (row corresponding to the combTicker value) from the work sheet"Brought" so there will be no redundant data in work sheet"Brought"
any help will be greatly appreciated.
i am new to VB coding so pl soft on me.
thanks

 

[Trevor G]

Welcome to the forum, sorry to say you didn't attach your workbook, if you can attach it I will take a look for you.