Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a short validation routine and makes sure input into a text box is a number. It works fine except, part of the code checks to see if a second decimal (period) was entered. If the test is true it will delete the second period. The code that does that is below: TestNumberLength = Len(TestNumber) - 1 If TestNumberLength < 0 Then TestNumberLength = 0 tb1.Value = Left(TestNumber, TestNumberLength) How do I get the displayed value in tb1 to show the new value. Presently it only changes when I make the next entry into the box. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date format to Text Date for use in Mail Merge | Excel Discussion (Misc queries) | |||
Formula concatenating date & text converts date to number | Excel Programming | |||
how do i convert text to date (mm/yy text to mm/dd/yyyy date)? | Excel Discussion (Misc queries) | |||
VBA convert day and date from text string to Excel date | Excel Programming | |||
Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) |