View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mats Samson Mats Samson is offline
external usenet poster
 
Posts: 112
Default 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