+ Reply to Thread
Results 1 to 4 of 4

Looking for a quick "Walk through" type help on inserting a pop up calendar into selected

  1. #1
    Registered User
    Join Date
    12-24-2015
    Location
    Ca
    MS-Off Ver
    2007
    Posts
    2

    Looking for a quick "Walk through" type help on inserting a pop up calendar into selected

    Hello all,

    I'm new to the Forum, and pretty much new to Excel. Historically my need for Excel was very minimal, and all the functions I needed to do were very simple, mostly imputing data into a spreadsheet that someone else created. My new position requires me to create a data base between international branches of our company. I have modified an existing workbook to be the controlling document of this data base, but there are some other modifications I'd like to add, but don't know how yet. Since this document will be used by my designers in multiple countries, I'd like to have specified "Date Entry" cells have a pop up calendar in them, and I'd like this calendar to work for whoever opens the document from the network. This I think will help with the multiple date and time formats used in the various countries. When an engineer in Poland clicks on a "Date Started" cell, I'd like the calendar to pop up, this way there is no confusion about which way he should write the date. Once he selects the date, I'd like it to insert the date into that cell in the this format 24-Dec-2015.
    I understand the initial answers I will receive are to watch excel tutorials and VBA tutorials, which I am currently doing, but I fear I will not stumble upon the process by Monday when I will be putting this spreadsheet into operation (with or without pop up calendar). I have watched many videos about pop up calendar macros and whatnot, I have even got one made. I'm just having trouble with the whole inserting it into multiple cells in my spreadsheet, and keeping it there for others to use. Basically, every 3rd row in column E and column G will be a "Date Entry" cell. That part I can cover, If you could just explain how to get it into one cell I'll be happy. Please keep in mind that I am new to Excel, Macros, and VBA. I have been glued to Youtube every day of my holiday vacation trying to learn this specific function, but I have not found one explaining how to leave it in the document. I now have a pop up calendar button on my tool bar, and in my right click menu, but nothing that will stay with the document and pop up whenever you click the cell.

    Thank you for any help or tutorials suggested,

    Eric

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Looking for a quick "Walk through" type help on inserting a pop up calendar into sele

    I think what you're directly asking for is something like Martin Green's guide to building a tooltip calendar with VBA; alternatively you can just install a packaged addon like XLtool's popup calendar I suppose.

    I will say that in my own life, since I'm relatively more excel-knowledgeable than others in my workplace, I tend to open the VBA, disable protection and macro forms, and then do my data entry and spreadsheet manipulation how I am comfortable.

    Quote Originally Posted by eric.duval View Post
    This I think will help with the multiple date and time formats used in the various countries.
    The biggest source of confusion is that in the USA we use the mm/dd/(yy)yy format by default, wheras in Europe it defaults to dd/mm/yyyy as the standard, so something like 3/5/2015 could be either March 5th or May 3rd depending on context.

    In excel's guts though it's always saved as a serial number, the count of days since 1/1/1900. So today (Dec 24 2015) is day 42362 as far as excel is concerned. This means you can stick a Custom Format on top of the cell; I tend to use "dd/mmm/yyyy" because using the triple-m forces it to use the three-letter month code. Forcing to the three-letter code for month will prevent the day/month number confusion without having to reach for VBA or anything like that.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,601

    Re: Looking for a quick "Walk through" type help on inserting a pop up calendar into sele

    Quote Originally Posted by ben_hensel View Post
    ... In excel's guts though it's always saved as a serial number, the count of days since 1/1/1900. So today (Dec 24 2015) is day 42362 as far as excel is concerned. This means you can stick a Custom Format on top of the cell; I tend to use "dd/mmm/yyyy" because using the triple-m forces it to use the three-letter month code. Forcing to the three-letter code for month will prevent the day/month number confusion without having to reach for VBA or anything like that...
    Good advice, Ben

    Pete

  4. #4
    Registered User
    Join Date
    12-24-2015
    Location
    Ca
    MS-Off Ver
    2007
    Posts
    2

    Re: Looking for a quick "Walk through" type help on inserting a pop up calendar into sele

    Wow, Thanks for the quick response. I'll check out that guide

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 03-21-2014, 09:58 AM
  2. [SOLVED] "ElseIf" and "Lookup" type functions on 1 Spreadsheet
    By ReedDOT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2013, 12:03 PM
  3. Excel 2010 (Run-time error '13' type mismatch) "Debug" and "Continue" Grayed out.
    By Jeronimo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 06:42 PM
  4. macro to allow user to type in one selected drop down for- "other".
    By mteeters in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2012, 12:48 PM
  5. VBA editor auto changes "." to "'#" as you type ... not just after pressing <enter>?
    By Stripey_uk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-04-2011, 08:00 AM
  6. When I type "0" in front of a series of numbers the "0" disappears
    By aaponte in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-18-2007, 02:00 PM
  7. [SOLVED] Where is the toolbar with the "bold type", "font type", options
    By fwccbcc in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-03-2006, 04:15 PM
  8. [SOLVED] inserting a conditional "go to" command on a excel "if" function
    By velasques in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2006, 04:20 PM

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