Most likely, your answer is contained in this link, if not, post back:
http://www.contextures.com/xlDataVal13.html


Regards,
Ryan--
--
RyGuy


"excel help acct" wrote:

I need to populate a heading on an excel spreadsheet based on a value keyed
by a user. It can be one of 12 values keyed in. How can I code the heading
to appear based on the chouice selected by the user?