Selecting contents of textbox in VBA UserForm

Although Microsoft provide an auto-select feature for text boxes in User Forms (used for custom user interfaces in Microsoft Office applications), it only works if the user TAB's into a text box and not if they click with the mouse (which, of course, is more common).

To get round this, you can trap the MouseUp event for each text box object like this...

'***
'* Auto select all text and copy text to clipboard
'* @param tb OBJECT The user form object to operate on
'* @return NULL
'***
Private Sub selectTb(tb As Object)
    With tb
        .SelStart = 0
        .SelLength = Len(tb)
        .Copy
    End With
End Sub

' Select and copy to clipboard any of the fields as they are clicked in
Private Sub tbRole_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    selectTb Me.tbRole
End Sub
' ... Repeat for each text box object ...

Add this code to your Form in VBA with a MouseUp function for each text box object you want it to operate on.