View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 21
Default newbie userform problem

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