Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change textbox caption in Active sheet from UserForm
Hi there,
I have a textbox1 in Active sheet (Sheet1). How do I change the caption of this textbox1 from userform command button 1? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change textbox caption in Active sheet from UserForm
You have to be in design mode and then change the property.
1) from worksheet menu - View - Toolbars - Control Toolbox 2) Press triangle to enter or exit Design Mode. It toggles back and forth 3) Press the tesxt box then press Properties ICON in the Control toolbox toolbar. 4) Change the caption. "mba1976" wrote: Hi there, I have a textbox1 in Active sheet (Sheet1). How do I change the caption of this textbox1 from userform command button 1? Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change textbox caption in Active sheet from UserForm
I think you are refering to changing the Caption or LABEL of the Textbox via Code, is this correct ?
"mba1976" wrote in message ... Hi there, I have a textbox1 in Active sheet (Sheet1). How do I change the caption of this textbox1 from userform command button 1? Thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change textbox caption in Active sheet from UserForm
Try:
Dim res As Variant ActiveSheet.Shapes("Label 1").Select ' Modify Label 1 to suit what the label Number Is res = InputBox("What do you want to name it ?") Selection.Characters.Text = res Corey.... "mba1976" wrote in message ... Hi there, I have a textbox1 in Active sheet (Sheet1). How do I change the caption of this textbox1 from userform command button 1? Thanks, |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change textbox caption in Active sheet from UserForm
Sheets(1).TextBox1.Text = TextBox1.Text
this is the command from the userform *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change color of userform caption bar | Excel Programming | |||
Change label caption on userForm while code runs | Excel Programming | |||
Userform Listbox using an active sheet | Excel Discussion (Misc queries) | |||
userform - active sheet | Excel Programming | |||
Accessing a non-active sheet from a userform | Excel Programming |