ComboBox and Date

[yakult014]

I wondering how can i formulate this textbox status to display textboxStatus to blank when combo box is closed and when combobox1 is in "Open" then TextBoxDate.Value - DateNow.

if ComboBox1 = "Open" then
TextBoxStatus = txtBoxDate.Value - DateNow

Else if

ComboBox1 = "Closed" then

TextBoxStatus = " "

end if

 

[Leandroarb]

Hi, do use the events Enter and Exit from the combobox1.

Private Sub ComboBox1_Enter()  
    TextBoxStatus = txtBoxDate.Value - DateNow
End Sub

Private Sub ComboBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    TextBoxStatus = " "
End Sub