+ Reply to Thread
Results 1 to 2 of 2

Userform open with workbook issue

  1. #1
    Registered User
    Join Date
    06-16-2012
    Location
    Englewood ,Fl
    MS-Off Ver
    2007
    Posts
    7

    Userform open with workbook issue

    I have created a workbook with a userform that collects data, does math, puts data into a form and prints it. I set it up to where it runs the userform when the workbook opens and that it where the issue begins. Everything opens and the macros all appear to work just like thaty should the problem is the tab function. As I tab through the entry boxes the first text box it comes to I t highlights the instructions already in it but if you try to tab past it like you have no entry to make, it actually erases the text and tabs in the text box instead of just moving to the next entry box. If I just run the userform from developer it works fine. I know I can put a button in and run the userform after I open it but that is an extra step that I shouldn't need. Any ideas as to what is happening and why. I have attached the file, with the auto print function disabled.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-16-2012
    Location
    Englewood ,Fl
    MS-Off Ver
    2007
    Posts
    7

    Re: Userform open with workbook issue

    oddly enough I opened it a couple more times and it started behaving correctly thank you for any that tried to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to Open 2nd workbook from userform, then close 2nd Userform
    By bigfoot007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2012, 02:03 PM
  2. Workbook.open file ext issue
    By Roget168 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2011, 04:07 PM
  3. Issue with Open Workbook
    By unley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2009, 08:05 PM
  4. Workbook Open macro issue
    By icemaiden in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-12-2008, 07:36 PM
  5. workbook open event issue
    By Kanan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2006, 01:20 PM

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