All you need to do is either cycle through the textbox  controls with a "For
Next" loop or list them all individually and set the .Value property to
nothing

textboxcontrolname.Value = "" 'substitute the actual name of you control
for textboxcontrolname

You may want to set up a UserForm_Initialize event for you form  that will
clear all the textbox controls before the user sees the form. Then you may
find that an Ok and a Cancel button  are all you need and not a "Clear"
button.

Currently I've got it all as:

Private Sub cmdClear_Click()
firstname.Value = Null
surname.Value = Null
address.Value = Null
town.Value = Null
county.Value = Null
postcode.Value = Null
email.Value = Null
phone.Value = Null
End Sub


However, this clears only one box  when I press the clear  box, and then
the next one down when I click it again. I'm guessing I need some sort
of Loop, how do I implement it?

The code below is working fine by pressing commandbutton2 (say clear) with my
excel VBA programme. This may be useful to u. If it don't work, just tell me
again.

Private Sub CommandButton2_Click()
TextBox1.Value = ""
TextBox2.Value = ""
TextBox3.Value = ""
TextBox4.Value = ""
TextBox5.Value = ""
TextBox6.Value = ""
TextBox7.Value = ""
TextBox8.Value = ""
TextBox9.Value = ""
TextBox10.Value = ""
TextBox11.Value = ""
TextBox12.Value = ""
End Sub

I think it should work.

The below code works in word and I'm pretty sure it should work in
Excel too.
It goes through all the text  boxes regardless of name. You will need
to have the extenibility library referenced.

Otherwise you would have to name the text boxes and clear  each one
seperately

Public Sub subClearTextBoxes(frmpForm As Object)

Dim intlNumberOfControls As Integer
Dim ctlCurrent As Control
Dim strlControlType As String
Dim slFormName As String

intlNumberOfControls = frmpForm.Controls.count
For Each ctlCurrent In frmpForm.Controls
If TypeOf ctlCurrent Is MSForms.TextBox Then
ctlCurrent.Text = ""
End If
Next ctlCurrent
'
**********************************************************************
*
End Sub

If you unload the userform  I have found that it will clear  the values.

PersonalInfo.Hide 'hides the form  and maintains the values
Unload PersonalInfo 'unloads the form from memory and resets the form to
original values