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

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

On Jun 21, 1:09 am, Dave Peterson wrote:
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- Hide quoted text -

- Show quoted text -

Hi Mr. Dave,

I have this DataForm.xla but Exectly I need its source code, which I
could not find on the net semilar to this. I am surprised that I am
searching since long time but till now I did not get the same source
cods like this. and I could not find any solution to pay 20$ to
purchase the password from J-Walk.

Thank you very much for your support.

with best regards, may Allah pleased with you.

Shahzad

There is a link on John Walkenbach's back to buy the source code for his
enhanced dataform:

http://j-walk.com/ss/dataform/purchase.htm



wrote:

On Jun 21, 1:09 am, Dave Peterson wrote:
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- Hide quoted text -

- Show quoted text -

Hi Mr. Dave,

I have this DataForm.xla but Exectly I need its source code, which I
could not find on the net semilar to this. I am surprised that I am
searching since long time but till now I did not get the same source
cods like this. and I could not find any solution to pay 20$ to
purchase the password from J-Walk.

Thank you very much for your support.

with best regards, may Allah pleased with you.

Shahzad

--

Dave Peterson