View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kenny kenny is offline
external usenet poster
 
Posts: 90
Default Multiple Activex TextBox on sheet auto size and move

I have a sheet with 6 text boxes one under the other. I would like to start
each box vertically sized to contain one row of data - then as the user types
it autosizes vertically to fit what has been typed - while this is happening
the boxes below it will move their position downward but keep the same
spacing between them - any ideas on code? THANKS!