calendar popup

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...

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...

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?

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...

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...

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...