userform and named cell

[buzz71023]

is there a way to make a textbox iput data to a named data?

I cant seem to figure it out.

What I have to far:

Private Sub CommandButton1_Click()
Dim iRow As Long
Dim WS As Worksheet
Set WS = Worksheets("DataSheet")
'copy the data to the database
WS.Cells(3, 15).Value = Me.TextBox1.Value

End Sub

Cell O3/(3,15) is named Thickness. I would like for textbox1 to equal Thickness

 

[Smitty]

How about:

Me.TextBox1.Value = Range("Thickness").Value

HTH,

 

[buzz71023]

No that didnt work. I tried retyping it a couple of differnet times just to make sure I got it right and tried copy and paste it didnt work. I had actually what you did when I tried but forgot to but the .Value in the code.

 

[buzz71023]

I got it thanks for the help. dont think i would have figured it out so quick without your help. it was

Range("FTIRThickness").Value = Me.TextBox1.Value

Thanks again.