Dependent textboxes

[Peter Thompson]

Hello,

Im sure there is an easy way to do this, but not being expert on user forms im not sure what it is.

Basically, I have three textboxes - Deadline, Completion Date and Completed by Deadline. The first two can be set by the user either typing in a date or clicking on a button and selecting from a calender. I want the third button to automtically calculate when the Completion Date is populated, but am not sure how to trigger this.

Thanks,

Peter

 

[SteveO59L]

What do you want to populate it with?

 

[Peter Thompson]

I want it to check whether the completion date is before the deadline and enter "Yes" if it is and "No" if it isn't. The logic for the if statement is simple enough I just don't know how to get it to trigger.

 

[SteveO59L]

in your completion date text box

Private Sub TextBox2_Change()
If TextBox2.Value > TextBox1.Value Then
TextBox3.Value = "No"
End If
End Sub

 

[SteveO59L]

alternatively, you could do the calc in a cell on your sheet and link to it

 

[Peter Thompson]

Steve,

Thanks for your help. Your first suggestion was exactly what I was looking for.

Peter