none
Microsoft Word Drop Down List RRS feed

  • Question

  • Hi,

    I have a name list from master workbook. In microsoft word i want to create a drop down list which refer to the said master workbook, so anyone know how to get it by using VBA code?

    Wednesday, January 21, 2015 1:12 AM

Answers

  • Hi UnSothea,

    Do you have a excel file with the list data and want load data to a drop down list control in the word?

    If so, I suggest that you could refer to these steps below:

    1. Using CreateObject method to create a excel object.
    2. Using Open method to open your master workbook.
    3. Read the data in workbook
    4. Using Combo Box control in word and add the data to this control.

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, January 22, 2015 7:34 AM
    Moderator

All replies