combo box drop down list

I have this crazy project in Excel 2010 and I have one issue plaguing it right now. I've used Combo Boxes to allow a value to be selected in one of two spots - two combo boxes each pointing to the same data in a cell. On a summary page I've created, I've used VBA to hide rows that don't...

Ciao All ~ Not sure which forum to drop this question into, but here goes ... I'd like the end user to select from 100 different locations. When a selection is made the sheet will "shift" to the appropriate row on the worksheet. Is it possible to use Data Validation to navigate a list of...

I am trying to use Excel VBA to import data into my active workbook and then use two combo boxes(which should get populated once the data is imported) drop down menu's to make a selection of any two variables from the data and create a choice of chart(Line, Scatter etc). I have already done the...

First time poster. System / Version information: Microsoft Windows XP Professional 5.1.2600 Excel 2007 / Visual Basic 6.5. Background / synopsis: I am using Excel to open up an external website to generate reports. When it comes time to launch the report, a pop-up appears with combo boxes to...

Hi, I have 3 combo boxes and a macro is run depending on which combo box I choose. However, if I have chosen something in the first combo box and then choose something from the second combo box, I can still see what I previously chose in combo box 1 and it is confusing some of the users as...

I have ( with much input and help from here ) a dual column combo box in a userform, which when it starts up, shows as an empty box, when I click on the arrow button, the anticipated list becomes visible and I can select from there. What I want, is when I open the userform I can see the first...

I am trying to setup a 2 column combobox in a userform, the userform works, but the combobox does not load any data, the explanation on the site where I plagiarised the code from says to use 'Private Sub UserForm_Initialize()' but the code for the combobox comes up with 'Private Sub...

Hello All, Background info: I am working on Excel 2010 and running Windows 7 (64 bit). I have a worksheet that contains a macro to create data validation combo boxes (which is pretty neat since it gives the users the autofill function). I did not write this macro, but rather obtained it...

A combo box is set up with, say, listrows = 2. It then shows two rows. Fine. Now, when I go and change listrows to, say, 10. It still only shows 2. Basically, I can't get the combo-box dropdown to refresh when I put in a new # for listrows, to show a longer list