View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
carlo carlo is offline
external usenet poster
 
Posts: 367
Default 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)