listbox help

[ass98]

help me please, i have a list box on a userform which displays my table data.

i want to be able to click on the specific row of data and press a button which will place that row of data in another userform so i can edit the data.

 

[ass98]

some one must know the answer

 

[Mudface]

If you want to display the data in a listbox in the second userform, then you could add the following code to the first userform's code module.

Private Sub CommandButton1_Click()
UserForm2.Show
End Sub

Private Sub ListBox1_Click()
UserForm2.ListBox1.AddItem Me.ListBox1.Text
End Sub

Note, I've used the default names for the userforms and listboxes, change these as appropriate.

 

[ass98]

if this data can be edited in list boxes then yes if not then input boxes