| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Textbox value insert in two cells | Excel Discussion (Misc queries) | |||
| Syntax for selecting a textbox within a chart? | Charts and Charting in Excel | |||
| Insert spreadsheet in Excel textbox or comment box | Excel Discussion (Misc queries) | |||
| Insert more than 1 Row Syntax | Excel Worksheet Functions | |||
| Help with Syntax UserForm TextBox | Excel Programming | |||
![Minitman[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
