KyleOliver
New Member
- Joined
- Apr 16, 2016
- Messages
- 31
Re: Currency value on a lable in a userform
Hi,
I have a user form called "
The
What am I missing?


Hi,
I have a user form called "
Data_UF
" and when I call the user form up it will reflect all employee details on the employee data worksheet.The
"
Cell "
<strike></strike>Data_UF
" user form has textboxes, combo boxes and labels. Cell "
T9
" has the employee's salary as its value. Cell "T9"
is formatted to Currency but when I call the "Find_Entry_UF" user form the label called, "LblBasicWage" reflects the employee's salary but not in the currency that cell
Example;
Cell
How can I reflects cell
</strike>
"T9"
is formatted in.Example;
Cell
"T9"
has a value of R10 000 but in label "LblBasicWage"
it reflects as 10000.How can I reflects cell
"T9"
as a currency on my user form in label "LblBasicWage"?
My code is as follows'
Data_UF.LblBasicWage = Sheets("Data").Range("Data_Start").Offset(TargetRow, 18).Value
This code reflects the value as 10000 but not with the currency.
<strike>My code is as follows'
Data_UF.LblBasicWage = Sheets("Data").Range("Data_Start").Offset(TargetRow, 18).Value
This code reflects the value as 10000 but not with the currency.
</strike>
Data_UF.LblBasicWage.Value = Sheets("Data").Range("Data_Start").Offset(TargetRow, 18).Value, "R#,###,###.00")
This code keeps giving me an error.What am I missing?

