Formatting MM/DD/YYYY dates in textbox in VBA

by

I never suggest using Textboxes or Inputboxes to accept dates. So many things can go wrong. I cannot even suggest using the Calendar Control or the Date Picker as for that you need to register the mscal.ocx or mscomct2.ocx and that is very painful as they are not freely distributable files.

Here is what I recommend. You can use this custom made calendar to accept dates from the user

PROS:

  1. You don’t have to worry about user inputting wrong info
  2. You don’t have to worry user pasting in the textbox
  3. You don’t have to worry about writing any major code
  4. Attractive GUI
  5. Can be easily incorporated in your application
  6. Doesn’t use any controls for which you need to reference any libraries like mscal.ocx or mscomct2.ocx

CONS:

Ummm…Ummm… Can’t think of any…

HOW TO USE IT (File missing from my dropbox. Please refer to the bottom of the post for an upgraded version of the calendar)

  1. Download the Userform1.frm and Userform1.frx from here.
  2. In your VBA, simply import Userform1.frm as shown in the image below.

Importing the form

enter image description here

RUNNING IT

You can call it in any procedure. For example

Sub Sample()
    UserForm1.Show
End Sub

SCREEN SHOTS IN ACTION

enter image description here

NOTE: You may also want to see Taking Calendar to new level

More Related Contents:

  1. Are there disadvantages in putting code into Userforms instead of modules?
  2. Print function selecting wrong Type of Change option excel vba
  3. Format Cell Contents
  4. Excel formula checklist in employees
  5. What is the difference between .text, .value, and .value2?
  6. Copy Paste Values only( xlPasteValues )
  7. automatically execute an Excel macro on a cell change
  8. VLOOKUP with multiple criteria returning values in one cell
  9. VBA check if file exists
  10. How can I concatenate strings in VBA?
  11. Copy/Paste/Calculate Visible Cells from One Column of a Filtered Table
  12. Loading addins when Excel is instantiated programmatically
  13. Trying to use variables as values vba to sql
  14. How to call a macro from a button and pass arguments
  15. VBA (Excel) Dictionary on Mac?
  16. Paste Excel range in Outlook
  17. Refresh Excel VBA Function Results
  18. excel VBA run macro automatically whenever a cell is changed
  19. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  20. VBa conditional delete loop not working
  21. Concatenate column headers if value in rows below is non-blank
  22. Update excel sheet based on outlook mail [closed]
  23. Sending mail using Outlook where the Send method fails
  24. Using a variable for row in (row,column) for a range in VBA
  25. Unicode string literals in VBA
  26. Error13 in Excel VBA in data file
  27. How to open a workbook specifying its path
  28. Access files with long paths (over 260)
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment