Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ControlSource
Can someone help me with what the control source is on a textbox and how to
write it in the properties menu of the vb editor Thanks in advance Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ControlSource
Greg
A Control Source is a reference to a worksheet cell linked to the TextBox field on your UserForm. You can type in a cell address (use a sheet reference) or with a cell name. Once you enter the reference to the worksheet, what you type in the UserForm TextBox will appear in the Be aware that a Control Source will overwrite the value in the cell, even if it is a formula. (That is, if you enter a formula into the linked cell, the UserForm text box will show the value in the UserForm TextBox. However, once you view the value in the UserForm, the formula will be replaced with it's value only.) Play with it a few times on a test sheet... Jim Greg wrote: Can someone help me with what the control source is on a textbox and how to write it in the properties menu of the vb editor Thanks in advance Greg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ControlSource
Thanks Jim
I was trying to work out another way of using a combobox. I knew I was wrong just had to have someone confirm it for me. Thanks for the quick response Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change UserForm ControlSource with VBA | Excel Discussion (Misc queries) | |||
ODBC ControlSource | Excel Programming | |||
Controlsource | Excel Programming | |||
ControlSource Compatibility VBA - VB6 | Excel Programming | |||
ControlSource problem | Excel Programming |