I've never worked with linking userforms to spreadsheets,
so this is a relly basic question. I'm running Excel 2000
on Win 98 and working throught the std VB tool.

When I create a textbox, on a blank UserForm, I cannot set
the ControlSource to a cell on a worksheet I have re-
named. I get a "Could not set ControlSource property.
Invalid property value." VB Error. If I try to set the
ControlSource on a sheet I have not named, I can set it
with no problem.

What am I doing wrong?

thanks

Kevin

Kevin,

Would help if you gave a little more information (like the name
of the worksheet).

Regardless....
just guessing here, but does the sheet name have a space in it???
If so, it needs to be enclosed on single quotes.

'Hello World'!A1

John

Kevin wrote:

I've never worked with linking userforms to spreadsheets,
so this is a relly basic question. I'm running Excel 2000
on Win 98 and working throught the std VB tool.

When I create a textbox, on a blank UserForm, I cannot set
the ControlSource to a cell on a worksheet I have re-
named. I get a "Could not set ControlSource property.
Invalid property value." VB Error. If I try to set the
ControlSource on a sheet I have not named, I can set it
with no problem.

What am I doing wrong?

thanks

Kevin