I have a workbook with 12 sheets, a userform and a couple of modules. This
is my first foray into using a UserForm for data entry. I run the UserForm
from a customized ribbon tab. I would like to set the ControlSource property
in a textbox to a sheet called "UserData" into cell B4.
When I try to enter Worksheets("UserData").Range("B4") (or all combinations)
I get an error: "Could not set the ControlSource property. Invalid property
value."

Could you please explain how I do this properly?

Thanks very much.

... rick

Hi Rick,

TextBox1.ControlSource = "UserData!B4"


--
Regards,

OssieMac


"rick" wrote:

I have a workbook with 12 sheets, a userform and a couple of modules. This
is my first foray into using a UserForm for data entry. I run the UserForm
from a customized ribbon tab. I would like to set the ControlSource property
in a textbox to a sheet called "UserData" into cell B4.
When I try to enter Worksheets("UserData").Range("B4") (or all combinations)
I get an error: "Could not set the ControlSource property. Invalid property
value."

Could you please explain how I do this properly?

Thanks very much.

... rick

I like:

TextBox1.ControlSource _
= worksheets("UserData").range("B4").address(externa l:=true)

Then I never have to worry about the syntax.

rick wrote:

I have a workbook with 12 sheets, a userform and a couple of modules. This
is my first foray into using a UserForm for data entry. I run the UserForm
from a customized ribbon tab. I would like to set the ControlSource property
in a textbox to a sheet called "UserData" into cell B4.
When I try to enter Worksheets("UserData").Range("B4") (or all combinations)
I get an error: "Could not set the ControlSource property. Invalid property
value."

Could you please explain how I do this properly?

Thanks very much.

.. rick

--

Dave Peterson

Thank you very much OssieMac and Dave Peterson. It looks like I can't put
the target into the Property sheet's controlsource but it works within a
subroutine of the UserForm.
"rick" wrote in message
...
I have a workbook with 12 sheets, a userform and a couple of modules. This
is my first foray into using a UserForm for data entry. I run the UserForm
from a customized ribbon tab. I would like to set the ControlSource
property in a textbox to a sheet called "UserData" into cell B4.
When I try to enter Worksheets("UserData").Range("B4") (or all
combinations) I get an error: "Could not set the ControlSource property.
Invalid property value."

Could you please explain how I do this properly?

Thanks very much.

.. rick