Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to move 200 text boxes on a formula.
Instead of moving them by hand I have written some code behind a command button. For instance ____________________________________ Private Sub CommandButton1_Click() UserForm1.TextBox1.top = 10 UserForm1.TextBox1.width = 20 UserForm1.TextBox1.left = 10 End Sub ____________________________________ When I click the command box they move. But the next time I open the form they are back to the old postions. How do I get them to maintain the property I set with the button? Garry Jones Sweden |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
data range props | Excel Discussion (Misc queries) | |||
Textbox | Excel Discussion (Misc queries) | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |