I have pricing for my products in an Excel 2k7 spreadsheet. I'd like to develop a macro that would allow me to email the spreadsheet to a customer, and have them put in the product specifics, then have the macro spit out a price so they can price products out without calling for a quote - there are many variables that go into a product, and the price list is pretty complex to read. I need to keep the pricing sheets flexible so I can edit them for 2009 and following years when I change prices.

Anyone have suggestions on free tutorials for VBA, advice where to start, anything?

Why do you need VB for that?

Cause of the complicated selection. It goes something like this:

input: product type (drop down box; 3 choices)
input: product height (drop down box, 8 choices)
input: product length (numerical)
input: product option 1 (drop down box; 3 choices)
input: product option 2 (drop down box; up to 15 choices, varies with product option 1 and product type)
input: product option 3 (drop down box; 4 choices)

output: price per piece, both wholesale and suggested retail

input: # pcs needed (numerical)

output: total order cost, less shipping, again both wholesale and suggested retail

I'm open to any other suggestions like a web-based script, although I'd prefer an excel file (and it'd have to be Excel 2k3 compatible) so customers can read it without an internet connection.

You are making this more complicated than it needs to be. 2 worksheets with the first being what the customer sees and then the second which is hidden, locked, and password protected. The first worksheet is nothing but input and functions which the cells would draw from the 2nd worksheet which is static data. There is no need for Visual Basic for what you are trying to do.

if i just have inputs in my locked sheet, i'd have to put in lists for all the product choices. especially since i have options that are dependent on other options, that would be almost as difficult for my customers to understand as the price list itself. plus i dont know if i can nest enough =if() statements to do it.

If you add VBA you'll have trouble emailing/sharing the file due to anti-virus crap. You really should try to pull it off without coding using a lot vlookups, conditional formatting, etc. Pm me your email addy and I'll send you a pricing spreadsheet I built over 10 years ago for material handling hoists. I was an engineer, but was told by some sales people it couldn't be done. Back then we could ask every salesman for the same thing and get all different prices.