fiza
04-02-2010, 03:26 AM
Hi Anyone,
I'm using the following code to get the value as g/dl in my userform. I want the number to appear 1.0g/dl after I press the tab button. Suppose I write 2 in the txtbox, I want the number to be 2.0g/dl and if I write 2.1 it to be 2.1g/dl and so on.
Private Sub txtweight_AfterUpdate()
If IsNumeric(txttxtweight.Value) Then
txtRecipientHaemoglobin.Value = txtweight.Value + " g/dl"
End If
End Sub
Any help would be kindly appreciated.
Regards
Fiza
I'm using the following code to get the value as g/dl in my userform. I want the number to appear 1.0g/dl after I press the tab button. Suppose I write 2 in the txtbox, I want the number to be 2.0g/dl and if I write 2.1 it to be 2.1g/dl and so on.
Private Sub txtweight_AfterUpdate()
If IsNumeric(txttxtweight.Value) Then
txtRecipientHaemoglobin.Value = txtweight.Value + " g/dl"
End If
End Sub
Any help would be kindly appreciated.
Regards
Fiza