+ Reply to Thread
Results 1 to 2 of 2

How to make a form or inputbox pop out using vba and making necessary computations?

  1. #1
    Forum Contributor
    Join Date
    12-03-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    107

    How to make a form or inputbox pop out using vba and making necessary computations?

    I have two files here, one is the quotation file. In the quotation file the columns are:

    column A = Item number
    Column B = Customer
    Column C = Product cost
    Column D = Mark up
    Column E = Selling Price

    The second file is the Product cost calculator. What the user does is he opens this file and inputs the quantity of ingredients in the sheet.(total quantity of ingredient 1, 2, 3) the calculator produces a total product cost and this is what the user puts in the product cost column in the quotation file. What i want to happen is that the user will will just put the active cell in the product cost column in the quotation sheet and he will just run a macro. When the macro is triggered a form (or an input box?) will pop out and there will be text box for him to enter the quantity of ingredient 1, ingredient 2, and ingredient 3. The data entered will then be used in the Product cost calculator accordingly and the price will automatically appear in the active cell. How can this be done?

    I dont want the user to open the Product cost calculator because it is time consuming and there are sensitive information in the computation that he cannot know.


    assuimg that both files are located at:

    C:\Users\Kevin\Google Drive\PCC\productcostcalculator.xls

    C:\Users\Kevin\Google Drive\PCC\quotation.xlsm






    Quotation.xlsm


    ProductCostCalculator.xlsx
    Last edited by kjy1989; 04-14-2013 at 11:10 PM.

  2. #2
    Forum Contributor
    Join Date
    12-03-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    107

    Re: How to make a form or inputbox pop out using vba and making necessary computations?

    Bump, anyone?

+ 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