VBA: Add Info to a Named Range from a textbox

[bamaisgreat]

I need a userform that when I enter info in a textbox and click a command button it will add that information to a range named "Grade" this range is located on sheet 1.
Thanks for looking

 

[Domenic]

Assuming that the scope of the named range is the workbook, try...

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

Change the name of the TextBox, accordingly. If the scope of the named range is the worksheet, you'll need to qualify the referrence for the named range with the name of that worksheet.

 

[bamaisgreat]

Thank you Domenic, I cant seem to get the sheet in the code correctly.
The Range is on a different worksheet.
The Sheet name is "LIST"

I tried this but it did not work..

Private Sub CommandButton1_Click()
Sheet ("List")
Range("Grades").Value = Me.TextBox1.Value
End Sub

 

[bamaisgreat]

Domenic I figured out the correct way to enter it

Private Sub CommandButton1_Click()
Range("List!Grades").Value = Me.TextBox1.Value
End Sub

When I enter "a709"in to the text box it replaces all 20 names in the named range to "a709"
I need it to just be added to that named Range.

Thanks you again !