formatting a cell just changes the way that the cell's content appears...it
doesn't alter the content itself.

so for a date, the cell's value might appear to be 12/3/2008 but it's actual
value is 39519
when loaded to a combo box, the actual value is loaded.

what you may need to do is use the form's load procedure to load the values
rather than use the rowsource property...see the following example where i
have a table of dates range named 'MyData'

The following is the code behind the form:

Option Explicit
Private Sub UserForm_Initialize()
LoadComboDates
End Sub
Sub LoadComboDates()
Dim cell As Range
For Each cell In Range("MyData")
ComboBox1.AddItem Format(cell.Value, "dd-mmm-yy")
Next
End Sub





"jay dean" wrote in message
...
Hello -

I have implemented a combobox on a form and it works great. It loads its
items from "SheetB". On "SheetB", I have formatted some of the items the
way I want but they lose that format after loading into the combobox.

What code do I use to keep the format as is when it is loaded into the
combobox?

OR, what code do I use to change the color, size, and font of some
"SPECIFIC" items (not all) in a combobox?

Any help would be appreciated.

Thanks
Jay


*** Sent via Developersdex http://www.developersdex.com ***