Thread
:
ControlSource in a userform textbox
View Single Post
#
2
Posted to microsoft.public.excel.programming
keepITcool
external usenet poster
Posts: 2,253
ControlSource in a userform textbox
the control source needs a string. and I assure you it;'s wise to make it
fully qualified.
MyControl.controlsource = _
Thisworkbook.Worksheets("y").Range("a3").Address(E xternal:=True)
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage:
http://members.chello.nl/keepitcool
(Ian Mangelsdorf) wrote:
Hi all
Im trying to se the controlsource property for a series of text boxes
I have created on a user form. Im doing this by going to the
properties of the text box and inseting the cell reference of the cell
I want it linked to
Every time I try (and ive tried a few variations) I get "could not set
the ControlSource property. Invalid Peopery value" error
i have tryed the following format all with the same outcome
sheet3!c3
Sheet2!"c3"
=sheet3!c3
=sheet31"c3"
can any one tell me the correct form for entering the control source
Cheers
Ian
Reply With Quote
keepITcool
View Public Profile
Find all posts by keepITcool