I have a userform that enters discontinued items into a log on "sheet 1"
I have a checkbox, that I need to work like this: If checkbox is checked, then the form needs to find the data matching txtItemNum (Item Number Field) in column 1, then delete only the first 9 cells in the row, then shift cells up. Here is my form.

Attachment 385088

Here is my code it goes into. It needs to be at the bottom where I have entered the checkbox IF statement.


Please Login or Register  to view this content.