It's possible, whether it's worth it or not is debatable.
I think the very simplest way to deal with this would be using Excel's built-in data form.
It's very simplistic and you can use it straight away and it requires no programming.
Being a glutton for punishment though, I had to have a kick at the cat with a User form.
This puts two hundred text boxes into a scroll-able frame on the user form and who knows what would be required from there, more work than I'd want to do.
Good luck with your project.
|