+ Reply to Thread
Results 1 to 3 of 3

label caption to convert the date in a textbox

  1. #1
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    label caption to convert the date in a textbox

    Hi,

    I have two textboxes, 'txt_start' & 'txt_end' which both compose of date. The date format is mm/dd/yyyy

    I have also 2 label. The caption of the labels is based on the text of the textboxes

    How can i make the caption of my label to this format 'mm.dd.yyyy'?

    Ex: txt_start = 03/07/2014 & txt_end= 03/08/2014

    Label1 = 03.07.2014
    Label2 = 03.08.2014

    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,953

    Re: label caption to convert the date in a textbox

    Try


    Please Login or Register  to view this content.
    Or better yet, skip the textbox and use a calendar control or date/time picker.
    Last edited by Bernie Deitrick; 03-07-2014 at 04:33 PM.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: label caption to convert the date in a textbox

    Hi,

    Like this for txt_start, and similarly for txt_end:
    Please Login or Register  to view this content.
    I hope this helps

+ 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] Change label caption's font color based on value in another textbox
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-19-2013, 01:59 PM
  2. [SOLVED] Assign label caption based off of textbox value
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-17-2013, 12:36 PM
  3. convert empty label caption into number
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2009, 08:49 AM
  4. Label caption shows last saved date
    By pauluk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2007, 02:39 PM
  5. Format Label.Caption or Textbox data
    By RobC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2005, 08:06 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