calendar popup

  1. B

    Specifying dates from pivot table?

    I'm getting data each week in a pivot table and need to pull data based on a specified date range (or the most recent X full weeks). I got this by recording macro With ActiveWorkbook.SlicerCaches("Slicer_Created1") .SlicerItems("1/6/2018 - 1/10/2018").Selected = False...
  2. J

    Difficulties with Dates...

    Hi all, I'm Dave, I'm new and I'm a complete Excel novice (think I'm probably being generous to myself there), so please be gentle... Anyway, my problem: I would like to create a dropdown list in one of my spreadsheets, which is easy enough. However, I would like for the user to be able to...
  3. B

    Calendar pop up

    I have Excel 2003 and am trying to create a calendar pop up box when a "Date" cell is selected. I know how to create the form but my version (at work) doesn't have the additional command to allow me to select the add-in. Is there another way?
  4. C

    Help with Pop Up Calendar Please.....

    Hi I am using the following code behid a simple spreadsheet which I need to enter two different date values (in 2 different columns). However the code only seems to work in 1 column (column 'M') but I would like it to work in columns 'M' and 'R'. Any idea on how to amend the code please...
  5. E

    calendar popup with only specific month

    Is there a way to make a calendar popup only show a specific month? For example if I click on cells B6:B25 I want the calendar popup to display the calendar for January; if I click on cells L6:L25 then I want the popup to display the calendar for February. Currently, if I click on the cell it...
  6. P

    Calendar popup - activate on cell selection

    Hi, all I have downloaded the following VBA script to be able to select a date from a calendar, rather than having to type in a date manually. ' =================================================== ' Code by Martin Green eMail martin@fontstuff.com ' Visit my Office Tips web site at...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top