Even easier would be to use a dropdown list. Debra can show you how
http://www.contextures.com/tiptech.html

-
Don Guillett
Microsoft MVP Excel
SalesAid Software

"NA_AB" wrote in message
...
hi friends, I am trying to populate a data set retrieved from the database
on
to the active cell of an excel sheet. I got it by making use of a button
and
handling the event of its click, but how to return an entire dataset
directly
onto the active cell when for example, the user simply says
=get_table(...)
in an excel cell?