Select tablerow from combobox value and change row column value

[tspmgh]

Hi excelforum,

This is my first try at VBA so sorry in advance if the coding seems illogical, it is primarily based on my intuition.

I have a table (Tabel1) with 2 columns (ID# and Status) as well as combobox (pro_task_box) set to list both columns of the table.
I am looking for the user to be able to select a row from the combobox and with the click on a button change the value of the status field for the selected row to "complete".
I can't seem to get my code working - any help would be really appreciated. Thanks in advance.

My code looks like this:

Please Login or Register  to view this content.

[torachan]

Demo code is step by step readable, as you gain experience you would condense this to a few lines.
There is no need to search the Table for the Combobox value, you already know its ListIndex by default.
Any queries post back on this site.
Happy coding.
torachan.