Hi,
On a User Form I have a Combo-box filled with names. The Userform can either be used in English (names are left-aligned, scrollbar at right) or in Hebrew (names are right aligned, scrollbar on the left side). The user can select the language by means of option buttons.
In Excel 2003 all I had to do is was changing the setting of the Text Alignment property, this took automatically care of the positioning of the scrollbar. Now, running the same program on Excel 2010, changing text alignment only affects the positioning of the text but leaves the srollbar on the right side of the combo box, effectively covering the first letters of the names!
Does any of you have an idea, how I can get over this problem in VBA (The routine should continue to run on Excel 2003)?
On a User Form I have a Combo-box filled with names. The Userform can either be used in English (names are left-aligned, scrollbar at right) or in Hebrew (names are right aligned, scrollbar on the left side). The user can select the language by means of option buttons.
In Excel 2003 all I had to do is was changing the setting of the Text Alignment property, this took automatically care of the positioning of the scrollbar. Now, running the same program on Excel 2010, changing text alignment only affects the positioning of the text but leaves the srollbar on the right side of the combo box, effectively covering the first letters of the names!
Does any of you have an idea, how I can get over this problem in VBA (The routine should continue to run on Excel 2003)?
Last edited:
