Thread: New to me
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Striker Striker is offline
external usenet poster
 
Posts: 55
Default New to me

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?