Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Help with a calendar linking to cells

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    A cold state with warm people
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there any type of macro or method I can use to get a spreadsheet to link to the computers calendar and automatically go direcly to the cell that equals that week?

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've got just the code for you

    Sub OpenCalendar()
    ' Displays the UserForm and calendar
    ' Shortcuts should be made to this procedure
    frmCalendar.Show
    End Sub.

    It worked for me,hope it will work for you

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    A cold state with warm people
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I will give it a shot. Thanks for the help.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •