date Picker Macro
Is there a macro I can add to a worksheet to add a date picker to a range of cells in the sheet?
Anwsers to the Problem date Picker Macro
There are a couple of steps to do this.
One the developer tab click 'Insert' and in the ActiceX toolbox click the toolbox icon (Bottom Right) and click 'Calendar Control 12.0' OK.
On the worksheet click and hold down the left mouse button and drag to create your calendar.
Resize it as required.
Click Exit design Mode.
Right click the worksheet tab, view code and paste all the code below in on the right.
Where it says A1:G10 change this to the range you want this to work on.
Clicking in the range makes the calendar appear, click a date and the date goes in the active cell.
Click anywhere else and the calendar becomes invisible.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A1:g10")) Is Nothing Then
Calendar1.Top = Target.Top + Target.Height
Calendar1.Left = Target.Left + Target.Width / 2 - Calendar1.Width / 2
Calendar1.Visible = True
Calendar1.Value = Now
ElseIf Calendar1.Visible Then Calendar1.Visible = False
Private Sub Calendar1_Click()
ActiveCell.Value = (Calendar1.Value)
ActiveCell.NumberFormat = "dd mmm yy"
- Access the files on your computer via MY COMPUTER
- Under the C: drive, access the WINDOWS folder
- Select the SOFTWARE DISTRIBUTION folder, followed by the DOWNLOAD folder.
- Delete any files within this download folder.
- If you are unable to delete these files, open the command prompt (CMD) as the administrator, and type "net stop wuauserv" into the CMD prompt window. Press ENTER. This should allow you to delete the files from step 4.
- Once the files are deleted, open and run the CMD as the administrator and type "wuauclt.exe /updatenow". Press ENTER.
Recommended Method to Repair the Problem: date Picker Macro:
How to Fix date Picker Macro with SmartPCFixer?
1. Download Error Fixer. Install it on your computer.
2. After the scan is finished, you can see the errors and problems which need to be repaired.
3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.
Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 - 126.96.36.199059,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v.188.8.131.52 driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.10.6.0.29,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.184.108.40.206,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: Delete Unique Records using a Macro,How to Fix Error - Delet A Program That Does Not Show In Programs and Features?,Fast Solution to Error: Data Entry User Form based on my worksheet fields,How to Fix Error - Debug notepad upon start-up?,Fast Solution to Problem: deleted 80 gigs of files, only freed up 30 gigs according to My Computer. Anyone know why?