Hi Striker

See this KB
http://support.microsoft.com/default...b;EN-US;829070


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Striker" wrote in message ...
I am kind of new to VBA. I picked up a book and will try to figure it all out. In reading through some of the posts, this board
looks like a good place to ask questions. Please let me know if there is a better one.

Question. In Excel 2002, I want to load a form that copies text data from a row of cells into a form. So my first question is
how do I load the form I created? What I did is add a module with one sub that just loads the form into memory, like below....

Sub LoadForm()
Range("A2").Select
Load frmMain
End Sub

Then I was thinking about putting code to copy cells of data into text boxes using the offset method from "A2" in the Form
Initialize event.

I want the user to manually start the form, so am I on the correct track with where I'm going?