You can build a custom UserForm to do all of this. It requires a little bit of VBA to make it function but is far more flexible than the built in forms that Excel has.

Attach a sample workbook and a little more info around what you want it to do and I'll gladly help you along the way with it.

BSB