Creating a Combo Box on a UserForm using VBA

[brockvilleal]

I am new to this. I have searched but am still puzzled.

I have created a userform (frmgrade) with a combo box and a text box. I need to first off populate this combo box (found in workbook pick.xls) with a list from another workbook (defn.xls). This list will have 6 items. I want the user to select from the drop down list, one of these 6 items. When that item is selected, I want the definition for that item to appear in the text box.

The 6 items are found in defn.xls, sheet "plist", range b4:b9
The 6 definitions are found in defn.xls sheet "plist" range c4:c9

Where would I place the code? I thought it should go in the forms itself.

Thanks,

Al

 

[Tazguy37]

I would put it into the UserForm_Initialize() section of code (you can get at that from the UserForm in the VBA).

 

[brockvilleal]

I am still trying to figure out the code required to do what I am trying to.

Thanks,

Al