Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the worksheet_change event (EXCEL 97) to make
sure that the user types in numbers to no more than the hundredths decimal place. If they type in a number like: 4.57 - entry is OK 4.572 - entry is bad If the entry is bad I change the font to bold. The code is as follows: Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If Int(.Value * 100) < .Value * 100 Then .Font.Bold = True Else .Font.Bold = False End If End With End Sub The code appears to work for most cases, but for certain numbers like 2.32 and 4.56 it turns the values bold (even though it should not). I am going NUTZ. Help would be much appreciated... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculation problem | Excel Worksheet Functions | |||
Calculation Problem | Excel Discussion (Misc queries) | |||
calculation problem | Excel Discussion (Misc queries) | |||
Calculation Problem | Excel Discussion (Misc queries) | |||
Calculation Problem | Excel Discussion (Misc queries) |