problem vba dialoguebox and database in excel
 

Hi,
I have the following problem:

I have a database spreadsheet (sheet 2) with in column A the names of
companies. Columns B - Z are all filled with characteristics of those
companies like adress, zipcode etc.

On another sheet (sheet1) i have several cells that need to be filled using
info from the database sheet.

I would like to create a dialogue box on which there is a drop down box
listing the companies in column A on the database sheet (in alphabetical
order). If the user has selected the company of his choice using the drop
down box, i would like to fill sheet1 with the info on the row of that
particular company.

Can somebody give me the VBA code to do this please ?

Thanks,
Pierre

problem vba dialoguebox and database in excel
 

Why not use data validation on the the subject sheet where the user picks
from a list of companies, then you could have vlookup formulas return the
appropriate values. Seems simpler and requires no code.

--
Regards,
Tom Ogilvy


"Jean-Pierre" wrote in message
...
Hi,
I have the following problem:

I have a database spreadsheet (sheet 2) with in column A the names of
companies. Columns B - Z are all filled with characteristics of those
companies like adress, zipcode etc.

On another sheet (sheet1) i have several cells that need to be filled
using
info from the database sheet.

I would like to create a dialogue box on which there is a drop down box
listing the companies in column A on the database sheet (in alphabetical
order). If the user has selected the company of his choice using the drop
down box, i would like to fill sheet1 with the info on the row of that
particular company.

Can somebody give me the VBA code to do this please ?

Thanks,
Pierre