Results 1 to 7 of 7

Adding Input Box Value into Formula

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2024
    Location
    Washington, USA
    MS-Off Ver
    Office 365
    Posts
    16

    Adding Input Box Value into Formula

    I have a formula that will be implemented into a cell and copied down the column which works for the other types of pricing rules, but this one in particular doesn't seem to be working. As far as I can tell, it is the Cost Multiplier part. Do I need to declare the input box values as anything? Am I putting the Cost Multiplier into the formula wrong? Any help would be greatly appreciated. Thank you

    CostMultiplier = InputBox("Cost *", "Cost Multiplier")
    
    Sheets("Vendor Pricing Rules").Cells(2, LCVPR1).Formula = _
                                        "=IF('Input Values'!$L2=$" & Split(Sheets("Vendor Pricing Rules").Cells(2, LCVPR1).Address, "$")(1) & "$1, IF('Input Values'!$J2="""", """", IF('Input Values'!$G2=""SH"", INDEX('$H:$H, MATCH(ROUND('Input Values'!$J2 * " & CostMultiplier & ", 0), $F:$F, 0)), INDEX($G:$G, MATCH(ROUND('Input Values'!$J2 * " & CostMultiplier & ", 0), $F:$F, 0)))), """")"
    Admin note: Please put code directly into your post instead of having us download a text file to see it. --6SJ
    Attached Files Attached Files
    Last edited by jonathanramey; 04-19-2024 at 06:51 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding input into cell
    By morpheus83uk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-11-2020, 04:55 PM
  2. Replies: 1
    Last Post: 02-24-2013, 06:27 PM
  3. [SOLVED] Adding Input box to VBA code
    By The Drone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2012, 08:27 PM
  4. Automatic Formula Input Based on User Input Using a Macro
    By Drayloc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2012, 12:10 PM
  5. Adding to an input box
    By wildcats0625 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2010, 10:28 PM
  6. [SOLVED] adding 1 hour to input box
    By srroduin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-13-2006, 04:40 PM
  7. Adding input to macro
    By cappuccine in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2005, 08:50 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