using for to update spreadsheet after selecting company from combobox

[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.

 

[Rx_]

You mentioned using the Excel Forms. It has been a while since I did that.
Basically, on the change, look up a Buddy Control.
For example, a slider bar can be used to update a cell - and that cell might be used to control a chart view degree, or other aspects of your calculated areas.

However, my preference is to use a Cell with the DataSelection that is linked to a Named Range. It emulates a Combobox.
Chose a Cell - then in the menu Data - Data Validation, then choose LIST
You can search for the rest. Basically, use a Named Range or a range of cells to create the List. Choose In-Cell Dropdown. This cell will now display a dropdown arrow like the Combobox. The default is for a refresh to take place on a change.
If the calculated column includes this cell, it will refresh, basically a query run on the data in Excel uses in the calculation.
Seems as if I added a demo on this site years ago. Or maybe it is still on my "To Do" list?

The List