VBA to format copied cells

[lateniteNC1]

I have a user form that is designed to copy user-entered data over to workbook sheet (Sheet3). I open the form with a blank worksheeet ("Form"). All functions with the form work fine. After copying the user-entered data (copied to Sheet3), i wish to format the copied cells (provide a red cell border). I have some code that supposedly does that, but cells on the blank "Form" sheet are being formatted with the red border, not the sheet where the data is being copied. For the life of me, i cannot figure out how this code is copying the data to the right sheet, but not doing the formatting on the same sheet.

My code:

Please Login or Register  to view this content.

There is additional code below this attached snippit to clear the form for next use (which works fine thanks to help on this forum).

Any help on getting this problem fixed is appreciated; since i am new to coding, please be specific.

[damor.dam]

Only the dot is missing to obtain the sheet reference:

Please Login or Register  to view this content.

[lateniteNC1]

Oustanding, that fixed the problem and saved me hours of headscratching.

[damor.dam]

I'm glad to help you. Thanks for the feedback.