Form change based on cell entries

So, I've got some audit forms built on excel, they are used to grade/audit phone calls. The forms include questions with push buttons, check boxes, and drop down lists with a running score down one side.

At the top I copy and paste a line of data, which in turn auto fills some of the form.

However, the form being used depends on the type of phone call. So sometimes, I copy and paste in the data, and then realized it's the incorrect audit form.

Is there a way to program it so that when I paste the line of data at the top, the form changes to reflect the necessary call type?

So for example: If A1="Contact", the remaining worksheet is updated to the Contact Form? If A1="Voicemail", the remaining worksheet updates to the Voicemail form?


I can't attached the file, so I'm hoping someone can understand my description.

Paste this into the Worksheet module :

Please Login or Register  to view this content.