True/False not workin correctly

[obiwann]

I am having a problem with a combobox on a worksheet when I select the number 0.10 and it is reflected in cell A1. Cell A3 should show TRUE because cell B1 is greater than A1. What am I doing wrong? I have cell A1 formatted as a number with 2 decimal places and use of the following code :

Private Sub Workbook_Open()
With Worksheets("Sheet1").OLEObjects("ComboBox1").Object
.Clear
.AddItem "0.10"
.AddItem "0.20"
.AddItem "0.50"
.ListIndex = 0 'optional
End With
End Sub

 

[jproffer]

That code has nothing to do with greater than/less than/true/false.

What formula are you using to determine your True/False in A3?

Also, it could be **shrug** that entering data into cells via a combobox doesn't trigger a calculation so maybe using a line of code such as:

Application.Calculate

wherever relevant might do the trick.

 

[StephenCrump]

A combobox contains text values not numbers, and in Excel =9999>"0.10", for example, will return FALSE.

Try formatting A1 as numeric, removing it as the linked cell and using:

Private Sub ComboBox1_Change()

    Range("A1").Value = ComboBox1.Value

End Sub