For simplicity there is:
ActiveSheet.ShowDataForm

Otherwise you can build your own user form.

NickHK

"TheGodfather" wrote in message
oups.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