View Full Version : ComboBox help
dickep
03-17-2008, 09:37 PM
This has probably been asked and answered but for the life of me I cannot find it. :banghead:
I have attached a file that I "plagerized" from here (I think). :thumb
I just need to know how to populate the combobox with the data in the spreadsheet.
I am new to the forms and can't figure it out. :help
Thanks
E
Bob Phillips
03-18-2008, 02:14 AM
I think you will need to give us more assistance than that, ther is plentyof code in there but it doesn't seem to do anything (yet?)
dickep
03-18-2008, 07:15 AM
Yes, there is a lot of code.
I cannot figure out how to populate the combobox with the range on Sheet1. I have tried .AddItem in the With area, tried .RowSource (Object not allowed error when running), but to no avail.
I would like to populate it with the 3 columns of data, but only show the 3rd column. Then when I click the accept button (not yet there), the column 1 and 2 data will be entered into two variables for later processing.
Doable????
E
Bob Phillips
03-18-2008, 08:10 AM
What combobox, there is no combobox. The code makes some reference to one, but without breaking the code down (which I ain't gonna do), I cannot see what you are trying to do, to what, or how.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.