Copying labels to Userform at runtime.
I'm not sure I understand your problem... but you can try to fill in the
textbox_change() event with some code to do the rest...
"Henry" a écrit dans le message de news:
...
I'm trying to set up an array of labels on a form at runtime.
The size of the array is determined from a textbox input at the top of the
form.
The sort of thing I want is like a blank crossword grid, where I can
adjust the caption in each label later to be 1 letter.
I've tried to copy a label and then paste it, but VBA doesn't allow this.
Has anyone any suggestions on how to achieve this?
TIA
Henry
|