+ Reply to Thread
Results 1 to 2 of 2

Create A check Box & Click on the Add button The Selected columns was Add to the invoice

  1. #1
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Create A check Box & Click on the Add button The Selected columns was Add to the invoice

    R/Sir
    i am Crete a 9 check box (P2 to P9 columns ) than i am click on the check box the & click on the add button the selected check box was add to the invoice after total
    for example
    i am selected on the 3 check box & click on the add button the 3 selected check box was added to the invoice after the total amount of the invoice
    Total 9000
    output vat @ 5% 450
    fright charges 200
    round off -
    grand total 9650

    i am selected on the 4 check box & click on the add button the 4 selected check box was added to the invoice after the total amount of the invoice
    Total 9000
    output vat @ 5% 450
    output vat @ 13.75% 1237
    round off -
    grand total 10687

    now you can see the attachments & send the VBA code for this excel sheet
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: Create A check Box & Click on the Add button The Selected columns was Add to the invoi

    Hi
    You can do this without micro also

    Right click on the control
    Click format control
    Click on control tab
    In cell link enter any cell reference not in used (X1)
    Repeat this for all the checkboxes.
    Now use cell references in the cell to get the required answer

    I have set first two checkboxes and in M42 used this formula

    M42:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mahju; 05-12-2015 at 11:02 AM.
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

+ 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. Create customer Invoice in sep spreadsheet, using 'Create Invoice' 'Button'
    By J stacey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2015, 11:45 AM
  2. create unique invoice no and check against list
    By alan h m in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-10-2015, 04:12 AM
  3. Not deleting the selected data from listbox by one click on command button
    By biznez1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-31-2013, 12:05 PM
  4. Replies: 3
    Last Post: 06-30-2012, 06:44 AM
  5. [SOLVED] [SOLVED] Create floating button based on button click in menu
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2005, 02:05 PM

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