Thread: How can I click on a cell and enter a default value?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default How can I click on a cell and enter a default value?
Try using

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$E$2" Then Target = 234
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pawlingJohn" wrote in message
...
I would like to be able to click on a cell and have a value automatically
entered. I would like this to work like a forms control checkbox. Or is
my
only answer use the control checkbox?

Reply With QuoteReply With Quote