VBA help edit/update userform help

[sa.1985]

Dear Sir,


Please find the attached file of data entry userform.


https://docs.google.com/open?id=0B6VY6rBw3NuBRF92Qmt6MlpaQlU


you will find in sheet two buttons 1. Add data and 2 . Edit / Update data


My question is that ...

In edit/update data userform, when i click button update record then new rows create in excel it should not to be .

only update record which sr no i selected ..


can u help me in this vba coding .

 

[SirJB7]

Hi, sa.1985!


In UserForm2 at click event of CommandButton1, replace this:

With MyRange.Find(Labe21)


by this:

Range("A3").Select

With ActiveCell.Offset(ComboBox1.ListIndex, 0)


Regards!

 

[sa.1985]

Thank you , So much SirJB7


now this workbook working with my request ...


thanks a lot

 

[SirJB7]

Hi, sa.1985!

Glad you solved it. Thanks for your feedback. And welcome back whenever needed or wanted.

Regards!