+ Reply to Thread
Results 1 to 3 of 3

Use of ActiveX Control Use for worksheets

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Weedon, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Unhappy Use of ActiveX Control Use for worksheets

    Hi

    Having just spent £80 on books and getting no where, thought I would try and get some help with what I am trying to create to help save time when making a quotation!

    I have a work book that has 5 columns with either text or numbers in. What I am trying to do is add a check box to each line that when checked will populate a separate sheet in the same work book, say sheet 1. Once this sheet is populated, I would like to be able to change quantities and mark up by a %.

    Can some one please advise me if this is possible and point me in the right direction? Be grateful for any help!!

    Thanks
    Last edited by Ahhhhhhh; 04-12-2012 at 09:57 AM.

  2. #2
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Bergen, Norway
    MS-Off Ver
    MS 365 Subscription
    Posts
    323

    Re: Work sheet

    Hi,

    I have attached a simple example file, where you can have a look at some formulas.
    If you want it professional you will have to use macros.

    Hopefully with my norwegian brain I have got youre challenge right
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-11-2012
    Location
    Weedon, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Work sheet

    Thanks, that is what I wanted

+ 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