Macro to edit details

[adn4n]

Hi, i am currently trying to create a macro regarding editing staf
details on a worksheet.......

therefore i recorded a macro and named it editstafflist, i highlighte
my headings...and then went to 'data > form' and then had to close th
form and then stop my macro. It wouldnt allow me to stop my macr
whilst the dialogue box was open. Anyways after stopping the macro
drew out a button and assigned this 'editstafflist' macro to it.
saved my sheet and then clicked on the button, but a error '1004' kep
occuring, can anyone please help me on this as i am rather stuck
thankyou.

....basically all i need is a macro, so that everytime it is clicked
data form would show, so that it allows a user to edit, delete, o
allow the user to enter a new employee.. regards

 

[AlfD]

Hi!

http://www.j-walk.com/ss/excel/tips/index.htm offers a mor
sophisticated form than the built-in Data>Form (which won't let yo
automate it by recording a macro).

Otherwise, I guess you are into creating your own form (Alt+F11
Insert>UserForm) populated with the labels, textboxes and controls yo
need to do your editing. Then there's the code to get the data from th
form to your database.

Al