+ Reply to Thread
Results 1 to 7 of 7

How to update Text Box2 with date 14 days after selected date in Text box1...

  1. #1
    Registered User
    Join Date
    01-24-2014
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    9

    How to update Text Box2 with date 14 days after selected date in Text box1...

    So I am creating a form that that has two text boxes. I have them both set to Short Date as their format. I am trying to make it so that When a date is selected in the first text box, the second text box will automatically fill out the date of the first text box PLUS 14 days, WITHOUT clicking anywhere. Just an automatic refresh. I have been able to make it so that it will show 14 days later when I click in the text box, but I need this to update automatically after selecting the initial date. Thanks.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: How to update Text Box2 with date 14 days after selected date in Text box1...

    Use the AfterUpdate event of the first textbox.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    01-24-2014
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: How to update Text Box2 with date 14 days after selected date in Text box1...

    Quote Originally Posted by Norie View Post
    Use the AfterUpdate event of the first textbox.
    Thanks for the reponse.
    I tried this and the logic worked, but I still had to click in Textbox2 in order for the date to refresh. I can not find a way for it to automatically refresh

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: How to update Text Box2 with date 14 days after selected date in Text box1...

    What exactly did you try?

  5. #5
    Registered User
    Join Date
    01-24-2014
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: How to update Text Box2 with date 14 days after selected date in Text box1...

    Quote Originally Posted by Norie View Post
    What exactly did you try?
    Thanks for the responses.
    I have tried something like this:

    Please Login or Register  to view this content.
    As well as something like this in the Change and AfterUpdate functions:

    Please Login or Register  to view this content.
    They all work in terms of logic, but I still have to click in Textbox2 to get it to update. I can't find a way to have the second textbox automatically refresh when I enter a date in the first.

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: How to update Text Box2 with date 14 days after selected date in Text box1...

    Is Textbox2 bound or unbound?

  7. #7
    Registered User
    Join Date
    01-24-2014
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: How to update Text Box2 with date 14 days after selected date in Text box1...

    Quote Originally Posted by Norie View Post
    Is Textbox2 bound or unbound?
    It is unbound. I have also tried entering "=[textbox1+14]" so it is not unbound, but I get the same result. It will not update unless I click in that box.

+ 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. How to update Text Box with date 14 days after selected date...
    By mjc61 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-25-2014, 08:10 PM
  2. [SOLVED] Text is changed to current date date when row is selected. No idea why?
    By rhug in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-10-2013, 02:41 AM
  3. Replies: 8
    Last Post: 07-13-2012, 09:02 AM
  4. Select Row in List Box with 2 columns - Col 1 populates form 1 box1,Col 2 pop box2
    By bernier@lucrf.com.au in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2006, 09:10 PM
  5. Date to update after 7 days Please
    By Steved in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-13-2006, 09:00 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