Code Problem
Hi All,
I am creating a basic userform that enables a user to input currency
values in a cell.
Basically the form has buttons for the numbers 0-9 and also for
"." (decimal point)
I have got the following code for the decimal point, however when the
button is clicked, nothing happens.
Private Sub CommandButtonDP_Click()
ActiveCell.Value = ActiveCell.Value & "."
End Sub
On the number buttons I have got the same code, just with the relavent
number rather than "." and they work fine.
Could anybody please tell me why this is happening?
Many thanks,
Mark
|