events

Hello, where would i put a macro to sort column A automatically when i select a sheet? so, if i am on sheet 1 and switch to sheet 3 i want whatever is in column A of sheet 3 to sort itself alphabetically, without me having to click anything. would it be a workbook change event? or is it a...

The user of a worksheet wants a certain functionality. If the user clicks a cell the font for the cell should be changed to bold. But if the user double clicks a cell he/she wants the fill color to change to red and does not want to change the font. I don't see how this can be done. Because...

I have a challenge to overcome, but couldn't find any hint yet and hope you guys can help. I need to create shapes (e.g. msoShapeRectangle) with specific texts in them in a worksheet. Once created, I want to allow users to move the shapes on the worksheet, but I want to prevent them, editing the...

Hi, I’m creating a dashboard in excel with a number of different charts. I wanted to add some text boxes at the bottom of each chart to explain what the chart is about but don’t want the text boxes to be visible all the time since it would clutter the dashboard. I created a label and assigned...

Workbook can be downloaded here. Scenario: 10 people are using a shared workbook. There are 10 tabs, of which 9 are considered Biller tabs & 1 is the Master tab. The Master tab is just the aggregate of all the Biller tabs, minus the extra header rows. All tabs are using a giant table for all...

I found the following class file and have edited it to run certain procedures after a background refresh of a QueryTable has completed. The class events work properly if the QueryTable supplied isn't contained within a ListObject (ie: created via VBA) but fail to trigger if they are. I've tried...

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

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

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

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

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

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

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

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

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

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

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

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

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

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