Populate user form based on combobox choices

[zardof]

I am trying to populate the edit record form. based on the selection from the Surname and first name comboboxes. once the data is edited the click the edit button to Save the changes. i have tried amending sample codes to acheve this but end up completely lost. can anyone help please.

[stojko89]

I'm editing your userform now. And should be done in 10min
I'll upload the file back to you.
But I'm putting in a sample. You'll have to edit the code for the userform to work all the way.

[stojko89]

Here is the workbook back
I've made it so when you pick a surname and name you want to edit it inserts the phone number in the userform so you can view it.
You have to edit the code so other listboxes will be populated with the right info <<---check code.

After you have done editing you hit the edit button and it will edit the values on the sheet of the surname and name you click.
In case you're trying to edit a name or surname that doesn't exist on the sheet it will pup up a msg box that says the names were not found.

Try it out and let me know how it goes

[zardof]

This is working almost perfectly. i am having trouble getting The AGB Text box to show the formula results for its offset.

[stojko89]

It shows the result.
Do you want it to write $38,00 instead of only 38?

[stojko89]

So for populating agb1 use this:

Please Login or Register  to view this content.

Just change the € to the Pound sign

[zardof]

Thats what i was trying to show. but when you edit the record it over writes the formula in the cell. is there a way of just showing the result of the formula. i have tried locking the textbox but no joy there.

[stojko89]

Maby when you hit Edit - The code should leave the agb1 out and not copy the value from the form to the sheet, because the formula in the sheet will give you the new value in on sheet anyway.
So don't do the

Please Login or Register  to view this content.

<<<----leave this part out of the code.

[zardof]

That did it thanks very much