Probably best in the module, a standard module, not a worksheet module.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Striker" wrote in message
...
WOW great response. OK now I am putting a command button to move to the
next row and put text from that row into the test boxes. I think I can
use
the offset method to do this, but I need to be careful in case someone has
changes the text in the form, I need to copy to the spreadsheet.

From reading thru this forum I was thinking about setting a variable
(bool)
to make the form dirty. Perhaps bDirty as booleen. Would this be a global
variable in the module, or could it be a global variable in the form?



"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?