useform with flexibel textfield

hello

i have a useform - with a textfield.
at the moment I inital the textfield fix

I am looking for the code that i can write the text to inital the textfield
with a excel cell.

like: textfield = tabel1.Range(a6)


Bye Siegfried

Hi Siegfried

against the userform initialize event put code e.g.

Private Sub UserForm_Initialize()
TextBox1 = Sheets("Sheet1").Range("A6")
End Sub

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Siegfried" <Sigixx@hotmail.de> wrote in message
news:d4gke6$fd1$05$1@news.t-online.com...
> hello
>
> i have a useform - with a textfield.
> at the moment I inital the textfield fix
>
> I am looking for the code that i can write the text to inital the
> textfield with a excel cell.
>
> like: textfield = tabel1.Range(a6)
>
>
> Bye Siegfried
>

Julie!

you are a great woman :-))

Thank you

"JulieD" <JulieD@hctsReMoVeThIs.net.au> schrieb im Newsbeitrag
news:%23awmdLPSFHA.3444@tk2msftngp13.phx.gbl...
> Hi Siegfried
>
> against the userform initialize event put code e.g.
>
> Private Sub UserForm_Initialize()
> TextBox1 = Sheets("Sheet1").Range("A6")
> End Sub
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ...well i'm working on it anyway
> "Siegfried" <Sigixx@hotmail.de> wrote in message
> news:d4gke6$fd1$05$1@news.t-online.com...
>> hello
>>
>> i have a useform - with a textfield.
>> at the moment I inital the textfield fix
>>
>> I am looking for the code that i can write the text to inital the
>> textfield with a excel cell.
>>
>> like: textfield = tabel1.Range(a6)
>>
>>
>> Bye Siegfried
>>
>
>

I first it is looking very good you information

but the initial of the useform it deepend on witch button the user is
pressing.

First Button:

cmdFirstButton.onclick
{
useform(FirldA6 and Field C6)
}

Useform (FieldA, FirldB
{
txtDescribtion = Sheets("Sheet1").Range(FirldA)
txtExample = Sheets("Sheet1").Range(FirldB)

}

you know what i mean?

Bye Siegfried


"JulieD" <JulieD@hctsReMoVeThIs.net.au> schrieb im Newsbeitrag
news:%23awmdLPSFHA.3444@tk2msftngp13.phx.gbl...
> Hi Siegfried
>
> against the userform initialize event put code e.g.
>
> Private Sub UserForm_Initialize()
> TextBox1 = Sheets("Sheet1").Range("A6")
> End Sub
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ...well i'm working on it anyway
> "Siegfried" <Sigixx@hotmail.de> wrote in message
> news:d4gke6$fd1$05$1@news.t-online.com...
>> hello
>>
>> i have a useform - with a textfield.
>> at the moment I inital the textfield fix
>>
>> I am looking for the code that i can write the text to inital the
>> textfield with a excel cell.
>>
>> like: textfield = tabel1.Range(a6)
>>
>>
>> Bye Siegfried
>>
>
>