Gavin Harrison
New Member
- Joined
- May 2, 2017
- Messages
- 34
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.
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.