Results 1 to 2 of 2

Display result in userform (vba) textbox

Threaded View

  1. #1
    Registered User
    Join Date
    07-30-2009
    Location
    Vancouver, British Columbia
    MS-Off Ver
    Excel 2010
    Posts
    46

    Question Display result in userform (vba) textbox

    Hi,

    I'm trying to get a userform textbox to display the result of a formula from a cell.

    For example, cell A1=2 and cell B1=3. Cell C3=A1+B1, which displays 5. I have a textbox in a userform that displays the contents of cell C3, however it displays the formula, and not the result.

    How can I get the textbox to display the result?

    Any ideas

    - I Love Lagar -

    (PS. I actually love Guinness, which is a Stout, but "I Love Lagar" flows much better than "I Love Stout" )
    Last edited by ilovelagar; 09-21-2009 at 11:28 AM. Reason: Solved

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