Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Would it be presumptious to think that since you have only one listbox on the
form that maybe it should be ListBox1 in the code instead of ListBox2? "Frederik" wrote: Using Windows XP Eccel 2003 On a UserForm there are only one ListBox and one OK button. I would like to change the width of the UserForm, the width of the ListBox and the position of the OK button, depending on the largest element in the ListBox (depending on the variable atl). I'm using this code: UserForm2.Width = atl * 158 / 31 + 80 UserForm2.ListBox2.Width = atl * 158 / 31 + 5 UserForm2.OKknop.Left = atl * 158 / 31 + 25 When I use Show to activate UserForm2 , the width of the UserForm and the position of the OK button are changed, but not the width of the ListBox! Why not? Any hint is very welcome! -- met vriendelijke groetjes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
Listbox - Width | Excel Programming | |||
Dynamically populating a 14-column listbox | Excel Programming | |||
listbox integral 'width'? | Excel Programming | |||
dynamically created listbox | Excel Programming |