Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 I don't know what a 'DropBox' is but you can assign a range directly to any list control using its List property exactly as you have done here... Me.ComboBox1.List = Sheets("Sheet1").Range("H4:H206") Me.ListBox1.List = Sheets("Sheet1").Range("H4:H206") ...where 'Me' is a keyword that refs the userform (or Form), and the list control is being populate in its 'Initialize' event. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ecell Use of an Access Table information | New Users to Excel | |||
Merge information from Excel to Access | New Users to Excel | |||
How do you get information from an Excel Web Query into Access? | Excel Worksheet Functions | |||
Using Excel to manage information in Access | Excel Discussion (Misc queries) | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) |