HELP: Run macro when Userform Close Button is clicked

[MooseMoney]

I need some help to run a macro when the Close Button on my userform is clicked.
I need the macro to run prior to closing the userform. This is what I have, but it
does not work;

Private Sub CloseButton_Click()
    
   Range("UserFormResults!C17").Select
   Selection.Copy
   Range("UserFormResults!C30").Select
   ActiveSheet.Paste
   ActiveCell.Replace What:="  ", Replacement:="", LookAt:=xlPart, _
   SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
   ReplaceFormat:=False
   Application.CutCopyMode = False
   Range("Costing!A1").Select
    
Unload Me
End Sub

All help is appreciated!
.

 

[Andrew Poulsom]

In what way doesn't it work? Is your CommandButton named CloseButton?

 

[MooseMoney]

The button to close the Userform is called "CloseButton".
When I click the "CloseButton" to close the Userform, the VBA error message as per image below appears.
When debugging, the code below is highlighted in yellow.

.

 

[Andrew Poulsom]

To select a Range its worksheet must be active. But there is no need to Select. Try:

Private Sub CloseButton_Click()
   With Worksheets("UserFormResults")
      .Range("C17").Copy .Range("C30")
      .Range("C30").Replace What:="  ", Replacement:="", LookAt:=xlPart, _
         SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
         ReplaceFormat:=False
   End With
   Application.CutCopyMode = False
   Unload Me
End Sub

 

[MooseMoney]

Excellent - it works like a charm!
You are one hell of a clever dude.
Thank you - you're my hero for today.