Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have been trying to change the width of a textbox on a user form with
code, but it keeps on going back to it's original size that I set in design. How can I let a user alter the size of a text box with a number I know how to get a number from the user, and check that number. Say I get 80 from the user the width is currently 40 Then my code looks like this.. (after controls and reading of variables. UserForm1.Controls(TextBox1.width) = 80 I have also tried TextBox1.width = 80 But something is missing here. Because when I close whatever code I write the text boxes go back to the original place and size in the formula. I have put these commands behind command buttons and in UserForm Initialise. Still doens't work. Any ideas/links? Garry Jones Sweden |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
autosum refusal to sum highlighted range | Excel Worksheet Functions | |||
Refusal to calculate | Excel Worksheet Functions | |||
Refusal to save | Excel Discussion (Misc queries) | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |