• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

Looking for a way to add to an array

I've been working on trying to piece together an attendance sheet in excel and I'm stumped on this one.  I need to be able to have when the "Break Out" button is clicked for it to match the date and put "Break Out 1" and then if the command button is hit again to put "Break Out 2" and then shut the "Break Out" command button off. So looking for help on how I can add it to my excel.  I'm attaching a copy of the file for reference and would appreciate any help on this.  Thank you.
TestNewAttendance.xlsb
0
NYANBCNY32
Asked:
NYANBCNY32
  • 4
  • 2
1 Solution
 
Wilder1626Commented:
Hi

Is that what you are looking for?
TestNewAttendance-1-count-added.xlsb
0
 
Wilder1626Commented:
0
 
NYANBCNY32Author Commented:
Thank you for the help on this, one issue:
Private Sub Workbook_Open()

If (Range("W4").Value > "0" And Range("W4").Value > "") And Range("A11").Value = "" Then Sheets("Attendance").Range("W4").Value = "0"
End If

Cell "A11" will only be empty on one day, after that it will be filled. Is there a way around this so that it resets "W4" each new day it is opened?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Wilder1626Commented:
This should do exactly what you want to have.

Let me know if this is good.
TestNewAttendance-3-count-added.xlsb
0
 
NYANBCNY32Author Commented:
Actually, never thought of setting it that way, but that's exactly what I needed and it works perfect. Thank you for the help on this.
0
 
Wilder1626Commented:
I'm glad i was able to help.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now