trying to associate VBA macros with dropdown lists

Joined
Jul 8, 2011
Messages
1
Reaction score
0
I have inserted comboboxes and dropdown lists into a word 2010 document.

I want changes to these objects to cause VBA macros to run, but I can't seem to associate the control with the code.

Firstly, I don't know how to find out the name of the control (Combo1? combobox1? etc).

Secondly, I need to confirm the name of the routines. I created routines called:

Private Sub Combo1_AfterUpdate()

Private Sub ComboBox1_Change()

Private Sub Dropdown1_Change()

But none of these gets executed when I change the value of the comboboxes or dropdown menus.

I've tried looking at the properties of the control, but can't find the name. Also, formfields.count = 0.

I obviously dont understand this at all! But I have been programming VB6 for many years and also VBA for Excel for many years.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top