bringing up the data -> form... box via macro

Hello

I have a simple list of data running fine, everything is going well. I want to jazz things up a bit by having a button which my users can press to edit the data in the list via the form... box, where they will be able to edit fields and move on to the next record easily.

I've tried recording a macro, but upon running it says

Run-time error '1004': ShowDataForm method of Worksheet class failed

Knowing nothing about VBA, I'm presuming I have to do this in some way other than simply recording clicking in the list, then clicking Data -> Form....

Could someone just quickly give me a little macro that will bring up the Form... box without a hitch?

Please let me know if you require anymore information... I'm new to all this... Cheers!

Many thanks for your reply dominicb.

Unfortunately I've tried what you suggested and it still comes up with the same error. Am I missing something here? I've copied exactly what you wrote and completely replaced the code of the macro with your code. And I've reassigned the macro to the button just in case.

Any ideas? Should I abandon the extravagance? It really would be a nice addition to my spreadsheet. Cheers for the help!

Anyone? Please help if you can.

thanks for replying guys, especially as its such a trivial problem.

It doesn't matter now, cos I can just put my data onto your table that you posted and then it all works. My macro is exactly the same as yours but it doesnt work, and I just don't know why. It's bizarre.

It goes without saying that I'm a complete novice at this but I definitely want to learn and I've just bought a book to help me. So maybe in a few weeks I'll be able to work out what I'm doing differently, it's probably something very basic. Thanks again for your help!

I'll probably ask another question shortly....I'm fiddling around with stuff.

could this be the reason...

does the table have to begin at cell A1? mine was offset slightly with the button positioned above the table. moving things around seems to have made the button now work. What the hell?

Originally Posted by splodgecat

could this be the reason...

does the table have to begin at cell A1? mine was offset slightly with the button positioned above the table. moving things around seems to have made the button now work. What the hell?

Playing around with it a little, it looks like the upper-left corner of the table needs to be somewhere in the range of A1:B2, not sure why, though.