Jean-Pierre D via OfficeKB.com
Guest
retrieve data from spreadsheet using combobox in dialoguebox
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
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200509/1
Bookmarks