View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Glynn Greg Glynn is offline
external usenet poster
 
Posts: 137
Default 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