Combox properties missing (Linked cell, Listfield range)

[bensox]

I've a basic knowledge of VBA but new to control boxes. Trying to follow instructions to create a combo box but fields I need aren't showing under Properties, the alpha-betical list showing is:
...
Left
ListRows
ListStyle
ListWidth
Locked
etc

I need to use:
LinkedCell
ListFieldRange
in order to complete the instructions I found (https://www.extendoffice.com/documents/excel/2439-excel-drop-down-list-search.html)

How do I specify/find these properties?

 

[RoryA]

Where is the combobox located?

 

[bensox]

I went to VBA, Insert Userform, Controls, draw combo box. UserForm1 in a wb named order index.xlsm
Do I need to create and save it then go back to it's properties? Complete beginner, sorry

 

[RoryA]

The article you’re following is for a combo box on a worksheet, not a UserForm, which is why you don’t see the same properties.

 

[dmt32]

I went to VBA, Insert Userform, Controls, draw combo box. UserForm1 in a wb named order index.xlsm
Do I need to create and save it then go back to it's properties? Complete beginner, sorry

perhaps you may find this site more helpful:https://www.contextures.com/xlUserForm02.html

You can download a free sample workbook


Dave

 

[bensox]

Thanks Rory A, I added a combo box on the worksheet in the hopes those instructions would do my job. However when I try to name the ListFillRange with any text (single word) it doesn't save it (returns to a blank field). Any pointers?

 

[RoryA]

The listfillrange must be either the address of a range, or the name of one.