Hi everyone,
I'm very new to all this and have been working on a project to help out with work. I've been following some online videos and tried some different stuff I've found on these forums, but still am at a loss on how to fix the errors.
The first one was a 'block if without end if', but following some replies i saw on different threads i added a extra 'end if' and now its become a 'for without next' error. That is for a user-form error messagebox I'm trying to have. When someone doesn't fill in all the fields, i want the message to play and the data to not be added to the spreadsheet until this is complete.
The second is 'Object variable or with variable not set'. That is for a macro i recorded basically using a combo box to select different options to filter the data (i know i could basically just use a filter, but i think this would be more user friendly).
The whole project has become exceedingly messy. I've got a lot of random code lines in there that i have no idea where they come from.
I've attached a copy of my project.
Thanks for any help people can provide. I'm sorry if questions are a bit stupid.
Regards,
Bookmarks