+ Reply to Thread
Results 1 to 5 of 5

Just starting with vba i need help with a Calendar add in

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    London,England
    MS-Off Ver
    Excel 2010
    Posts
    9

    Exclamation Just starting with vba i need help with a Calendar add in

    I have a calendar add in on a user form. I need it to automatically input a selected date on 2 merged cells, one on each sheet. Anyone got a clue??? I'm just starting about this macros stuff and I can't get my head around how to do it.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Just starting with vba i need help with a Calendar add in

    What Calendar Add-In are you referrin to?

    There is a Calendar Control, is that what you mean?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    11-27-2012
    Location
    London,England
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Just starting with vba i need help with a Calendar add in

    The one that you get in your toolbox when you right click and add it to the tool box.
    The cells I'm talking about are cells are c57&c58 on sheet 1 and sheet 2.

  4. #4
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: Just starting with vba i need help with a Calendar add in

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-27-2012
    Location
    London,England
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Just starting with vba i need help with a Calendar add in

    Thank you Sean, hopefully it'll work. Ill let you know. I,ll try it when I get home.
    I might try and delete the bottom bit about hiding the calendar because I don't want it to hide as its all part of a larger user form.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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