| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing a Forms Properties
Excel 2003. I have created a user form called "Initialize." How do I
programmatically reference the properties of controls on the form? For instance, how would I reference and change the Caption property for a textbox called TextBox1 on the form called Initialize? Thanks for the help. Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing a Forms Properties
Seems like textbox controls DO NOT have a Caption property..
You probably want to creat a new control (a label cotrol) which has (I think) a caption property. "Chaplain Doug" wrote: Excel 2003. I have created a user form called "Initialize." How do I programmatically reference the properties of controls on the form? For instance, how would I reference and change the Caption property for a textbox called TextBox1 on the form called Initialize? Thanks for the help. Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing a Forms Properties
The syntax should be like:
Initialize.TextBox1.Text = "hello" however, if your piece of code is already within the form "Initialize", you can just refer to the textbox directly: TextBox1.Text = "hello" Regards, Edwin Tam http://www.vonixx.com "Chaplain Doug" wrote: Excel 2003. I have created a user form called "Initialize." How do I programmatically reference the properties of controls on the form? For instance, how would I reference and change the Caption property for a textbox called TextBox1 on the form called Initialize? Thanks for the help. Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing a Forms Properties
A textbox doesn't have a caption. It has a text value though
Initialize.TextBox1.Text = "Doug" -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Chaplain Doug" wrote in message ... Excel 2003. I have created a user form called "Initialize." How do I programmatically reference the properties of controls on the form? For instance, how would I reference and change the Caption property for a textbox called TextBox1 on the form called Initialize? Thanks for the help. Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Accessing file properties | Excel Programming | |||
| Accessing Active X command button properties | Excel Programming | |||
| Accessing File Properties | Excel Programming | |||
| Accessing custom document properties | Excel Programming | |||
| Accessing properties of a series with no data | Excel Programming | |||
Hybrid Mode
