Forex-Forex
08-04-2017, 12:21 PM
Hi Excel Community
I have attached a questionnaire template and would like to modify the VBA slightly to show the following:
At the moment if you click on the create questionnaire button, an Excel template is created on your desktop.
However, when you choose the text box option, I can easily modify the length and width.
What I would like is on the text box option is to have a scroll bar because at the moment when you start typing and after it reaches the text box length you start losing visibility.
I would like if I choose a particular text box size, once it reaches the particular length, it then goes onto the second line.
I hope I am clear.
Is this possible community?
Appreciate any assistance.
Thanks
I have attached a questionnaire template and would like to modify the VBA slightly to show the following:
At the moment if you click on the create questionnaire button, an Excel template is created on your desktop.
However, when you choose the text box option, I can easily modify the length and width.
What I would like is on the text box option is to have a scroll bar because at the moment when you start typing and after it reaches the text box length you start losing visibility.
I would like if I choose a particular text box size, once it reaches the particular length, it then goes onto the second line.
I hope I am clear.
Is this possible community?
Appreciate any assistance.
Thanks