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
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?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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
Please attach your workbook otherwise I fear we will continue to go round in circles here
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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
I opened the sample file in the XL 2K3 and see all the names.
Artik
mmmm, maybe is my version. Im also unable to handle the width of the combobox.
This could well be a 2007 issue
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
