Feb 15 2006, 08:50 AM
How do I populate my combo box with Items? I am sure it is something to do with AddItem but I can't seem to get mine ot work. Any one have an example of a sheet they could attach?
Feb 15 2006, 09:14 AM
are you talking about a combo box directly on the spreadsheet or on a userform?
Feb 15 2006, 10:07 AM
Feb 15 2006, 10:12 AM
Pardon me for interupting but I have an example sheet from another post that shows the syntax for both a userform and worksheet object.
Mar 17 2006, 10:18 AM
I'm having an issue with getting my combobox to populate from a list using your code. I did not include the second macro that is going to run based on what is selected from the combobox, as it is a huge file. It is an order history for my customers. I currently use a listbox, but our customer list is so long that this is quite inefficeint. Once a customer is selected, my second macro finds all the items that this customer has bought in the past. I'm assuming that once I get my combo box to work, I just have to change (in my second macro) the imput from listbox to the new combobox.
Sorry for the long background, all I need is some help with the combobox problem. Thanks so much.
Mar 17 2006, 10:42 AM
You were trying to use a forms control with code meant for use with an ActiveX control from the control toolbox. I included examples of both in the attachment.
Mar 17 2006, 12:39 PM
Gotcha, thanks so much. I'm used to using Access, so I figured what I needed was just form controls. I didn't even see the control toolbox. Thanks so much for your help =).
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here