pop up calendar

  1. I

    How to Activate/Merge Multiple Dependent Dropdown menus based on a Cell with Multiple Data Validation Selections

    I have 2 questions: 1. I have constructed a Macro workbook divided by three tabs: “IDL," “HSN" and “ List”. The List tab, outlines all the drop down menu options based on Categories (Apparel, Bath Bedding, Décor, Furniture etc.). For example if the user chooses “Apparel” in Column E, the...
  2. R

    Would like to use a pop up calendar in widely distributed workbook

    I have a commonly distributed scheduling workbook that i would like to add in a pop up calendar to a date field. I have no problems adding this with proper functionality to my machines, however as soon as it is sent to a customers, they run into errors due to missing reference libraries. How can...
  3. G

    Pop up calendar in userform - Need to limit entry

    I have a userform with two pop up calendars (calendar1 and calendar2). Calendar1 is the "start date" and must be a Monday. I have this portion working fine. If they select a date other than a Monday an alert message will pop up notifying the user a Monday must be selected. I need to limit the...
  4. R

    Problem with pop up calendar

    Hey guys, I am working on a macro that uses a userform in which a user can enter information about incoming parts. One of the entries in the form is the date on which the part came in which is selected using a pop-up calendar and then stored into a combo box. Once the user types in all of the...
  5. W

    Calendar control gradually gets bigger!

    Hi All, I stumbled across this code to incorporate a pop-up calendar in a form I have developed. However the calendar dimensions (height and width) gradually get bigger and bigger (meaning, that as I continue to use the form, each time I open it it seems to be bigger than the time before), and...
  6. N

    Pop Up Calendar Help

    Hi, Does anybody know when I add a pop up calendar on a user form, I am able to choose the date and have the textbox filled while using the mouse, but when using the Arrow keys I can move around from date to date, but I cannot make a selection when I hit the 'Enter' key. Does anybody have a fix...
  7. T

    Calendar

    I found an Excel Workbook on the web and found it very helpful to create a calendar that has no controls. http://www.tracykaye.com/Calendar10.xls I modified it to this below. http://www.tracykaye.com/NoControlCalendar.xls I am trying to change the look of this calendar. Here is a picture...
  8. T

    Pop up calendar

    I am sharing this with the community as I spent all day trying to find a pop-up calendar that will automatically open up when specific cells are selected. I hope this helps someone that had the same problem I had. I am a complete novice. And I got this to work perfectly... with one exception...
  9. T

    cell formatted pop-up calendar

    When a user enters a cell (merged or not) that is formated with a date format, I want to pop up a button right next to the active date formatted cell? Then I want this button to open a date picker/pop-up calendar right next to the button. Then when the calendar closes... so does the button. I...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top