VBA code

[karimretina]

Hello everybody,

I have a list of positive and negative numbers with 2 digits decimal in a sheet. the problem that the control form combo box linked to these cells does not display the + and - signs and the 2 digits decimal.
I tried this code under "comboboxChange" but it did not work

cmbLensPower.text = format (cmbLensPower, ("+/- 00.00") 
[ /[/FONT][/COLOR][COLOR=#000000][FONT=Calibri]code]

Thank you in advance[/FONT][/COLOR]

 

[Tetra201]

Try this format expression: "+00.00;-00.00"

 

[karimretina]

Thank youTetra201,

unfortunately it did not work

 

[tygrrboi]

dont you need .Text for the second call to cmbLensPower?

 

[BQardi]

I would guess that you also need to declare variable cmbLensPower as Double or Currency (or Variant)