+ Reply to Thread
Results 1 to 3 of 3

Need to define a textbox in a userform as a date field with the day of the week

  1. #1
    Registered User
    Join Date
    07-29-2016
    Location
    dallas, tx
    MS-Off Ver
    365
    Posts
    51

    Need to define a textbox in a userform as a date field with the day of the week

    The title pretty much says it all I think. I've seen suggestions on code for the date, but I don't know how to get it to display the date with the day of the week. Example:

    Tuesday, August 2, 2016. The day of the week is very important to my reporting.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Need to define a textbox in a userform as a date field with the day of the week

    Try something like this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    07-29-2016
    Location
    dallas, tx
    MS-Off Ver
    365
    Posts
    51

    Re: Need to define a textbox in a userform as a date field with the day of the week

    THANK YOU!!!!! Worked like a charm!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2010 - Userform - display date from textbox in a label or textbox in 'ddd' format
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 10:54 PM
  2. [SOLVED] Userform - Move to next textbox field by hitting enter instead of
    By TimT in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 11-18-2014, 07:38 PM
  3. [SOLVED] Userform textbox value to post to a different column in spreadsheet based upon day of week
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-04-2013, 07:51 AM
  4. [SOLVED] how to user environ in textbox field of userform
    By Ignesh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-24-2012, 05:40 AM
  5. How to define date format in userform
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2010, 12:52 PM
  6. Mandatory TextBox Field - UserForm
    By longbow007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2009, 06:01 PM
  7. userform: trasnferring textbox value to label field in next userform
    By brillison in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2008, 08:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1