Hello everyone,
To start, I've looked far and wide for a specific solution to this, so I apologize if this ends up being redundant to another thread.
I currently have a code written for a userform with dynamic dependent combo boxes the user picks from in order to identify a specific part number they would like to remove from a bill of materials.
When the user clicks submit, once all fields are filled out, the code below logs the part number (cmb_RemovePN) and quantity (tb_RemoveQTY) to a removal log on (sheet 2).
Userform.JPG
What I am trying to do is add to my userform VBA code so that when I click the submit button, excel finds the value chosen in the part number combo box (cmb_RemovePN) in range (sheet 8, column "F") and changes the matching part number in that location to the word "Replaced".
I've been able to find examples of how to do this via setting up a find value & replace value table, or by setting specific find and replace values in the code itself, but in my entry each part number entered will be different, while the replacement word "replaced" will remain the same.
The data that my dependent drop-down boxes uses is a match to the part numbers shown on the sheet I want to update, so there won't be an instance of "no part number found.
This is my first post, so please just let me know what else you need from me. Your help is greatly appreciated.
Bookmarks