Hi, Can you please help me get an event code with two conditions to generate a message for two scenarios as follows?
I am trying to translate this formula into VBA:
I want the event code to check these conditions for rows 1 to 20.
I have the table below. I want to use conditional formatting or any other way to highlight
the event based on condition like the following:
If the event takes less than 14 days, then I highlight "Current" in the 3rd column. but not to highlight the "xmas" or any other events which have...
I am trying to do similar countdown timer (please see the link below) but my problem, when I subtract the target hours from the start hours, the result is negative. The author did not say anything about that. How can I fix that. I also appreciate if you have better idea of doing that. Thank...
I have an excel workbook with 2 views open (View/New Window). When I close the second window (the workbook remains open) it triggers the before close event. Is there anyway of closing the second window with triggering the before close event? I only want the before close event to trigger whe the...
I have a bank of data that is updated monthly. I need to analyze said data to determine first all values above 35 then I need to look for two consecutive instances of this event. Once found, I would like to indicate for inspection if not ok
I have a spreadsheet with multiple claim lines per day for various events taking place per customer.
I am looking for either a Power Query or Power Pivot solution to show all claim lines for only dates where a particular event took place on one of the claim lines.
For example, if customer ID...
When I make a selection using the drop down arrow, the change event executes once. However, if I type 1 character, the change event execute twice. I step through the procedure and I can see the code only execute once until to the end of the procedure and then my cursor changes to a wait circle...
Since I'm not that well versed in VBA, unlike most on this forum, I was hoping someone could answer a quick question regarding "Sub ComboBox1_Click()".
I thought this was a mouse click event, but as I seem to be finding out, it is also a key click event.
Is this correct?
So I have thousands of rows of data every day. In column F I have an event code and in column G I have the duration of that event. I need to know if "Event B" occurs within 20 minutes of "Event A".
F2 is "Event A" and G2 is 0:09:23
F3 is "Event X" and G3 is 0:00:03
F4 is "Event Y"...
I'm trying to create a graph that compares several swimmers time at different meets. The data is stored as follows:
I know times must be...
1 change event worked on the worksheet until it got too large. I split the 1 event into two events. One titled “Private Sub Worksheet_Change1(ByVal Target As Range)” which I want to work for changes in range E38:H70
The 2nd event “Private Sub Worksheet_Change(ByVal Target As Range)” is for...
I have a pivot table with a list of different types of events in the first column (row labels), e.g. boiler repair, floor repair, window repair. The value columns are the days of the week, with the number of each type of event (repair jobs) occurring on each day. I would like to show the grand...
I am adding controls at runtime to a userform.
I have done this before and I cannot work out what I am doing differently this time.
I can add the controls alright and I can add the event handler code in the form module programatically. The form loads alright but the event...
I make a selection in a Userform.Listbox with data coming form the Textbox in a Userform
Can I pass a variable to the Textbox Sub ..._Change event
ie. Sub TextBx_Change(ByRef ....)
I don't want to use a Public variable
I have an issue with an ActiveX combobox.
In my workbook, an activeX combobox is created each time a cell is clicked. I would like to trigger an event so that when the value of the combobox change, it triggers an event that modify the adjacent one.
My problem is that, as you know, the...
I've found a datepicker
I tried to find the way to use the " DTINSERT"-knob to use the date in another Procedure
There is a timer event which gets activated in the launch code.
When you stop the code midway, the timer...
I am trying to write a change event which when the value in H6 is >0 the named range "GreenTemplate"(which is three rows deep) is copied and inserted below named range "insertRow" and then the inserted rows are named "GreenQ1".
Then if the value in H6 is cleared the named range is deleted...
Type of interruption
Number of cust affected
Event day? Y/N
The above table shows a sample of what I am doing.
I'm trying to count...
I am a novice Excel user and I'm trying to create a dynamic sheet for my company to use.
The gist is like this: I have 4 pieces of information. An event date, event name, location, and link to notes. I have these listed out in rows. What I want to do is be able to automatically...