PDA

View Full Version : Commandbar ComboBox



makako
08-13-2010, 05:07 PM
Hi, I have created a command bar that populates itself with a column of a hidden sheet. The problem is that the data in the column is too high and somehow it only lets me see the first 1000 entries, but when I see through code I can see that the 1001 entry is there as it should. As my data is sorted out I can only see from A to V and I am missing Y,Z, etc. Is there any way I can enlarge the amount seen in the commandbar combo? Thanks

Aussiebear
08-13-2010, 05:54 PM
I'm assuming you mean you have created a "combo box" rather than a "command bar" that populates itself from a column of a hidden sheet.

What properties have you set for the range in the RowSource option?

makako
08-13-2010, 06:48 PM
No. It is a combobox inside a commandbar. I generate a commandbar with several combobox and textboxes that show me
Info in any part of the workbook. That is why it is in a commandbar

Aussiebear
08-14-2010, 03:54 PM
Please attach your workbook otherwise I fear we will continue to go round in circles here

makako
08-17-2010, 04:35 PM
I did this example, hope it is clear so that Ill get come help. As you can see i hace more than 1000 names on the data but when running the fisrt macro, it only shows the first 1000. Thanks

Artik
08-17-2010, 05:58 PM
I opened the sample file in the XL 2K3 and see all the names. :think:

Artik

makako
08-18-2010, 08:43 AM
mmmm, maybe is my version. Im also unable to handle the width of the combobox.

Aussiebear
08-18-2010, 02:08 PM
This could well be a 2007 issue