Good Morning Dominic

Thanks for the help installed the code as you recommended and on opening
the UserForm showed all the details from the Row on the Active Sheet and on
clicking the command button "Add Info" it put the row details on another
sheet correctly.
However on highlighting a row in the List Box no details showed in the text
boxes I had to go back to the sheet select a row and the new details showed.
What I wanted to do was get the details from the List Box on the UserForm and
just click "Add Info" Is this possible ????

Thanks Mully

"dominicb" wrote:


Good morning Mully

This piece of code should help, in your Userorm_Initialize:

Private Sub UserForm_Initialize()
TextBox1 = ActiveCell.Value
TextBox2 = ActiveCell.Offset(, 1).Value
TextBox3 = ActiveCell.Offset(, 2).Value
TextBox4 = ActiveCell.Offset(, 3).Value
End Sub

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=393594