help with a user form in excel to update records.

[Abouya]

Hello,

I'm trying to find a solution for updating company contact info/phone/email etc using a form in excel. First, I use the Combobox to find the company and records will show using Vlookup. how I can change/update the records of selected company and sending them to the spreadsheet?

I attached the excel file.
https://drive.google.com/open?id=0B2rP1tZjVvliOXVHeklFNS16V2M

Thank you so much for your guidance.

 

[Ranman256]

wouldnt you just goto the record in the sheet, then change it in the cells?

 

[Abouya]

wouldnt you just goto the record in the sheet, then change it in the cells?

Others will be using it as well and i dont want them to see this spreadsheet. This for will be invoked from the main spreadsheet. Thanks for responding.