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