UserForm hot to show values and change values

Good morning,

I want to make an UserForm what can do the following.

I have in column A an Id

In the form i fill in an Id

then it must show all known information
I also must be able to change that information, and that have to be saved.

for example
Excel sheet
Id name phone
1 A 0123
2 B 0456
3 C 0789

I fill in the form Id 1
it shows
name: A
Phone: 0123

then I change the phone into 0111

that have to be saved. And so on.

I hope you understand and can help with this
See also the attachment
thank you very much

Daniel bij de Leij

ps. excuse me, my English isn't that good.

Good Morning!

I hope this is what you wanted:

Please Login or Register  to view this content.

Thanks and all the best.