PDA

View Full Version : Userform textbox and calendar formula



jmaocubo
03-04-2010, 01:34 PM
Hello
I need your help ....

I have 2 calendar and a textbox in a userform, I need that when I put a number in the textbox, on the second calendar is + 1 / 3 (days) of the first calendar.

I used this code, but only allows me to move the number of days of the textbox.
Private Sub Calendar1_Click()

With Calendar1
Calendar5.Value = Calendar1.Value + TextBox1.Value
End With

Thanks in advance

Bob Phillips
03-04-2010, 01:46 PM
Private Sub Calendar1_Click()

With Calendar1
Calendar5.Value = Calendar1.Value + (TextBox1.Value \ 3)
End With

jmaocubo
03-04-2010, 01:52 PM
thanks :)

was doing well and missed () between textbox