How to copy data from a cell in excel onto a field in a table in access db using vba

[Codeeachday]

So I am trying to type data into cell B9535 in excel and use an ActiveX submit button to have this data appended to a table called 'tblImport' in Access to the Field called 'SalesOrderID'
Here is the code:

Please Login or Register  to view this content.

When I compile the code, there are no errors, nothing is appended in access.
Please help!

Moderator's Note: Welcome to the forum. Btw when posting codes be sure to enclosed the with code tags. Select the codes then hit the "#" symbol. I'll do it for you now. Thanks.