View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Philippe Léveillé Philippe Léveillé is offline
external usenet poster
 
Posts: 2
Default 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