ListBox
 

I have a Listbox on my userform which has referances 14 columns on a
worksheet. What I need to know is how when I click on the Finish button on
the UserForm, can I get all the data from those columns to fill in the
current worksheet, starting with the current cell?

ListBox
 

On 25 Mar, 01:50, ordnance1
wrote:
I have a Listbox on my userform which has referances 14 columns on a
worksheet. What I need to know is how when I click on the Finish button on
the UserForm, can I get all the data from those columns to fill in the
current worksheet, starting with the current cell?

Phillip UK London

This works for me
This is the userform code

Private Sub UserForm_Initialize()
Me.ListBox1.ColumnCount = 14
End Sub

Private Sub CmdFinish_Click() 'Finish button
Const LASTROW As Long = 65532 'change re Excel version
Const FC As String = "A" 'first column - change as required
Const LC As String = "N" 'last column - change as required
Dim x As Long 'first row
Dim y As Long 'last row

x = ActiveCell.Row
y = Range(FC & LASTROW).End(xlUp).Row
If x y Then
MsgBox "No data found"
Else
Me.ListBox1.RowSource = FC & x & ":" & LC & y
End If
End Sub