tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,210
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I've been playing around with activex text boxes and have found I can adjust the height as I type.
so what I would like is a bit of code that can adjust the textbox to one line bigger (or the size of the text i'm tying in
I have this bit of code that will resize the text box so I need someone to show me how to make it dynamic if possibleplease
this is what I have it triggers everytime you type into the textbox.
please help if you can thanks
Tony
I've been playing around with activex text boxes and have found I can adjust the height as I type.
so what I would like is a bit of code that can adjust the textbox to one line bigger (or the size of the text i'm tying in
I have this bit of code that will resize the text box so I need someone to show me how to make it dynamic if possibleplease
this is what I have it triggers everytime you type into the textbox.
Code:
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Private Sub TextBox1_Change()
ActiveSheet.Shapes("TextBox1").Height = 300[/FONT]
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]End Sub[/FONT]
please help if you can thanks
Tony