View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
Posts: 210
Default Interactive Text message

I would like to build a dialog box for an value field that asks the user if
he is sure he added all of the payments between two dates.
A1: PolDate (Policy Aniversary Date)
A2: ValDate (Policy Valuation Date)
A3: Premiums paid between A1;A2
The user keys in 1/1/2007, 4/1/2007, 10,000, respectively. Upon pressing
enter on A3, a msg dialog box pops up asking, "did you include ALL payments
between 1/1/2007 and 4/1/2007?" if Yes, endsub, if no, return to A3 How do I
get the msg to read PolDate and Valdate?