controlsource cells(2,3) ?

[Helmut Weber]

Hi everbody,

is there a way to define the controlsource property
for a textbox on a userform like
textbox1.controlsource = cells(2,3)?

I got textbox1.controlsource = "c2" working,
but for programming issues, I'm used to (rowindex, columnindex).

Also, I'd like to know,
how the two possible reference styles are called.

Thx

 

[Bob Phillips]

textbox1.controlsource = cells(2,3).Address(false,false)

should do it

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Helmut Weber]

Thank you Bob

--
Greetings from Bavaria, Germany

Helmut Weber

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"