Why not use a combobox, with those values, and the user can select from
them. You can check on some type of form exit whether a selection has been
made

If ComboBox1.ListIndex < 0 Then
'do something
End If


--
HTH

Bob Phillips

"browie" wrote in message
...
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