Hi again,


I've picked back up on this and am continuing to try and populate fields based on dropdown content.

I am using the example template posted at the beginning of this thread. I have done the following:

1. On the example template, edited the dropdown content to display my content needed via the Developer tab's "properties=>display name/value" menu.
2. Verified that my changes worked on the example template.
3. Copied the dropdown from the example sheet to my sheet (I believe there was a comment saying this should be possible?)
4. Copied the text field from the example sheet to my sheet.
5. Accessed the Macro code in the example sheet via Alt+F11.
6. Copied macro code.
7. Opened VBA on my sheet via Alt+F11
8. Copied macro code into my sheet

After these steps I selected one of my dropdown values and it did not change the content of the text field as it had before. I tried to trouble shoot by comparing the how the macro looked in the example template vs. mine. As far as I can tell they are identical except for the "Option Explicit" header on the example screen shot, which I don't understand (screen shots attached).

The attachment "Form Screen Cap" shows what I want to do. The dropdown under "Sales Representative" should populate the info in the three circled categories.

Attached Files

Screen shots.docx (349.0 KB, 11 views)