events

  1. C

    Inserting text from another tab

    Good Morning, I have an events spreadsheet and would like to do the following. The tab with the information is called Events Notices as follows: <tbody> SUBJECT LINE FULL NOTICE 50's Sock Hop Toss on your bobbi socks & poodle skirts then head down to where DJ (this needs to pick up the...
  2. M

    What Is A Real World Use Of Creating An Event In a Custom Class?

    Hi, I've been coding in VBA with Excel's built-in events for the Workbook and Worksheet and their usefulness is very obvious. However, with custom classes in VBA you can also create your own events -- and raise them -- to other objects that are listening for those events. What's unclear to me...
  3. L

    Excel Send As Attachment Menu Option

    I have some code that I have put in Workbook_AfterSave and Workbook_BeforeSave. It works great and does exactly what I want; however, during testing, I found an odd situation where Excel doesn't call these two functions when saving a document (maybe Excel is disabling events on its own here)...
  4. C

    Date data validation formula

    I have a basic spreadsheet where staff enter details of events they're planning, it's in a set format so the date of event goes in a specific row. Even with only 4 events per month there's an issue with people not checking and trying to schedule them too close together. I've been asked to...
  5. H

    Count no of Message boxes displayed.

    How can I count the number of msgbox appeared between two events. The events probably are: 1. Opening userform 2. Clicking the submit button
  6. Richard U

    VBA to open a workbook without triggering open event?

    With office 365 on the horizon, I need to catalogue all of our spreadsheets, and identify links. I am doing this by creating a workbook object, setting the object to" Set wb = Workbooks.Open(path & file) var_Links = wb.LinkSources(xlExcelLinks) 'set variant = excel links This works great...
  7. B

    Counting events

    I would like help with the following ... Let's say events occur regularly, say every 90 minutes, starting at midnight. Given two timestamps, I want to calculate how many times the event occurred from time 1 to time 2. Some examples: 00:05 - 01:25 (1 hr 20 min): The event did not occur at all...
  8. D

    User form Cancel button not working when focus in a textbox that fails validation

    I have a UserForm with a number of textbooks plus OK and CANCEL buttons. One Textbox (for Age) gets validated in the Age_Exit Sub. If no age is entered, or if too high, then a MsgBox is displayed showing the error, Cancel is set True and the sub exited. This returns focus to the Age TextBox for...
  9. R

    Count difference between events

    Hi guys, I am looking for a query that allows me to count how many events occurred between each "x" event. The desired output is illustrated in the picture hereby attached. For instance, the second event is "x" and I would like to have as output 2. In the case of the third one is still "x", but...
  10. C

    Recurring Events on Excel Calendar

    I was wondering what the easiest way to set up a recurring event on an excel calendar would be? For example I have one month on each tab. On every 2nd Saturday, I want the calendar to say Board Meeting and the cell to be filled with a purple color to stand out. Can someone help with this? And I...
  11. A

    Check if file is password protected

    Hi everyone! I'm looking for a way to check if an Excel file is password protected. If so, VBA should open it with the "default" office password. This should happen anytime a file is opened by any means (i.e. from Windows Explorer, and not just through another piece of code in another Excel) I...
  12. M

    Calculate events for current month in real time based on conditions

    Hi There!! I've been wracking my brain and I can't seem to get it to work. Basically I'm trying to create a tracker that will display how many different events per region are happening in the current month (month when the file is opened by others). Each cell will target a different region and...
  13. M

    Filtering Challenge

    <tbody> Business Unit Cluster Country Category Subcategory Segment Market Sector SubSector Brand Productnumber Sales Turnover Cost Profit Turnover per piece Cost per piece Profit per piece Europe UK & Ireland Ireland Fastfood & Drinks Refreshments Burgers Events Festivals Outdoor OYT 123...
  14. J

    Allocate choices to respondents

    Hi, I've got a dataset of respondents in the format of: Respondent 1 - Choice 1 - Choice 2 - Choice 3 etc. Respondent 2 - Choice 1 - Choice 2 - Choice 3 etc. [for 100s of respondents] I am trying to allocate choices so that each respondent gets as many of their choices as possible The issue...
  15. N

    Counting Maximum number of occurences in a range that don't repeat

    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...
  16. H

    Count rows based on 2 dates

    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...
  17. A

    Enable Events

    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 ?
  18. J

    User Defined Type Not Defined

    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...
  19. P

    Is there a way to keep the current total when resetting/deleting cells?

    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...
  20. U

    Get Minimum Time Where Criteria May Be In Two Different Columns

    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...

Some videos you may like

This Week's Hot Topics

Top