+ Reply to Thread
Results 1 to 2 of 2

Text Box not updating formulas

  1. #1
    Registered User
    Join Date
    05-14-2009
    Location
    So Cal
    MS-Off Ver
    Excel 2007
    Posts
    2

    Text Box not updating formulas

    I have formulas in A18, B18 & C18 that reference the numeric value in cell E1.
    I also have a text box (ActiveX) that allows the user to input a value into cell E1 via the "LinkedCell" property.
    THE GOAL is to allow the user to input a numeric value into the text box, the value will updated into E1, which will allow the formulas in A18, B18 & E18 to be calculated based on the user input into the text box.
    THE PROBLEM is the formulas do not calculate/update when the user input into the text box (formula cells remain blank). I suppose i was expecting the user to input into text box and tab or enter out of the box to get the formulas to run, but tab and enter does not do anything.
    I have done it up to this point without VBA, and not sure that I need it. I would like to do it without a CommandButton, but might have to.

    Any help would be absolutely great!!!!!

    Totally stumped here.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,645

    Re: Text Box not updating formulas

    Maybe you could post your workbook or a non-sensitive copy?

+ 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