firstible:

if TextBox5.value = "m" then...


secondly - here is a sample code that helps to determine blank value of any
textbox on a form

Dim oCtl As MSForms.Control

For Each oCtl In name_of_form.Controls
If TypeName(oCtl) = "TextBox" Then

if oCtl.Value = "" then
msgbox (oCtl.name & " has no value!")
end if
End If
Next oCtl



I am wanting to have the values m or f to be inputted into textbox5. Iam
not sure of how to do this I have put a little code as I think will work
but
I would also like to have a messagebox appear if any textbox is left
blank
that they must have a value.



If Val(TextBox5.Text) = "m"

Thanks