Textbox format in a VBA userform

[VBAisthebest]

Hello guys,
Kindly help me with the code to format numerical data(like 1000,000.00) from calculated cells in my sheet to be entered into the textbox. I will be very grateful to get some assistance on this issue.
I have tried this below;
Private Sub TextBox1_Change()
TextBox1.Value = Format(TextBox1.Value, "#,###")
End Sub

and

Private Sub TextBox1_AfterUpdate()
TextBox1.Value = Format(TextBox1.Value, "0,000.00")
End Sub

But it returns an error message that VBA cant find project of library. What can i do ? Thanks

 

[Kuljack]

The first script should work appropriately for you, your error issue isn't related to this.

Try looking into the directions in these threads for resolution.

Compile Error: Can't find project or library

https://msdn.microsoft.com/en-us/library/office/gg251321.aspx