Rounding Figures Using VBA

[Gavin Harrison]

Hi All.

I am putting together a pop up userform in VBA and within a label i want to display a value of a call in the worksheet.

The cell i am looking up is formatted to 1 decimal place, but then i run the code, it is not.

This is the line of code, is there an easy way to amend this code so that the figure is formatted to 1 decimal place when displayed in the userform?

TimesExportedPopUp.Label5.Caption = Worksheets("Calculations").Range("BD65")

Thanks for your help in advance.

 

[Bosquedeguate]

TimesExportedPopUp.Label5.Caption = Format(Worksheets("Calculations").Range("BD65"), "0.0")

 

[Gavin Harrison]

Thank you

 

[Joe4]

What exactly is found in cell BD65?
Are you sure that the value in cell BD65 is numeric, and not "numbers entered as text"?