+ Reply to Thread
Results 1 to 2 of 2

Question 'if' statement = true a list box appears, strikethrough and deduct.

  1. #1
    Registered User
    Join Date
    09-24-2009
    Location
    asdasd
    MS-Off Ver
    Excel 2003
    Posts
    22

    Question 'if' statement = true a list box appears, strikethrough and deduct.

    I need help trying to figure this spreadsheet out. Here is what I want it to do. I think I have gotten pretty far for being a novice/intermediate with excel.

    Looking for some help from you wonderful folks.

    - I need to be able to have a yes/no drop down box appear in Hx if Gx askes if "Is this a spare?" Along with this, if yes is selected from the drop down it needs to strikethrough any Fx box that that is in the same column, while at the same time deduct that amount from C13.

    I have other questions I have on this spreadsheet and will create corresponding threads for them

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Question 'if' statement = true a list box appears, strikethrough and deduct.

    Please see the attached.

    You will find the code for the event driven macros and a new sum function which ignored strikeout values in the Sheet1 and Module1 tabs respectively in the VBA editor. (Alt F11).
    Attached Files Attached Files
    Martin

+ 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