Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delicate Excel-database problem | Excel Discussion (Misc queries) | |||
retrieve data from spreadsheet using combobox in dialoguebox | Excel Programming | |||
problem about sending data in Excel to an Access database | Excel Programming | |||
Excel function to search and access database problem | Excel Programming | |||
MS Access Database Connection problem in Excel XP 2002 | Excel Programming |