All articles with 'userform' Tag

CP034: Advanced Excel Essentials book talk with Jordan Goldmeier

Published on Apr 23, 2015 in Chandoo.org Podcast Sessions

In the 34th session of Chandoo.org podcast, Let’s hear from Jordan Goldmeier – my friend, fellow blogger, Excel blogger & author. After many years of interaction thru email, blogs, Skype calls, finally I met him at PASS BA conference at Santa Clara this week. He gave me a copy of his new book – Advanced Excel Essentials and I immediately asked him to do a podcast. So here we go.

CP034 - Advanced Excel Essentials book talk with Jordan Goldmeier

What is in this session?

In this podcast,

  • Introduction
  • What is this book all about
  • Sample chapter review – User forms
  • Design principles for creating advanced user interactions
  • How to become advanced Excel user – pathway recommended by Jordan
  • More info about Jordan
  • A secret for you
Continue »

Show pop-up calendar upon right click [Excel VBA]

Published on Nov 13, 2013 in VBA Macros

There are times when we are entering dates into several columns and would like to select a date from a popup calendar instead of manually typing.

Today, lets understand how we can set up a pop-up calendar in Excel so that your users can easily input dates by right clicking on a cell and inserting a date.

pop-up calendar vba excel

Continue »