+ Reply to Thread
Results 1 to 2 of 2

Userform textbox to view data, not update data

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    yorktown va
    MS-Off Ver
    excel 2007
    Posts
    7

    Unhappy Userform textbox to view data, not update data

    Hi everyone, Good Morning

    Using examples from this outstanding forum I have developed a userform that almost does everything I need. The problem is when I update the monthly values the userform overwrites the sum formula in the worksheet (QTR totals). I want to manipulate the monthly values to keep within my quarterly budget.

    Is there a way to just view the total cell and not have the userform overwrite it?

    I have tried converting the monthly cells to numbers and summing them up but could not get the result to display on the form. Researching the problem, controlsource properties and mode are mentioned but being a VBA newbee I need examples to play with to understand.
    I have attached my worksheet.

    Any guidance and suggestions will be greatly appreciated

    Thanks for your time and effort
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-04-2012
    Location
    yorktown va
    MS-Off Ver
    excel 2007
    Posts
    7

    Re: Userform textbox to view data, not update data

    Fixed it, summed the textboxes using the following code for all the totals
    Function ShowSum1() As String
    ShowSum1 = Val(TextBox4) + Val(TextBox5) + Val(textbox6)
    End Function

    worked like a charm

    thanks for the views

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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