ExcelBanter - Combobox data from Database

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Combobox data from Database (https://www.excelbanter.com/excel-programming/335630-combobox-data-database.html)

Mats Samson

Combobox data from Database

How do I populate a Combobox from an Excel Database without
displaying the header of the database column.
Regards
Mats

Tom Ogilvy

Combobox data from Database

Assume the Column has the header in H1

Dim rng as Range
set rng = Range(Range("H2"),Range("H2").End(xldown))
Me.Combobox1.List = rng.Value

--
Regards,
Tom Ogilvy

"Mats Samson" wrote in message
...
How do I populate a Combobox from an Excel Database without
displaying the header of the database column.
Regards
Mats

Mats Samson

Combobox data from Database

Thanks Tom, it helped!
Regards
Mats

"Tom Ogilvy" wrote:

Assume the Column has the header in H1

Dim rng as Range
set rng = Range(Range("H2"),Range("H2").End(xldown))
Me.Combobox1.List = rng.Value

--
Regards,
Tom Ogilvy

"Mats Samson" wrote in message
...
How do I populate a Combobox from an Excel Database without
displaying the header of the database column.
Regards
Mats

All times are GMT +1. The time now is 08:44 AM.