I have a form that collects the user's bank account details in 2 textboxes
(one for the account name, the other for their account number). The
preprinted forms that we use have boxes for each character of the name &
digit of the account number.

I've set up cells to match the placement of these boxes, but I'm trying to
work out how to use VBA to split the client details across these cells. I
can do this using functions, but I want to avoid having functions appearing
in what will be unlocked cells.