Thread
:
VBA dynamically change width listbox
View Single Post
#
2
Posted to microsoft.public.excel.programming
Frederik[_3_]
external usenet poster
Posts: 63
VBA dynamically change width listbox
Supplementary information:
If I put a Msgbox instruction in the code to display whatever message, then
the width of the listbox ís changed!
Strange ...
But I don't want that message on screen...
--
met vriendelijke groetjes
"Frederik" schreef in bericht
...
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 With Quote
Frederik[_3_]
View Public Profile
Find all posts by Frederik[_3_]