Results 1 to 10 of 10

Calendar Value Using Data From A TextBox

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2008
    Location
    eastern mass
    Posts
    7

    Calendar Value Using Data From A TextBox

    I have a Userform that has a TextBox named TextBox5 when double click, it opens a calendar form. When the calendar closes it places its value into TextBox5.

    Private Sub TextBox5_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
        FrmCal1.Show
        
    End Sub
    In the next TextBox (TextBox6) I Have a formula that uses the date value from TextBox5, Minus 6.

    Private Sub TextBox6_Change()
    'Set Date Using TextBos5's Input (Find Period Ending Using Pay Date)
        FrmInput1.TextBox6 = (DateValue(TextBox5.Value) - 6)
      
    End Sub
    This works fine, when I tab or enter into TextBox6. It performs its task and shows the value needed.

    What I would like is to have this value entered automatically, without having to tab stop or enter into the TextBox6.

    Thanks, any advice would be appreciated.
    Last edited by Boxer; 11-17-2008 at 05:08 PM.

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