excel - Pop up calendar for date selection in place of input box -


i using macro, in using input box manually typing date .autofilter 2 lines below.

key1 = inputbox("expiry date", "title") .range("a1").currentregion.autofilter field:=2, criteria1:=key1 

here need , pop calendar, instead of manually typing date, can choose date calendar.

here u can find answer ur question link


Comments

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

javascript - Get parameter of GET request -

javascript - Twitter Bootstrap - how to add some more margin between tooltip popup and element -