VBA Picklists

[DauntingGecko]

Hey,

Does anyone know how to get a picklist on a VBA form?

 

[Norie]

Why not just add a combobox or listbox control?

 

[DauntingGecko]

Hey Norie,

I would def do this - but haven't got a clue how to use them in VBA forms! Use them all the time in normal excel.

I need to define a named range for this to work from (data will keep growing).

Can you give me an example of how to populate a drop down list in VBA?

 

[Norie]

Just set it's RowSource to the name of the range.