View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ed Ferrero[_5_] Ed Ferrero[_5_] is offline
external usenet poster
 
Posts: 20
Default Source an Access Table for a dropdown list box

Hi Trina,

Go to the menu item Data - Import External Data - New Database query
Follow the prompts to place a data range in your worksheet
Go to Data Range Properties and rename the Data Range to something simple
like 'MyQuery'

Using the Controls toolbox place a drop-down in the worksheet, then edit the
properties to
set the ListFillRange to 'MyQuery' (without the quotes)

OR
Using the Forms toolbar - add a combo box to the worksheet, then Format the
Control to
set the Input Range to 'MyQuery' (without the quotes)

Ed Ferrero
http://edferrero.m6.net

"Trina" wrote in message
...
I am wondering if this is possible... any advice would be appreciated.

I want to put in a drop down list box in my worksheet. Instead of

sourcing from a range of cells, I would like to source from an Access Table.
Is this possible, if so how?

Thanks
Trina