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