View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Soniya[_4_] Soniya[_4_] is offline
external usenet poster
 
Posts: 73
Default UserForm TextBox with fixed Width and dynamic Height

Hello,

Can we have a multi line TextBox in a Userform with fixed width but the
height adjusting according to the length of text? Say if the textbox
contains text to be fit in five lines then adjust the height
accrdingly? also with a maximum height fixed, so that it may not be
more than the height of the userfom itself.

Thanks