+ Reply to Thread
Results 1 to 8 of 8

Text box value not getting updated

  1. #1
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Text box value not getting updated

    Hi all

    I am trying to create a command button which should display a certain value in a text box so that user can read that for a 1 minute or so
    and later a webpage opens up

    The following code is first waiting for 10 seconds and then opening the webpage. The text box value gets updated and i can see that only if i go back to the excel sheet.

    Any idea how to turn this around where the mistake is



    Please Login or Register  to view this content.
    Last edited by grkchakri; 03-22-2017 at 01:31 PM. Reason: corrections
    Never confuse a single defeat to the final defeat.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Text box value not getting updated

    Is this textbox and button on a userform or on the sheet itself? Is the information displayed in the textbox always the same?
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Re: Text box value not getting updated

    both are on the sheet. and the information displayed is a standard one / same

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Text box value not getting updated

    How about just having a message box appear with the information instead of a textbox?
    Or create a userform with the textbox on it. Your code will work on a userform as it is written.
    Last edited by gmr4evr1; 03-22-2017 at 02:17 PM.

  5. #5
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Re: Text box value not getting updated

    message worked but i felt i will not have much control in terms of font, size and so. text box will also help me look wise. Any idea why the code is jumping to wait time before the value getting updated.


    very naive with userforms. how to link it to the button on sheet. any help ?

    Thank you gmr
    Last edited by grkchakri; 03-22-2017 at 02:27 PM. Reason: additional info

  6. #6
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Text box value not getting updated

    I had to split the code to get it to work with the command button on the sheet, but I've got it.
    This code goes in a Module
    Please Login or Register  to view this content.
    This goes in the UserForm1 code
    Please Login or Register  to view this content.
    Here is a sample workbook. Press Alt + F11 to open the VBA editor
    grchakri textbox value not getting updated V2.xlsm
    Last edited by gmr4evr1; 03-22-2017 at 05:24 PM. Reason: Corrected typos

  7. #7
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Re: Text box value not getting updated

    Thank you very much gmr. the code works

  8. #8
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Text box value not getting updated

    You're welcome, glad it's working for you.

+ 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. Color Updated Text
    By runnerD2016 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2017, 09:18 PM
  2. Replies: 1
    Last Post: 06-09-2016, 03:06 AM
  3. Updated formulas obscure the text
    By turtle054 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-18-2015, 06:25 AM
  4. Replies: 1
    Last Post: 04-29-2013, 05:25 PM
  5. Updated Links dont remember they're updated
    By carsto in forum Excel General
    Replies: 0
    Last Post: 05-05-2009, 11:26 AM
  6. Rev. Auto Updated when sheet is updated and or entire book
    By frankee_gee in forum Excel General
    Replies: 1
    Last Post: 04-07-2008, 05:05 PM
  7. updated row comes at the top
    By Fam via OfficeKB.com in forum Excel General
    Replies: 2
    Last Post: 04-11-2006, 12:20 AM

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