Transfer data from a VBA userform to an Excel spreadsheet

Hey,
I am trying to make the data that will be inserted in my userform automatically gets stored into designated cells in my excel spreadsheet so that the user can have records that can be retrieved later. My main problem is finding the correct codes that allow the data i enter to be plugged in the desired sheet.
thank you

Emad
stamadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sharjilsalemCommented:
The syntax for refrencing a particular cell in an excel worksheet using VBA is

Worksheets("SheetName").Cells(Row,Column).Value

In the above command, u will have to use the RC format for refrencing a particular cell n not the default A1 format. for example if u want to refrence the cell B2, so this will be refrenced as (2,2), ie; 2nd row 2nd column. similarly D5 will be refrenced as (5,4).

Now, assuming u are receiving data from the user in a textbox named Text1 and the name of the worksheet into which u want to enter the data is Sheet1, and the cell into which the data has to be entered is B10, then the following syntax will be used

Worksheets("Sheet1").Cells(10,2).Value = Text1.Text

Hope this answers ur question.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
alfDCommented:
One further point:
If you want the data to go to the worksheet immediately you change the textbox, you could use Text1_Change to trigger the transfer. Or you could leave it until you exit the form, if, say, you have a number of changes to make.
0
CleanupPingCommented:
stamad:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.