Results 1 to 11 of 11

2 different errors im struggling with

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    15

    2 different errors im struggling with

    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,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Struggling with IF
    By KClark in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2011, 04:37 AM
  2. struggling
    By Tomas mcD in forum Excel General
    Replies: 1
    Last Post: 03-07-2011, 08:25 AM
  3. [SOLVED] Excel Throwing Circular Errors When No Errors Exist
    By MDW in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2006, 09:20 AM
  4. Struggling IF value
    By Rebecca in forum Excel General
    Replies: 5
    Last Post: 04-06-2006, 04:55 PM
  5. Help, I'm Struggling!
    By Fybo in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-04-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1