How do I add numbers into a single cell and have them continually.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on survey results and want to have a single cell continually add
one to the number in the cell. Any Suggestions?
 
Under what criteria ?
You can use an Double Click Event macro to add on to a cell, a row
or however you want to define a range or limitation.

More information in
http://www.mvps.org/dmcritchie/excel/event.htm

Install the following by right click on the sheet tab then
view code, and insert the following:

Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
Cancel = True 'Get out of edit mode
If Target.Column <> 2 Then Exit Sub
If Target.Row = 1 Then Exit Sub 'ignore descriptive titles
If IsNumeric(ActiveCell) Then
ActiveCell.Value = ActiveCell.Value + 1
End If
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Continuous Invoice Nos. 3
how to continue writing in a single cell? 3
Excel How to add numbers in same cell? 2
How to separate contents of one cell into multiple horizontal cell 1
Appending Text To Numbers ? 1
Return multiple vales from a different spreadsheet into one cell 10
About Find & Replace... 1
record dozens and singles in same cell and sum them? 1

Back
Top