Enhanced Data Form
Excel's Data Form command is handy, but it probably doesn't work exactly as you'd like. Because you can't customize the Data Form dialog box, I created my own version using VBA. My add-in works very much like the Data Form command, but it has many improvements. Better yet, since it's written in VBA it can be customized any way you like.
You can use the add-in any way you like. It's completely free. However, if you'd like to view or modify the VBA source, you'll need to purchase the password to unlock the add-in. Exploring the VBA code will reveal lots of useful VBA techniques.