Userform textbox to fill into cell

[Garrek]

Hey all, feeling very dumb here. I'm trying to make a simple userform with one textbox, and when the user hits the "Retire" button it will input the data from the textbox into a specific cell (B14 in my case). This feels very simple and I've done it before, but for some reason I can't get it to work... Case of the Mondays?

Anyway, here's my current code for the box

Private Sub RetireButton_Click()


Set ssheet = ThisWorkbook.Sheets("New Motifs")


ssheet.Cells(2, 14) = tbCode


Unload Me


End Sub

Eventually I'll also tie to to a macro by using Call after the Unload me, but I can't get this simple thing to work. Any ideas?


EDIT:
Also, should've noted. The textbox is named "Code" and the worksheet it's on is New Motifs. (Figured I'd add, although you should be able to gather it from the code.

 

[trunten]

Try this:

Private Sub RetireButton_Click()
    ThisWorkbook.Sheets("New Motifs").Cells(2, 14).value = Code.value
    'ThisWorkbook.Sheets("New Motifs").Cells(2, 14).value = tbCode.value
    Unload Me
End Sub

I've also included a line (which I've commented out for now) which may in fact be the correct fix for you. I know you said that the textbox was named "Code" but because you had already used "tbCode" i wasn't 100% sure.

 

[Garrek]

Try this:

Private Sub RetireButton_Click()
    ThisWorkbook.Sheets("New Motifs").Cells(2, 14).value = Code.value
    'ThisWorkbook.Sheets("New Motifs").Cells(2, 14).value = tbCode.value
    Unload Me
End Sub

I've also included a line (which I've commented out for now) which may in fact be the correct fix for you. I know you said that the textbox was named "Code" but because you had already used "tbCode" i wasn't 100% sure.

This worked perfectly, thanks a ton! Fresh eyes helped