View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default Syntax To Insert A Number Into One TrxtBox If A Different TextBox Has A Date That Is = 1/1/98

Greetings,

In an Exit event I need to see if the date value in TextBox1 is =
9/15/1998. If yes, then the value in TextBox 7 needs to be .0825. If
not, the value in TextBox7 needs to be.08.
I tried this:

If TextBox1.Value = "9/15/1998" Then
TextBox7.Value = "8.25%"
Else:
TextBox7.Value = "8%"
End If

But it only returns .0825 in TextBos7, no matter what the date is in
TextBox1.

What am I doing wrong?

Can anyone help me?

TIA

-Minitman