Variable not set

[Cozzy123]

I'm trying to use VBA to view fields in a textbox taken from a spreadsheet. That is working fine. What I want to do, if I want to update said spreadsheet, i.e. I reviewed the text in the textbox but I want to add an update I want to be able to over right the text that is there and put it back in the same cell place within the spreadsheet. I had this working fine on another spreadsheet I did years ago with the following code, but I must have done something else but I can't remember, and I can't find it in my code.

I used this code, and it previously worked, but its not working now, I've obviously forgot to do something.

Sheets("Table").Range("h1") = ComboBox3

Set r = Sheets("Data").Range("j9")
Set c = Sheets("Data").Range("j10")

Sheets("Table").Cells(r, c) = TextBoxtu.Value

Please help

 

[RoryA]

Check the values of r and c at the time the code runs and make sure they are correct.

 

[Cozzy123]

What I'm trying to do is find where the original text was entered into a spreadsheet table..... then overwrite it with the new text and put it back into the same place as the old text was.

So I used index match to find the location it was in the table, i.e row and column, and then reinput the text from the textbox back to the same cell (r and c), it works on my other sheet but not this one, so I'm not doing something correctly.

I have it working, thanks