Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: formating textbox

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello,
    I am trying to format a textbox to
    display a date as 05/10/02, but it covert it to the excel numbering of dates 46232 how do I change this .....Thanks

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    JG,

    I've been trying to replicate your problem with the text box and can't seem to get Excel to express the date as 46232. Are you using the text box from the Drawing toolbar?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    What's your code? You can use something like this but it depends on how your form is set up:-

    Private Sub TextBox1_AfterUpdate()
    Me.TextBox1.Text = Format(Me.TextBox1.Text, "mm/dd/yy")
    End Sub

    Regards,
    Dan

  4. #4
    New Member
    Join Date
    May 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe thats my problem I haven't written any code could someone give me a basic example of formatting a textbox .....Thanks

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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