+ Reply to Thread
Results 1 to 3 of 3

UserForm Question:display mm/yyyy

  1. #1
    Barb Reinhardt
    Guest

    UserForm Question:display mm/yyyy

    I have a userform with a text box in it. I want the user to enter the month
    and date in the format mm/yyyy. In the text box, I want to display mm/yyyy,
    but when the user selects the TextBox1, I want it to clear out. What do I
    need to do to accomplish this?

    Thanks,
    Barb Reinhardt

  2. #2
    Mark Lincoln
    Guest

    re: UserForm Question:display mm/yyyy

    I haven't tested this, but it should work. I'm sure someone will tell
    me if I'm wrong. :-)

    Private Sub TextBox1_Enter()
    TextBox1 = ""
    End Sub


  3. #3
    Toppers
    Guest

    re: UserForm Question:display mm/yyyy

    Barb,
    This will clear previous entries

    Private Sub TextBox1_Enter()
    TextBox1.Value = ""
    End Sub

    "Barb Reinhardt" wrote:

    > I have a userform with a text box in it. I want the user to enter the month
    > and date in the format mm/yyyy. In the text box, I want to display mm/yyyy,
    > but when the user selects the TextBox1, I want it to clear out. What do I
    > need to do to accomplish this?
    >
    > Thanks,
    > Barb Reinhardt


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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