+ Reply to Thread
Results 1 to 3 of 3

Modify equation based on userform text box input

  1. #1
    Registered User
    Join Date
    11-02-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    12

    Modify equation based on userform text box input

    Second post ever, trying to follow rules. Please let me know if I am violating them. Thanks.

    I am willing to share my document if someone feels they can help me, just not sure exactly how to on this forum.

    I have a "Master" file that will be used by several people. It has several hidden sheets (in document, they are for different Rooms). I have it set up as follows:
    -This document is an audit, with scores that are entered and averaged at the bottom of each worksheet (each room gets it own score).

    -A userform has two text boxes, where users will input a room name and tab(worksheet) name. The hidden "Master" worksheet is then copied with the user input data copied to the newly created worksheet.

    -I have an overall scorecard worksheet. The scorecard will have each room listed, and two equations per room.

    What I need help with is imputing an equation into the scorecard, and modifying with it the worksheet name entered by my users via the userform textbox.

    I think this is quite complicated, and I really can't figure it out. I would really appreciate someone that had patents with me and willing to teach me. Thank you for any help you can offer.

    BTW, this is my first really excel project for work, so I bought VBA Programming for Excel for Dummies about 2 weeks ago, so I am only going on 2 weeks of experience.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Modify equation based on userform text box input

    If you would like to post your file, click on 'Go Advanced'. Then click on the 'Attachment' icon which is the paperclip in the menu. I hope this helps.

  3. #3
    Registered User
    Join Date
    11-02-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Modify equation based on userform text box input

    Thanks for the instruction.
    Attached Files Attached Files

+ 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