View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KUMPFfrog KUMPFfrog is offline
external usenet poster
 
Posts: 38
Default Combobox selected value initiates action

My combo box (on a userform) has the following listed:
Processing,Rejected,Paying,Paid
I would like the selection of Paid to prompt for further action by poping up
a calendar control (Calendar2) for date selection.

Then, can you have a label where the caption will change from nothing to the
date selected? If yes, would the caption clear if the user changes their
selection to something other than paid?