I am looking for code that is still driving me mad
What I need is that when a row is selected a button is to appear in the Delete Row Column allowing the user to delete that row with the message: "Are you sure you wish to delete this row [Name Row Number] as this action cannot be undone"
The Table [ProductList] is in Sheet [Product List] and contains the following columns:
Category
Item Description
Product #
Price
Unit
VAT
Nett Price
Delete Row
I have attached the code so far as a picture and I get an error at Set tbl = ws.ListObjects("ProductList") of "Subscript out of range"
Thanks for looking
What I need is that when a row is selected a button is to appear in the Delete Row Column allowing the user to delete that row with the message: "Are you sure you wish to delete this row [Name Row Number] as this action cannot be undone"
The Table [ProductList] is in Sheet [Product List] and contains the following columns:
Category
Item Description
Product #
Price
Unit
VAT
Nett Price
Delete Row
I have attached the code so far as a picture and I get an error at Set tbl = ws.ListObjects("ProductList") of "Subscript out of range"
Thanks for looking