+ Reply to Thread
Results 1 to 5 of 5

unsure of IF statement

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    80

    unsure of IF statement

    I have a userform that enters data on a spreadsheet. I would like to prvent this if any form textbox is blank. I think that I know about the IF statement in excel, but I can not figure out how to get it to work using forms.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: unsure of IF statement

    Here you go... try this out.

  3. #3
    Registered User
    Join Date
    03-07-2013
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: unsure of IF statement

    You Are the man. Answer to my question and stream line my code as well. Thanks are not enough, But THANKS anyway.

  4. #4
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: unsure of IF statement

    You are very welcome, glad I could help you out. Please click the star in the lower left of my post. Thanks

  5. #5
    Registered User
    Join Date
    03-07-2013
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: unsure of IF statement

    I did and it said I could not give to reputation twice. I wish I could, you deserve it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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