+ Reply to Thread
Results 1 to 3 of 3

Populating Userform ComboBox Using Items from Content Control Combobox

  1. #1
    Registered User
    Join Date
    01-14-2014
    Location
    Florida
    MS-Off Ver
    Office 2013
    Posts
    2

    Populating Userform ComboBox Using Items from Content Control Combobox

    Hello all,

    This is my first time posting, but I would like to first say that I have been lurking for a while and this forum has been an invaluable resource for me as I am new to learning vba. So thank you all for helping me, even though you may not know that you have.

    That being said, I need help with my current project. I am making a word document template and while a lot of the excel formulas work for word documents, I can't seem to find the information I need to make this current project work.

    My current project: I have a userform that contains a combobox. I want the items of that particular combobox to be populated from a content control combobox that I have in the template document (let's call the Tag and Title of the content control combobox "ccX"). I want to link them so that when I select the item in the userform combobox, it changes the content control combobox in the document.

    I've seen how you can use vba to populate the combobox based on a rowsource in Excel, but I don't know how to make it work in word. I know how to use .additem, but the content control combobox contains a lot of items and I may use comboboxes throughout the template, which would be cumbersome if I had to enter every item using .additem. Not to mention that the comboboxes still wouldn't be linked to the userform.

    I hope that makes sense. Any help would be greatly appreciated.

    Thanks!
    Last edited by anarxo; 01-16-2014 at 03:22 PM.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Populating Userform ComboBox Using Items from Content Control Combobox

    Greg Maxey has a very good site with lots of examples.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    01-14-2014
    Location
    Florida
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Populating Userform ComboBox Using Items from Content Control Combobox

    I appreciate the guidance, but I've been to his site already (and many of the other sites available - including the ones he links to) and I've read every page he has on userforms, content controls, and list/comboboxes. I've spent a considerable amount of time looking over all his examples to see if there was any way to extrapolate the answer, but unless I missed something, his examples do not accomplish what I am looking to do.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Populating combobox 2 with items that match criteria from combobox 1
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-13-2013, 03:00 AM
  2. [SOLVED] VBA Userform ComboBox: Content of ComboBox based off of Conditional Statement
    By Brianandstewie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2013, 03:00 PM
  3. [SOLVED] Populating Combobox with another combox in same userform
    By DataVanMan in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 11-12-2012, 04:16 PM
  4. Userform: ComboBox Automatically Populating
    By ashleys.nl in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-14-2011, 09:43 AM
  5. Populating a ComboBox in a UserForm
    By I Maycotte in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2006, 01:28 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1