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

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

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