Excel 2010 VBA Tutorial 51 - Userforms - Calendars

preview_player
Показать описание
How to add a calendar onto your userform to select dates with.
Рекомендации по теме
Комментарии
Автор

Can't wait for more! I am hoping that knowing more about VBA will help me in my search for an entry level actuarial job. I'm crossing my fingers!

skow
Автор

I would recommend power programming in VBA by John Walkenbach he is such a good writer and I was able to read this book cover to cover without getting bored which is unusual for me with a book like this I normally just skim read. I am hoping to get some more videos done this weekend :)

YourprogrammingnetworkCoUk
Автор

thanks a lot man....your videos are all great...

fermgg
Автор

Cheers for the recommendation and looking forward to your next batch of videos.

coldfeetinlondon
Автор

I agree, these tutorials are fantastic! Thanks so much for putting them together. I just watched all 51 of this series over the weekend. Any idea when you'll be posting the next batch? I'm just starting a project and would love to learn more from you before it's too far down the road. Also, is there a VBA book you recommend for purchase in the UK? Many thanks.

coldfeetinlondon
Автор

I am using excel 2007, I cannot find Calendar control!! Do i have to add any References or any other setting? Please help

kirtanpatel
Автор

Sir, I want to filter date column in pivot table using Userform Calender.
Error Code :
** Date2 = InputBox("Enter the Date for which you want to prepare the report in mm/dd/yyyy 0:00 format")
** ActiveSheet.PivotTables ("aa")
** = userform1.Calendar2.Value

mchopra