+ Reply to Thread
Results 1 to 3 of 3

Correct way to apply an existing VBA code to an existing sheet

  1. 06-05-2013, 03:25 PM #1
    JO505
    JO505 is offline
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Correct way to apply an existing VBA code to an existing sheet

    I have a worksheet that I would like to apply an existing VBA code to. It is a calendar as posted in a thread from "Zplugger" on this Forum (see below) and looks as if it would be very useful.

    HTML Code: 
    I have tried to insert this into my file but so far I have been less than successful. I have managed (after some trial and error, mostly error) to get the form made and have been able to get it to open. At one point I even thought I had it working properly but that was only a dream!

    If someone could provide a step by step (on a VERY basic level) starting with how to make sure that whatever I have done so far would be erased and then start from the beginning,I would be most thankful. I think I have deleted Everything but in the back of my mind I cant be sure.

    I have a limited knowledge of formulas and functions but when it comes to VBA I quickly become overwhelmed!

    Thanks,

    Jim O
    Last edited by JO505; 06-05-2013 at 05:42 PM.
    Reply With QuoteRegister To Reply
  2. 06-05-2013, 05:00 PM #2
    JO505
    JO505 is offline
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Correct way to apply an existing VBA code to an existing sheet

    I am not making much progress.

    I have it to a point where the calendar opens but when I click on a date I am getting a "Run-time error "9":".

    In the original version clicking on a date will bring up any notes or tasks associated with that date, all I can get is the run-time error.

    Jim O
    Reply With QuoteRegister To Reply
  3. 06-05-2013, 05:42 PM #3
    JO505
    JO505 is offline
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Correct way to apply an existing VBA code to an existing sheet

    I have it working now. I overlooked the "Calendar" sheet, that was not in the very first version. As soon as I added a sheet called "Calendar" all seems to be fine, and my face is very red now!

    It is a sweet calendar to add to a workbook. As I look back the code is telling me that is where it is looking to store the information but I don't yet feel comfortable reading code to see it quickly. Maybe some day.

    Jim O
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1