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
Bookmarks