+ Reply to Thread
Results 1 to 4 of 4

First Crack at a simple Visual Basic Execute FAIL!!!!!!!

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    First Crack at a simple Visual Basic Execute FAIL!!!!!!!

    I have been working on this sheet for a while. I want to make a simple Form that my team can fill in and let me know what sheets are missing for payroll. when I run the run sub/ User Form I get a Compile error. I changed the method where VB says there is an error but nothing. I also gave it a command to open to the form when the excel file opens and that failed too. Any help would be appreciated. I searched the form but found nothing like this situation. I have spent way to much time on this to give up.

    GCT MISSING DOC TEMPLATE.xlsm

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: First Crack at a simple Visual Basic Execute FAIL!!!!!!!

    take a look at the attached and see if it works for you.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-13-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: First Crack at a simple Visual Basic Execute FAIL!!!!!!!

    OMG you got it. I am looking over the code in the VB to learn and just wanted to thank you for taking the time to help out.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: First Crack at a simple Visual Basic Execute FAIL!!!!!!!

    You are welcome. You had not changed field names from the source you copied from to your textbox names primarily. Additionally, needed to delete the blank rows above the table and below the headers to make it work properly. Good Luck with your project.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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