event

I have multiple worksheet event macros on my sheet. When selection Y/N is unlocks or locks respectively and a message box appears based on the selection. For some reason my macros 3-6 repeat the previous message boxes starting with the message box in the 2nd macro. The first and second macros...

Hello, I'm having a code structure issue, so the code below is just representative of the problem. I have several sheets which I would like to have a SelectionChange Event trigger some code to run. There is one routine that I have that needs to run regardless of which SelectionChange event...

Private Sub cmdPrimary_Click() txtPrimary.text = GetFolder("Select the Primary Folder") End Sub Private Sub txtPrimary_AfterUpdate() Stop End Sub The GetFolder function returns a value which txtPrimary displays. It isn't assigned a value until then but the After Update event doesn't fire...

The event is triggered just fine when the worksheet is not protected. When I protect it, however, this event is no longer being triggered. Nothing else has changed. Is this how Excel is supposed to work? Not sure if I'm missing something here...

Hello all This is a bit of a strange request I update a report with an add on tool in Excel called "XRL" When the report is updated "XRL" has switched the calculations function off. I thought of trying a worksheet event change to switch the calculations back on but this is not working unless...

I have a basic worksheet change event, where on the one worksheet, cell changes values (case is), rows are hidden, or unhidden. I'm not fluent/skilled enough, is there a way that when there is a change to a value in a cell in sheet1 (let's say "Show me" and "Where did it go"), that it triggers...

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

Good evening Everyone!! I am confident that someone in this forum will be able to assist me with my dilemma. I am the payroll processor at a Golf Club management Company where we host several event functions in different venues on property. There will be times that we have 2 or 3 functions...

I have a table of dates (column B) associated with event Identifiers (Column A) and need a formula in column C that will find the first date for each event as shown in the table below. I've been playing with Index-Match and know that if the row is the min of all the rows where the event is the...

Hello I am trying to create a PT that would show some event registration summary. My data consists of different event types users have registered for over various years, what I would like to be able to filter a specific year and event type and pivot what other events the users have registered...

File:- https://www.dropbox.com/l/scl/AADY9YPtJ_u41XmixEbGP3-z9vS8-yaN8PQ 1. this file have 6 sheets 2. 1-4 sheet are block name and thier particulars.(Here required Bib No separate sequence for each block. ) each block...

Hello, I'm using Excel now for a long time for the company I work for and of recently i started to experiment with macro's to do the tedious work of copying and pasting the first 10 rows of my sheet whenever I run out of space on my first printable area I would really like to have an automated...

I'm using the code below to fill a textbox with a number and triggers a change event once filled. However, if the number is the same on the next row, it does not trigger the change event. How can I trigger the change event if the number is the same? tbOQty = Range("F" & ActiveCell.Row)

Hey all, I have a userform where my co-workers input some data from events. The button for the userform is on sheet1 and the sheet the data is put in is sheet2. They input data first before the event and then they need to input data after the event (data before event is rows 1:10, and after...

Hi, I have 3 columns... EVENT-SCORE-AVG of Top 4 I need a formula for COL C that will put the average of the TOP 4 ranked (COL B) for each EVENT in COL A Thanks Event Score Avg Of Top 4 1 131 129.00 1 129 129.00 1 129 129.00 1 127 129.00 1 126 129.00 1 124 129.00 1 124 129.00 1 123 129.00 1 0...

I've writtenamacro in my whose purpose is to ask me, when I try to close thefile, whetheror not all tasks have been completed within that specificfile. Rather than addthis to the numerous excel files I get into each day, I'dlike to add it to mypersonal workbook. The problem I’m having is that...

I have the following code as an On Format event for the detail section of a report. If Me.txtReferralReturnedDate = Null Then Me.txtReferralDueDate.Visible = True Else Me.txtReferralDueDate.Visible = False End If The report returns multiple records, making the txtReferralDueDate field...

I am using the Get.Cell Excel 4 macro function to show the actually number format being displayed in a cell (Get.Cell(7,A1)). I would like the Get.cell Cell to update automatically when I change the cell format. The only way it updates now is if I enter the data in the source or I click and do...

Hello, We recently switched to a shiny new database at my work, and I am trying to develop a report that will show me data discrepancies between the entries in both databases. We've been having our employees enter all data into both systems so that we have all of 2018's data in the old system...

I have 2 option buttons in a frame on a user form. When one of them is clicked (changes), I want to trigger code that makes the visible property of a textbox (which is not in the frame) false, that is, hide the text box. I want to do this without having to click a command button first, through...