Need help with VBS in excel creating a User-form?

k1922hss asked: I’ve created a User-form in excel and I need help in the coding part of it.
Currently I have coded the User form, as shown below:
Option Explicit
Private Sub cmdAdd_Click()
Dim ws As Worksheet
Set ws = Worksheets(”Invoice”)
‘check for a company name
If Trim(Me.txtCompany.Value) = “” Then
MsgBox “Please enter a Company Name”
Exit Sub
End If
‘copy [...]