is there a way to customize data validation list Boxes?
This works
Sub MyWidth()
For x = 300 To 20 Step -20
UserForm1.Show
Next x
End Sub
So, I guess the answer is yes, you can vary the width with
UserForm1.ListBox1.Width = x
Allan wrote:
is there a way to customize data validation list Boxes? For example can the
list box be made longer to show more of the listed items and be text
sensitive so keying the first letter of word will focus into the section of
the list containing similar words. Can the list box be changed use VBA?
--
Allan
|