Thread: Getting information from access table in excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] 3g.kayak@gmail.com is offline
external usenet poster
  
Posts: 1
Default Getting information from access table in excel
I have inserted an access table into an excel sheet. I would like to populate a dropbox in a form with the data from that access table. I can do it by specifying the range as below but I'm guessing there is a better way.

Form1.DropBox.List = ThisWorkbook.Sheets("Sheet1").Range("H4:H206").Val ue
Reply With QuoteReply With Quote