+ Post New Thread
Results 1 to 6 of 6
Windows Thread, Excel - Control Toolbox - Text - Date Formatting in Technical; Does anybody know how to validate a Text field, selected from the Control Toolbox within Excel, so that it displays ...
  1. #1

    Join Date
    Jun 2007
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Excel - Control Toolbox - Text - Date Formatting

    Does anybody know how to validate a Text field, selected from the Control Toolbox within Excel, so that it displays dates in dd/mm/yyy format rather than the serial number ?

    Thanks

    RHB

  2. #2
    alonebfg's Avatar
    Join Date
    Aug 2006
    Location
    south west some of the time
    Posts
    834
    Thank Post
    12
    Thanked 34 Times in 21 Posts
    Blog Entries
    5
    Rep Power
    24

    Re: Excel - Control Toolbox - Text - Date Formatting

    you need to format the cell to date short date i think it is but dont quote me on that its been a while since i used exel in anger

  3. #3

    Join Date
    Jun 2007
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Excel - Control Toolbox - Text - Date Formatting

    If only it was that simple. That wroke within any cell within the Worksheet.

    I have created a text object,via the Control toolbox, which is linked to a specific cell via the LinkedCell property.

    Even though the cell is in a date format, it shows the cerial number within the text object.

    Wondered if anyone knows a way of formatting it within the LinkedCell property. Have tried Format(CellNo,"DD/MM/YY") but the property does not like it. I ams sure I could code it in the macro but though there must be an easier way.

    RHB

  4. #4
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: Excel - Control Toolbox - Text - Date Formatting

    Did a quick google and looks like you have to code it to be able to validate/format it.

  5. #5
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: Excel - Control Toolbox - Text - Date Formatting

    Oh you could also use Microsoft Masked Edit Control instead of a TextBox Control.

  6. #6

    Join Date
    Jun 2007
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Excel - Control Toolbox - Text - Date Formatting

    Now I am out of my depth.

    Is that within .NET ?

    Don't think its part of standard Exel ?



    RHB1



SHARE:
+ Post New Thread

Similar Threads

  1. Webpage formatting problem using Publisher
    By laserblazer in forum Web Development
    Replies: 8
    Last Post: 29th October 2007, 10:34 AM
  2. Help with conditional formatting
    By randle in forum Windows
    Replies: 3
    Last Post: 25th October 2007, 02:20 PM
  3. need to extract text from a string in excel
    By projector1 in forum How do you do....it?
    Replies: 7
    Last Post: 14th February 2007, 02:41 PM
  4. formatting w98
    By chrbb in forum Windows
    Replies: 6
    Last Post: 21st February 2006, 12:36 PM
  5. The Ultimate Administrators Toolbox
    By ICTNUT in forum Scripts
    Replies: 7
    Last Post: 16th August 2005, 12:38 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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