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

Please Login or Register  to view this content.

Admin note: Please put code directly into your post instead of having us download a text file to see it. --6SJ

this one in particular doesn't seem to be working

What are you expecting it to do, and what does it do instead?

Consider attaching the Excel file so we can actually run your code and see what's going on.

That error indicates, in this case, that the formula is not valid. If you were trying to enter the exact same thing directly into the cell you would get a message from Excel that the formula is invalid.

It's not possible for me to know what's wrong unless I can see all the values referenced in your code at runtime, and I can't see that without your file.

I would suggest you do this:

Add this at the beginning of your Sub

Please Login or Register  to view this content.

Replace the line you showed with these three lines:

Please Login or Register  to view this content.

Bring up the Immediate Window before running the code, then see what formula it prints before trying to assign it to the cell. If you can't tell from that what's wrong with your formula, then post that result here for further analysis.

Re: "some sensitive information in there"
Some people have reported that using the delete key together with the other keys on the keyboard to type in fictitious data has actually worked wonders.
Of course it takes some time.

Tongue firmly in cheek here.

The fact that it works with more basic formulas is exactly the reason that the problem points to the formula. The last line of code is where it tries to put the formula into the cell.

If you copy that formula and try to paste it into a cell, you will get an error that it is an invalid formula.

You have a stray single quote mark. Scroll to the right to see it. If you remove it you will have a valid formula. I have no idea if it will give you the result you want, but it will be valid and will eliminate the VBA error.

Please Login or Register  to view this content.