events

Hi, I'm trying to calculate a tourism streak for attending different running events. So I have a list of events and I want to work out the maximum number of times someone has gone without repeating themselves. So in the example below the longest streak without repeating is 8, between the two...

I have a table that contain a start date & time in column B and an end date and time in column C of different events, I need a formula to count how many rows fall within a certain time. For example below: I need to work out how many rows fall under a specific time being 13:00 each day, I can...

In Userform Activate two combo box values are set, but I don't want their change events to fire. So I put Application.Enable Events = False before setting the combo box text value. But the change event runs regardless. Isn't Enable Events = False meant to prevent that ?

New to Access programming. Just created a form and wired events to it but every time I bring the form up on either the control or an event like Form_Load, I get a "User Defined Type Not Defined" error. I wired the control events through the property sheet and used the Code Builder option. I'm...

So i have a formula for counting even that have occurred at certain sites. Like different job sites doing different events and a simple one that basically says Job site 1 did this Job site 2 did that we delete everything older then 2 months as the year progresses, just to keep file sizes...

Hi, Using Office 365. I am trying to determine the minimum time an event occurred in the Work Breakdown Structure (WBS) The problem seem to be that the the event may exist in either Col V or Col W as the event updates from Old to New Value, some events may repeat. Any other thoughts how I can...

Hello, I am trying to come up with a formula that i can drag to sum just the weekdays from the data set up below: <tbody> Weekdays 2019 Rooms Revenue Casino Formula Formula Events Formula Formula </tbody> Data looks like this: <tbody> Casino Casino Events Events 2019 2019...

Greetings, When running the code below in a new workbook, with Sheet1 activated and with application.enableevents=True, the PasteSpecial line causes the Sheet1 and Sheet2 Worksheet_Activate codes to run (as well as their respective Worksheet_Deactivate events. Moreover, when the pastespecial...

Hi, So, the problem I'm having is that some code I am writing calls another macro. This second macro has a userform with fields that must be completed before it will continue. Is there any way I can have code in the first macro that will enter data into the userform from the second? The main...

Hi everyone, is there a way to add comments based on dates? I have a file with three sheets. The first is called "2018" and is used as a calendar for year 2018 and other data. The second is called "2019" and is used as a calendar for year 2019 and other data. The last one is called "'Events" and...

I’m trying to create a excel calendar that keeps track of events based on a few standardized data types for entry. Wondering if anyone has any templates or can point me to some resource that can help. Nothing complex. All I am trying to do is to create an excel file with two tabs. Tab 1...

Hello, I have a data set with over 60,000 lines of data per year. It contains the date and time an object was placed in a specific container and for how long it was in the container. The more objects that were simultaneously together in the container the greater the weight and loading on the...

I have a workbook that I use for every client file I touch. For some reason, the enable events keeps getting turned off somehow. I figured I probably have application.enableevents=false at the beginning of a macro somewhere in the workbook, and then don't have =true at the end of that snip of...

I want to count the number of events are taking place on each day over a 2+ year period. We have the start and end date for each event and there are almost 2000 events. In essence, I think the criteria range essentially becomes in this case A2:B5, and we're looking counting the number of times a...

Hi, I'm sure some of you have come across this. If for example I have a worksheet.change event that writes values to cells. Then for any reason I get a debug error in VBA. The worksheet events stop working until you close/reopen the workbook (well the only way I know of) Anything I'm missing...

Hi, I have an xlsm document that that is accessed via sharepoint by around 300 people at the same time. It has some simple vlookups, if statement's and vb code. They use office 10 and 16 and I have checked the compatibility of the document. There is not a specific action causing the...

Scenario: I have a workbook with two sheets (calendar, Events). On the Events sheet I have 4 columns; Date(A), Time(B) , Description(C), and Location(D). Now on my Calendar page I want to display the Events that correspond to Today(). My Index/match finds and displays the first match, But How...

Hi all, I am wondering if something is possible at all. I have a calendar on Excel (month-by-month) and then another sheet with all the dates of all the different events that are happening. I want to be able to click on a date in the calendar and then below, a list of the events that are...

Hello and thanks for reading, I have a list of dates in Column A, and want to analyze them between a start date and an end date (inclusive, encoded in two cells elsewhere, user-entered); within the list, some dates are duplicated by design to represent multiple occurrences of a given event...

Greetings from Mumbai/India. I have a question on custom events. While the native events in Excel (eg worksheet change, worksheet open, workbook before save, etc) are intuitive and lend themselves fairly well to where and how to apply them, I continue to be puzzled about custom events. To be...