Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting initial value on text box?
Does anyone know how to set an initial value on a text box? I want
to go to a specific place on my worksheet and get the value that will be the initial value and put it into the form that the user will then either keep or change. I read a post saying to use a private sub_initialize in my userform code section that excel created for me and I put this code into it but the value of Loc never shows up in the actual userform when I run my code. Private Sub UserForm1_Initialize() Dim Loc As Range Set Loc = Worksheets("Internals").Range("B4").CurrentRegion TextBox1.Text = Loc End Sub Thanks, Chet |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting initial value on text box?
Private Sub UserForm_Activate()
TextBox1.Text = Worksheets("Internals").Range("B4") End Sub Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting initial value on text box?
A non-VBA way of doing this would be simply to set the "ControlSource"
of the TextBox to a named range. The default downside here (or upside, depending on what you want) is that any change to the value in the textbox would also change the value in the cell. To prevent that automatic update behavior, you can set the 'Enabled' property of the textbox to 'False' / Tyla / On Mar 20, 2:35 pm, "merjet" wrote: Private Sub UserForm_Activate() TextBox1.Text = Worksheets("Internals").Range("B4") End Sub Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting up conditional text input | Excel Discussion (Misc queries) | |||
Text format - setting text colour with code | Excel Discussion (Misc queries) | |||
Setting the Chart name as the text from a cell. | Excel Programming | |||
Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
Text Box - Setting Values | Excel Programming |