MrExcel.com - Your One Stop for Excel Tips & Solutions

Data Forms Editability?

Posted by Andy on July 04, 2001 2:24 AM

Is the Data form accessible to edit? ie remove the buttons and add extra text, or has anyone come accross a way of designing a userform to handle the same functions?

Thank you
Andy

Posted by Cory on July 04, 2001 6:38 AM

You can't edit an excel dataform, but you can build one yourself. To explain how to here would take a novel (or close to it:-) ).
If you're not aware of the VBEditor go to View --> Toolbars --> Visual Basic then hover over the buttons until you find the Editor. Have fun! Or aske more questions:-)

Cory