VB Form populating Excel - Just Learned it

[m17347047711116]

I just spent a long time learning how to create a VB form that populates fields on my spreadsheet using the following type of code:

Private Sub UpdateCustomerInfo_Click()
ActiveWorkbook.Sheets("SMRF").Activate
Range("A1").Select
ActiveCell.Offset(2, 1) = Phone.Value

Works Great but now I need to now how when I open the VB form a second time it picks up the current values in the spreadsheet.

What is happening is there are multiple people interancting with the Excel docuement and VB form.

The first individual opens up the form and enters some key information such as Contact Name, Phone Number , Customer, etc...

Then he/she e-mails the Excel doc to the next person and he/she then opens up the same form to populate or change some additional information.

When the second person does this and they add there required information because the fields to not pick up the current values on the spread sheet they are null or blank in all other fields and when the second person pushes the update click() it re populates over the first users input with null or blank values.

I know there has to be a way to pick the current values up each time you open that form or prevent the update_click() from writing back over the previous data.

Any help greatly appreciated, I have a June 15 deadline and I've been working non-stop on this form for weeks.

Thank you in advance.

On the up side I am doing things I thought I never could thanx to this forum.

 

[m17347047711116]

Got it on my own

Private Sub UserForm_Initialize()
ActiveWorkbook.Sheets("SMRF").Activate
Range("A1").Select
ReQuestType.Value = ActiveCell.Offset(9, 1)
End Sub

This Code populates the User Form with the current value that is in the spread sheet therefore you can view make changes and such and when you hit the update key it re-writes all information but does not erase existing information.