Multiple Date Select Calendar?

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Hi There's probably better ways, but if you have a Userform with a Calendar and Command Button, then by selecting a number of individual dates, one after the other, column "K" will be filled with these dates , and to start again Click the command Button.
Code: 
Private Sub Calendar1_Click()
Static c As Integer
c = IIf(Range("K1") = "", 0, c)
c = c + 1
Cells(c, "K").Value = Calendar1.Value
End Sub
Code: 
Private Sub CommandButton1_Click()
Columns("K").ClearContents
End Sub
Regards Mick
 
Upvote 0
Hi Mick,
Many thanks for the reply. I had a heck of a time trying to find Calendar Command (with no success). It turns out that if I don't have Access 2007 (which I don't) then the ActiveX control for Calendar Command is not available for Excel 2007. I could not find the .OCX file for it anywhere either. I guess I'm SOL on this one (unless there are other suggestions).
 
Upvote 0
Hi, Sorry not familar with 2007, But for ealier versions. Place Userform in VB Editer, Click "View,"ToolBox" , Right click anywhere in "ToolBox", Sub menu appears, Select "Additional Controls", If you can Find "Calendar" Place a tick in the Box, Click "OK".
Good luck Mick
 
Upvote 0
gabethegrape said:
Hi Mick,
Many thanks for the reply. I had a heck of a time trying to find Calendar Command (with no success). It turns out that if I don't have Access 2007 (which I don't) then the ActiveX control for Calendar Command is not available for Excel 2007. I could not find the .OCX file for it anywhere either. I guess I'm SOL on this one (unless there are other suggestions).
Click to expand...

I seem to be having the same problem... I have Excel/Word 2007, no Access, and I've tried to use the calendar Control with no luck... If you find whats wrong or a way around this, please post here.
Thanks
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Would like to make edits to VBA Calendar Code
Replies
8
Views
439
Legacy 352679
L
S
  • Question
Work Coverage Calendar
Replies
2
Views
323
Scoti
S
M
  • Solved
VBA Date issue
Replies
3
Views
146
dmt32
D
M
  • Question
Excel Time Keeping "Application"
Replies
0
Views
70
Mrock1
M
R
  • Solved
Subtracting all calendar days, but end date cannot fall on a weekend or holiday. If it does, the end date shifts to the preceding work day.
Replies
8
Views
346
Romy
R

Forum statistics

Threads
1,215,510
Messages
6,125,234
Members
449,216
Latest member
biglake87

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top