Instead of designing your own form, you may find using Data|Form easier.

And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

wrote:

Hi,

I need help to Edit records of the worksheet from the Excel Userform.
what is the procedure?

Actually I want to view records in Userform and Scroll them in a
Userform by using NEXT, PREVIOUS, ADD, DELETE, EDIT records from the
Excel Userform.

Does anyone have the above solution. I am preparing a Store Inventory
System in VBA I need to Edit my records.

Pls help me in this regard.

Thanks in advance.

Shahzad

--

Dave Peterson