ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Floating toolbar Q - is there a limit to # of icons we can display/use? (https://www.excelbanter.com/excel-programming/348689-floating-toolbar-q-there-limit-icons-we-can-display-use.html)

StargateFanFromWork[_3_]

Floating toolbar Q - is there a limit to # of icons we can display/use?
 
Is there a limit to how many icons we can display on a floating toolbar?
For some reason, I'm having trouble past 4. There are other issues, but
wondering re maximum.

I don't need a ton, but I'd like to be able to have a toolbar that has about
8 buttons in total. (The next issue depends on the answer re the limit.)

Thanks! :oD



Leith Ross[_404_]

Floating toolbar Q - is there a limit to # of icons we can display/use?
 

Hello StargateFanFromWork,

There probably is a limit, but it is well beyond anything you could
use. I have put several hundred controls on a Toolbar with no problem,
to display face IDs. You should post your code for review. Something is
wrong.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=495371


StargateFan[_3_]

Floating toolbar Q - is there a limit to # of icons we can display/use?
 
On Wed, 21 Dec 2005 18:42:56 -0600, Leith Ross
wrote:


Hello StargateFanFromWork,

There probably is a limit, but it is well beyond anything you could
use. I have put several hundred controls on a Toolbar with no problem,
to display face IDs. You should post your code for review. Something is
wrong.


Thank you!

Once I knew that there wasn't a limit for floating toolbar icons that
I'd get to any time soon, that confirmed to me that something was
indeed wrong with my code, as you say. I went back and broke the
whole thing down and figured out in the process how to handle working
with so much code ina systematic way.

I separated the code by many blank lines and added a partial comment
at the beginning of each chunk. Only once code worked did I fill out
the comment and erase the blank lines, moving the working lines back
up to the body of the rest of the vb code. That made it easy to
figure out each step. In this way, then, I re-built the toolbar and
find it seems to be working just fine now and all icons are being
displayed. I must have had conflicting code somewhere/somehow that
prevented some icons from being displayed and from working.

So kewl. Another enhanced workbook to use at the office. We're
streamlining more and more each day and reducing risks of error while
getting faster! I'm very grateful for all the help.

Thanks!

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=495371




All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com