Form Text Box Date Picker

**ADR90** · 06-11-2018, 03:25 AM

Hey All,

I am new to VBA and currently making a form in excel for data entry. The problem I have is that I have a lot of text boxs that require dates entered and I would like it when you click on a text box a calendar will appear so the date can be selected.

I am using office 2016 and where this spreadsheet is going to be used I cant be installing the calendar extensions for excel.

I have been looking at Trevor Eyre's Excel VBA Date Picker but I cant seem to get it to work in a text box.

Any help or advice would be great.

**6StringJazzer** · 06-11-2018, 09:35 AM

Here is my version of a VA date picker. My examples show how to use it in a worksheet, or use in a UserForm using a label. I do not recommend using a textbox because allowing the user to also type into the textbox means you have to validate the user entry.

Form Text Box Date Picker

LinkBack

Thread Tools

Rate This Thread

Display

Form Text Box Date Picker

Re: Form Text Box Date Picker

Thread Information

Users Browsing this Thread

Similar Threads

Add Date to User Form Without Access to Add Date Picker Control

Using a Date time picker in a VBA form

Set up Excel Form with Pop-up Date Picker

Date Picker from user form

Date Time Picker in User Form

[SOLVED] Using a Date time picker in a VBA form

Form Date picker

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions