On Aug 18, 12:26*pm, Heather
wrote:
Hi, *I need to create a form for our Sales staff to have ability to enter

Currency (USD, Euro, GBP, or YEN)
Edition (A, B, C, or D)
# of Users
Length of Term
Addt'l Products (yes or no) If yes a box should appear with their choices

Then somehow I need their choices to go out to other tabs in the workbook
and get the calculations and prices for these based on their criteria -- Is
this something that can be done in Excel? *And then placed in a summary tab?

Thank you,
Heather

Heather,

The answer to your question is yes. (Without knowing your specific
situation, it seems like you could potentially leverage a VLOOKUP (or
HLOOKUP depending on how the data is organized) function to accomplish
the same goal without having to spend the time coding up a user form
and related procedures and functions).

Best,

Matthew Herbert