+ Reply to Thread
Results 1 to 1 of 1

VBA Excel 2007 Date Picker keeps uninstalling - Help?

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    Worthing, England
    MS-Off Ver
    Excel 2007
    Posts
    13

    Unhappy VBA Excel 2007 Date Picker keeps uninstalling - Help?

    Hi all,
    I need some help with an action tracker I made i needed it as locked down and idiot proof as i could so i made the attached one.

    Its setup so that when you click add action it will come up with a user form to guide the user through the required things to add the action, then it adds it to excel and relocks.

    the issue im having is randomly - maybe daily(?) the date picker in userform1 deletes its self for no reason, then i get a complie error when opening the userform.
    ive fixed it in the attached one and i cant get it to break again manually but does anyone have any ideas why it keeps removing its self?

    A couple of side notes
    when i got into VB i notice that the toolbox with all the controls is gone - dunno if that means anything?
    all people using it are on excel 2007. some are win 7 but most are XP.
    I started making a userform3 with a calendar control, it doesnt do anything but that also goes when i have this issue...

    any suggestions? any way round it?

    the VB password is vmax

    thanks in advance!
    Attached Files Attached Files

+ 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