Date as a value to a textbox as a result from another textbox

[Melanie0129]

Hello,

Can anyone help me? On my combobox I put my status as (cleared, taken and valid). What I want is when I choose cleared and taken as a status the date today would be appeared to processed date and for valid status the date today would be appeared to initial request date. This is in userform bdw. What code to be used?

Thanks!

Mel

 

[Abraham Andres Luna]

The ComboBox has a SelectedItemChanged event. Create a handler that will catch this event and then test the ComboBox.SelectedText to see if it is either "Cleared" or "Taken" and then fill the "Initial Request Date" with the date you want.