• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Worksheet Listbox erratic display

Sylvie

New Member
I started with Chandoo Project Dashboard and adapted it to my company needs.
I'm stuck now with a display problem that I can't reproduce on my computers :

On the "Dashboard" sheet, the middle listbox appearsmuch smaller on some PC, much bigger on others, and on some others, its just the font size which changes.
All pc I tried were using same screen resolution.
I really can't figure out whats going on.

I've been reading a lot regarding this through the web. Tried thousands of things, but I'm still stuck with this last bug...
If someone can help, I would be really very very gratefull !
 
Hi Sylvie..

It looks like, you have paid to get this dashboard..
If Not.. then..

Select the LIST BOX..
Please Go to Developer Tab.. > Click Design Mode > Click Properties (just right above it)..
In the Properties Box Select FONt > and Double click it..

Increase the font.. to visible height..
 
Hi Sylvie..

It looks like, you have paid to get this dashboard..
If Not.. then..

Select the LIST BOX..
Please Go to Developer Tab.. > Click Design Mode > Click Properties (just right above it)..
In the Properties Box Select FONt > and Double click it..

Increase the font.. to visible height..


Yes, of course I paid for this, and I changed it to feet my needs.
Since I changed it, I guess I can't really ask for "official support" (since its my mess, not Chandoo"s mess :)

I don't understand your suggestion regarding font size :
It's set to 12 on my PC and its very visible. WHat do you call visible height ?
My trouble is that this worksheet does not have the same behavior on all PC...

And to answer a previous question, yes Same zoom on all pc tried, same screen resultion, same excel version... same network place storage...
 
Did you tried my suggestion..

Try Google translate.. if you are facing problem to set Font' Size..
Select the LIST BOX..
Please Go to Developer Tab.. > Click Design Mode > Click Properties (just right above it)..
In the Properties Box Select FONt > and Double click it..
 
Debra,

Yes I tried like hundreed times to change font type (fixed type or not), font size (small or big)...
It does not change anything.
It looks like a bug : on some pc's, without changing anything, everything is fine.
On others, listbox would be smaller or bigger, or correct size, but then, the font would look very small even when its specified 12 or 22 or whatever in listbox property font size...
 
Also, I saw on some forums that putting an external screen would sometime create that kind of behavors, but for example on my own PC, I'm unable to reproduce the bug
 
Actually, even if I still don't understand why, it seems that doing the following have solved the issue for now :

1. By macro, fix the listbox font type, size, and positions at the opening of the file
2. make sure that listbox and all activx objects are defined as move but don't resize with cells
3. UPGRADE to EXCEL 2013....

I'm more and more positive that I met an Excel 2010 and previous versions bug, but still I can't really figure out how and why, but it probably have something to do with
32/64 bit version + display card used + microsoft coding with their feet

Thanks to everyone who tried to help, I really appreciated :)
Sylvie
 
Back
Top