UserForm Dropdown List Not Populating

gmaxey · #1 04-08-2016, 05:30 AM

If you are populating a multicolumn listbox then your code would look something like this:

Code:

ActiveDocument.SelectContentControlsByTitle("Drawing Number").Item(1).Range.Text = .DrawingNumberUf.Column(0)
ActiveDocument.SelectContentControlsByTitle("Rev").Item(1).Range.Text = .DrawingNumberUf.Column(1)
ActiveDocument.SelectContentControlsByTitle("Name").Item(1).Range.Text = .DrawingNumberUf.Column(2)

highrise955 · #2 04-08-2016, 05:56 AM

Quote:

Originally Posted by gmaxey

If you are populating a multicolumn listbox then your code would look something like this:

Code:

ActiveDocument.SelectContentControlsByTitle("Drawing Number").Item(1).Range.Text = .DrawingNumberUf.Column(0)
ActiveDocument.SelectContentControlsByTitle("Rev").Item(1).Range.Text = .DrawingNumberUf.Column(1)
ActiveDocument.SelectContentControlsByTitle("Name").Item(1).Range.Text = .DrawingNumberUf.Column(2)

Awesome! Works exactly how I want it to.

Thanks for taking the time to respond.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel List Box not populating worksheet field upon submit	Shane.Hutchison	Excel Programming	1	10-22-2015 12:24 PM
Help!! Dropdown List	christo16	Word	1	06-29-2015 05:18 AM
Dropdown list, Macro	shield5	Excel Programming	7	10-27-2013 01:51 AM
Need help populating dropdown box	antztaylor	Word	3	11-06-2012 05:46 PM
Populating ComboBox or Drop Down list with contents of a text field	Billy_McSkintos	Word VBA	1	09-13-2011 05:50 AM