D

It is certainly available with VBA but does it have to be?

Check here

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


wrote in message
oups.com...
Hello

I have a question about programming Excel. I am new with excel
programming but I'm have experience with programming in other
languages.

I want to have an excel sheet populated with date from a database
query. I would like this query to be triggered by the user inputing
data in a cell and either hitting Enter or by clicking a Submit button.
For example if the user inputs in a designated cell a part number and
hits enter (or clicks a submit button) this will trigger a select * by
part bumber db query.

My question;

1. Is possible to do this in excell with VBA?
2. Are there any pointers (examples online) that I can inspire from?

Thanks
-D