Solved: UserForm find not finding dollar amounts

[simora]

How can I format my comboboxes so that they show the exact amount on the worksheet, and allow find to work correctly.
Find is NOT finding values ending in 0 even after I formatted the text and comboboxes using
ComboBox2.Text = Format(ComboBox2.Text, "#,###.##")

See attached 2003 excel sheet. Use the full search checkbox to test.
Any ideas?

Thanks

[Bob Phillips]

Change all of the "#,###.##" formats to "#,##0.00"

Why are you overlayying that textbox on the combobox, what purpose does that serve?

[simora]

xld: Distinguished Lord of VBAX:

Thanks.

That worked perfectly. The textbox was previously used on some other calculation functions and I wanted a common “ Collector”. Its still there because of testing etc.. etc..