counter

[Dannyj01]

Hi folks,

Just a quick on (I hope) is there an easy way on having a dropdown list with a submit button under it and then when the button is pressed it counts up on a table in another sheet after every press of the submit button. An example of what I mean is below.

Because I dont know how to paste what I have in to here a worded example is below.

Input sheet
B11 has a drop down in it with things like GMS3 GMS1 DMS
this has a submit button below it.

On a Triage sheet is a table with headers from A1 which is the date then B2 is GMS1, C2 is GMS3 and so on up to L2 which is total for the day.

So I would like whatever is submitted from the drop down be updated on the triage sheet.

Hope this makes sense, if someone could tell me how to paste how it looks in to here I will do that as obviously a visual is easier to understand than a worded explanation.

Thankyou in advance

Daniel

 

[Logit]

.
Paste this in the Sheet Level Module where the button is located :

Option Explicit


Private Sub CommandButton1_Click()
    Dim arr
    Dim clks As String
    Dim wr As Long  'write row
    
arr = Split(CommandButton1.Caption, vbLf)
clks = arr(UBound(arr))
CommandButton1.Caption = "Number of clicks is" & vbLf & clks + 1


With Sheets("Sheet2")
    wr = .Cells(Rows.Count, "A").End(xlUp).Row + 1
    .Cells(wr, "A").Value = clks + 1
    .Cells(wr, "B").Value = Now
End With


End Sub




Sub ResetClicks()
Sheet1.CommandButton1.Caption = "Number of clicks is" & vbLf & "0"
'to clear sheet2 uncomment next line
'Sheets("Sheet2").UsedRange.Offset(1).ClearContents
End Sub

Download workbook : https://www.amazon.com/clouddrive/share/DhRVsANsApfzn2Q83tnhJPYOemFbRLmc9qBZEe6QrZH

 

[Dannyj01]

Ok cool, I will give this a go when I get back home, will this code count whatever is selected in a table on a different page? The help is much appreciated

 

[Logit]

.
It tracks how many times the button is clicked. So, whatever macro you have attached to the button, it will count how many times the button was clicked to
activate that macro. The macro can be anything, it doesn't matter, as the code only tracks the times the button itself was clicked.

 

[Dannyj01]

Ahh ok, I will have to see if I can get it to work with the drop down categories, i basically need to it add 1 to a table for what ever is selected, so if I pick gms3 then I want it to add one to the tally for gms3 and so on for all 10 options

 

[Dannyj01]

https://1drv.ms/x/s!Agw2YRlutNJ5jURfnBQrZvWgRwnt

This is the basic setup, I have a button under the triage Dropbox on the updated version on the pc