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

--

Helmut Weber

Win XP, Office 2003

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> --
>
> Helmut Weber
>
> Win XP, Office 2003
>

Thank you Bob

--
Greetings from Bavaria, Germany

Helmut Weber

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