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


Joined
Feb 11, 2018
Messages
1
Reaction score
0
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
 
Ad

Advertisements

Joined
Mar 14, 2018
Messages
617
Reaction score
200
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top