I'm in the process of writing User Form code for a new project. Right now I'm writing the moduel to Add and Delete a product list, but it gives me an application-defined or object-defined error. Does any one know what I have done worng? I have highlighted in red where the error occurs. Hopefully, if I get past this error, my code will delete the product from the list!
Thanks for your help! I have attached a copy of the spreadsheet.
Please Login or Register to view this content.
redsab
Last edited by redsab; 07-05-2014 at 09:08 PM.
There is no column zero.
If ws.Cells(x, 0).Value = sProduct Then
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
AlphaFrong,
Thanks, I was thinking that the first cell A1 was (0,0). I guess I never wood have gotten that to work!
redsab
You're welcome.
For what it's worth, this uses the .Find Method to locate the product number.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks