+ Reply to Thread
Results 1 to 3 of 3

Help - VBA Code Transfer

  1. #1
    Registered User
    Join Date
    09-22-2009
    Location
    Reading, England
    MS-Off Ver
    Excel 2003
    Posts
    6

    Help - VBA Code Transfer

    Hi All

    Sorry to ask such a simple question....but I'm trying to make a drop down calendar available in a simple spreadsheet i've made....now i've got a working version in another spreadsheet which i have borrowed from someone who's made it using just vba coding. However I can't seem to transfer it to the simple spreadsheet i need it to be in.....

    The working spreadsheet also has 3 subs built into it to enable which way it can be activated...Now what i need is to transfer the vba project into the simple spreadsheet and enable it to activate whenever i click on column a.

    Can anyone help me with this....please post me some simple (idiot) instructions on how to do this.

    I've also attached both spreadsheets with my simple one called general and the spreadsheet with the vba project called calendar10.

    Thanks for the help...
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,697

    Re: Help - VBA Code Transfer

    I have transferred all the code and the form across

    Please see attachment.

    Regards
    Last edited by TMS; 06-12-2011 at 09:57 PM. Reason: Replace uploaded workbook
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,697

    Re: Help - VBA Code Transfer

    If this has answered your question, please mark your thread as closed. See my signature for details or the FAQ.

    Regards

+ 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