Edit worksheet data thru userform

Hi,

Thank you royUK for your useful link you posted,

I applied amendment code in the mentioned link database form example, but it didn't work with me.

Please Login or Register  to view this content.

No errors appear, but the updates are inserted in the first row of the range only,, I don't know why!!!

Can you please find me a solution for that,,

The code is derived from the example, the only difference is that I removed some lines, which I don't need in my code.

But, the problem now is that when I edit for example record No. 4 of my range .. the changes are inserted in record number 1 not 4 and so on.

I hope that you can find the reason behind that and solve the problem.

Thanks,

Hi,

Until now I coundn't understand how the code in example works exactly,,

What does (r) in the following part refer to?

Please Login or Register  to view this content.

It will be better for me if you correct my code's mistakes and post it?

Thank you,

Hi,

Can you please help me in this query, I really need the answer ASAP,

Thanks,

Yes, the workbook in my first post does record the changes perfectly if we change the TexBox1 value only ,,

But once we change ComboBox1 value, the code returns an error, because the code looks for ComboBox1 value and doesn't find it in the database because it has been changed and the new value is not available in the database.

So, I think the solution is that we have to save ComboBox1 original value somewhere else, in order to use it for database search.

I hope that you got my idea now,

Thanks,

Sorry royUK, there is no difference between your code's result and mine,

The problem is still existing .. the changes are still recorded in the first record.

Anyhow, I found a solution but it is not that much practical.

My trick solution is saving combobox value in a label (the label will be hidden), and the use the label value as a database search key,

See my attachment.

Thank you,

Therefore, I think that there is a relationship between The example find code and amendment code .. but I don't know what is it exactly??!!!

Hi,

As I expected, There is a relationship between The searching Code and Amendment Code, which complete each other.

Searching Code's job is looking for the concerned record (selected by ComboBox) and stops on it by (Using Select property).

Then, Amendment code pastes the new changes to the recoded selected by Searching code.

Anyhow, I summarized the code to fit my need.

Please Login or Register  to view this content.

The only problem with this code is that it works only on the database sheet .. but when we run the code from another sheet, it doesn't work at all,

Therefore, for me the only solution for that is the trick I mentioned in My post # 14.

Thanks for all,

Hi,

Thank you Krishnakumar for your reply,

Your codes are excellent, but I am so sorry to tell you that the problem is still existing

What is new in your codes is the following,

If ComboBox1 value was changed, the new values are not recorded in the first row of the list like previous examples, but they are added to the worksheet list as a new record.

Anyhow, I think the best and the most satisfactory solution for this case is creating a new Textbox and use the first one for employee name and the other one for badge number and ComboBox1 value will stay as it is without changing.

Thank you all,