Excel 2007 listbox width problem
I have a multicolumn listbox that has a defined height and width.
IntegralHeight is set to true. Sometimes, when the userform containing the listBox is opened, the width of the listbox has shrunk so that some of the columns are not visible. If I click on the listbox, it will expand to the correct width. I've tried everything I can think of to get the listbox to size properly when opened, including re-defining the Height and Width properties in the code that is executed when the userform opens, but without success. Is there a way to make the listbox behave better? |
Excel 2007 listbox width problem
I had the sam problem
This solves, I have no idea. Give the width after opening and draw it again. Must be a bug, because the width is correctly when I go through the code in DEBUG-Mode Private Sub CommandButton1_Click() Userform1.Show Userform1.MyListbox.Width = 960 Userform1.Width = Userform1.Width 'don't make any sense End Sub On Wednesday, October 22, 2008 11:14 AM dsimco wrote: I have a multicolumn listbox that has a defined height and width. IntegralHeight is set to true. Sometimes, when the userform containing the listBox is opened, the width of the listbox has shrunk so that some of the columns are not visible. If I click on the listbox, it will expand to the correct width. I've tried everything I can think of to get the listbox to size properly when opened, including re-defining the Height and Width properties in the code that is executed when the userform opens, but without success. Is there a way to make the listbox behave better? Submitted via EggHeadCafe Oracle Developer For Beginners http://www.eggheadcafe.com/training-...L-Samples.aspx |
All times are GMT +1. The time now is 01:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com