+ Reply to Thread
Results 1 to 3 of 3

Math Formulas in a Text Box

  1. #1
    Registered User
    Join Date
    03-03-2008
    Posts
    20

    Math Formulas in a Text Box

    Hi,
    I need to put a mathmatical formula inside of a text box in Excel. Whenever I try to do it, nothing happens...the text box just displays the formula and doesn't actually calculate. Thx!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    What make you think that the text box should perform a calculation within itself?

    Rgds

  3. #3
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    The features that are avaliable to Excel's user interfaces are not built into a textbox.
    For example, entering =3+2 in this box will return 5.
    Please Login or Register  to view this content.
    TextBoxes are raw, primitive tools for inputing strings. Which can then be manipulated as the developer chooses.

    If you would explain what you are trying to do with this box, different ways of acheiving that end might be explored.

    Is the textbox from the Drawing Menu? or the ToolBox or is it on a userform?
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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