+ Reply to Thread
Results 1 to 3 of 3

Create a Userform to Perform this Function - Guidance Please

  1. #1
    Forum Contributor
    Join Date
    04-23-2014
    Location
    Liverpool...ish
    MS-Off Ver
    Excel 2013
    Posts
    126

    Create a Userform to Perform this Function - Guidance Please

    In the example table you can increase the amount listed in column ‘J’ by entering an amount in column ‘H’ and decrease the amount in column ‘J’ by an entry in column ‘I’. My problem and I am sure it is a case of writers block, is that I can’t seem to translate this function to a userform.

    I know the problem here is not as much about knowledge as it is about a foggy brain so any guidance that puts me on the right track would be appreciated.

    Example AddSub To Cell - Form.xlsm

    Thanks
    Scott

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Create a Userform to Perform this Function - Guidance Please

    Something like this?
    Attached Files Attached Files
    Last edited by sktneer; 05-02-2015 at 04:33 AM. Reason: Correction in the code
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    04-23-2014
    Location
    Liverpool...ish
    MS-Off Ver
    Excel 2013
    Posts
    126

    Re: Create a Userform to Perform this Function - Guidance Please

    I didn’t give enough information before to paint a good enough picture to answer my question. It is possible that this is more difficult than I thought… I will start over and am posting a completely new example.

    The purpose of this table is to be able to manually allocate funds between different categories allowing you to take away amounts from one category and add to another. The example is of course clearer. I would like to use a userform to perform this allocation process rather than giving the user direct access to the table. This is an example. The real application will have perhaps 10 different categories.
    Sorry for the lack of detail previously.. Hope this is clear.

    Scott

    Example AddSub To Cell Form(new).xlsm

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using Data Entered in UserForm from one sheet to perform intersect on another
    By scoolie1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-02-2014, 04:23 PM
  2. [SOLVED] LINESTIF - Can you help me create an array formula to perform this function without VBA?
    By jglassmanba in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-26-2012, 05:45 PM
  3. Macros Guidance to create Charts
    By vpanicker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2012, 10:30 AM
  4. Code to perform task based on data entered in userform
    By Staci in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-27-2011, 02:06 PM
  5. [SOLVED] perform 1 function, stop, perform different function
    By nastech in forum Excel General
    Replies: 0
    Last Post: 08-22-2006, 07:25 AM

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