Thread: Listbox query
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg B[_5_] Greg B[_5_] is offline
external usenet poster
 
Posts: 54
Default Listbox query

Hi all how can I change the code below to copy the selected line from the
listbox and copy it to a sheet called popup. The code I received from
someone before workgreat in removing a message from another userform but I
would like to change it a little.



Private Sub CommandButton2_Click()

Worksheets("Messages").Range("A2").Offset(ListBox1 .ListIndex).Entirerow.Dele
te



End Sub


Thanks again

Greg