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.

Attached Files

Dzib.xlsm (24.9 KB, 6 views)