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!
|