useform with flexibel textfield

  • Thread starter Thread starter Siegfried
  • Start date Start date
S

Siegfried

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
 
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
 
Back
Top