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
Post a Comment