Thread: Code Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MarkHear1 MarkHear1 is offline
external usenet poster
 
Posts: 20
Default 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