Link drop-down boxes or Autofill from selections

[SCrowley]

I have a template that consists of 2 columns; 3 rows. Each cell is the same.
They have two drop-down boxes one with choice of address, next choice of
city, state zip. I'd like to automate it to automatically fill all the cells
with the same selected information instead of the user having to "select" the
same info for each cell. Ideally, they make their choice in cell 1 and the
rest reflect that choice. I'm not well versed in VB so I haven't even tried
programming.

 

[Doug Robbins]

You don't need VBA. Use a cross reference to the text of the bookmark
assigned to the formfield and in the properties dialog for the formfield,
set the calculation on exit option so that the cross reference is updated to
reflect the selection.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP