changing size of characters in a selectionbox and date in atextbox
hi bartman1980
1. What do you mean by selectionbox?
If you mean Combobox, rightclick on the box -- properties.
There you will find your font, click in the field and then on the
"..." on the left side.
2. you could check it like that:
Private Sub TextBox1_BeforeUpdate(ByVal Cancel As
MSForms.ReturnBoolean)
If Not IsDate(Me.TextBox1.Value) And Me.TextBox1.Value < "" Then
MsgBox "Please insert a date"
Cancel = True
End If
End Sub
hope that helps
Carlo
On Dec 18, 4:49 pm, bartman1980 wrote:
Some simple questions:
1. How can I change the size of the characters in a selectionbox?
2. How can I force somebody to fill in a date in a textbox? I can do
it with a cell but I couldn't manage it with a textbox. (If possible
without the calander.xla because I tried but I never found out how to
do this exactly)
|