Need a little more information on how to identify which template to use from
the selections in 3 cells. Depending on the number of options in each
dropdown there could be a hugh number of variations.

How many templates do you anticipate having?

Can you provide a sample of what the list of options are for each of the 3
cells and what combinations are applicable to specific templates?

--
Regards,

OssieMac


"PumaMan" wrote:

Forgive me, I'm learning VBA now, so I'm a rookie:

I have an excel sheet where a user is selecting certain values in 3 cells
from a drop down list (created with data validation). I then have a submit
button that they will hit and depending on the values within those 3 cells, I
want to open the appropriate word templates based on those values and then
populate those values into bookmarks.

You can call the excel and bookmark values whatever you like, I have an
understanding of logic, i'm just a bit of a rookie @ VBA.

Thanks in advance!
Elbio