I have a combo box with an input range of numbers formatted as %. I figured
out how to format the box as % to the 3rd decimal.

ComboBox3.Value = Format(ComboBox3.Value, "0.000%")
(seems to work - if its wrong please let me know)

My issue is the cell that this is linked to it doesnt format as a % until
the next time the sheet recalculates (i.e. - enter a formula or do some other
calculation in the sheet). Meaning the box show 6.000% the cell A1 which
its linked to show .06 until the sheet calcs then it switches to 6.000%. Any
idea why this is happening and how to correct ?
Thanks,
Yosef