i want to make a library in excel from VBA i need to put 3 things
1) INSERT
2)DELETE
3)UPDATE
from the insert thing, i have to enter a record into excel, from
delete, i want to delete the whole record and from update i have to
ba
able to call a value i entered from insert and change it so by
pressing the update or runing it i ll be able to change the value and
update it to the record
could anybody help? please

perhaps these will help:


http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


John Walkenbach's site:
http://j-walk.com/ss/excel/tips/userformtips.htm
Userform Tips

--
Regards,
Tom Ogilvy



"TheGodfather" wrote:


i want to make a library in excel from VBA i need to put 3 things
1) INSERT
2)DELETE
3)UPDATE
from the insert thing, i have to enter a record into excel, from
delete, i want to delete the whole record and from update i have to
ba
able to call a value i entered from insert and change it so by
pressing the update or runing it i ll be able to change the value and
update it to the record
could anybody help? please

Hi Godfather,

Perhaps look at Excel's Data tool:

Menu | Data | Form

For a more sophisticated alternative to Excel's Data
Form, see John Walkenbach's Enhanced DataForm,
which may be downloaded, free of charge, at:


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


Fopr additional customisation, the code password is
available for a nominal sum.


---
Regards,
Norman


"TheGodfather" wrote in message
ups.com...

i want to make a library in excel from VBA i need to put 3 things
1) INSERT
2)DELETE
3)UPDATE
from the insert thing, i have to enter a record into excel, from
delete, i want to delete the whole record and from update i have to
ba
able to call a value i entered from insert and change it so by
pressing the update or runing it i ll be able to change the value and
update it to the record
could anybody help? please

You didn't consider the suggestion in the response to your first post?

TheGodfather wrote:

i want to make a library in excel from VBA i need to put 3 things
1) INSERT
2)DELETE
3)UPDATE
from the insert thing, i have to enter a record into excel, from
delete, i want to delete the whole record and from update i have to
ba
able to call a value i entered from insert and change it so by
pressing the update or runing it i ll be able to change the value and
update it to the record
could anybody help? please

--

Dave Peterson