Show register from Access DB in ComboBox as list

[JuanMellado]

Hi Guys

My first post and sorry for my dummy question, I am working with excel, VB and access, I want to show in a ComnoBox a table from Access, i have the conection but if i call a method .Getstring the ComboBox doesn't show the table as list.

Do you know the method? or the right way to get the information as list.

Thanks

 

[combo]

GetString returns multiline text, you heve to process it and fill combobox list either by an array (2D, 0-biased) or a loop with AddItem.

combo

 

[SkipVought]

If you were to query your table via MS Query in a worksheet, you can use the Structured Table name (which you can edit) as the ComboBox RangeName(if my memory is correct)

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]