View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Christian[_8_] Christian[_8_] is offline
external usenet poster
 
Posts: 17
Default Help its not working

Hi Steph

Try the following

Private Sub ListBox3_MouseDown(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
ListBox3.ColumnCount = 4
ListBox3.AddItem "West"
ListBox3.AddItem "East"
ListBox3.AddItem "North"
ListBox3.AddItem "South"
ListBox3.ColumnWidths = 200
UserForm1.Show
ListBox3.Clear 'This is to clear the Listbox otherwise it will load
the items every time

End Sub