event

  1. R

    Event codes with two conditions

    Hi, Can you please help me get an event code with two conditions to generate a message for two scenarios as follows? 1) I am trying to translate this formula into VBA: IF(AND($A1="Home",$B1="School"),"Invalid Combination","") I want the event code to check these conditions for rows 1 to 20. I...
  2. L

    conditional formatting

    Hi 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...
  3. L

    creating countdown timer in excel no vba

    Hi 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...
  4. W

    Form called by selecting record

    Pearson's form seems missing, or removed. I wrote one using Events. Thought I'd share. Here's the link: https://kvisit.com/OQ/neoB
  5. D

    Close Active window triggers before close event

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

    Inquiry

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

    Power Pivot or Power Query to show all claim lines for a customer with a specific event

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

    Combo box Change Event twice

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

    Quick stupid question about "Sub ComboBox1_Click()"

    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? I'm wondering...
  10. S

    Another Time comparison problem

    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". If F2 is "Event A" and G2 is 0:09:23 and F3 is "Event X" and G3 is 0:00:03 and F4 is "Event Y"...
  11. P

    Graphing swimmers' times over time

    Hi, I'm trying to create a graph that compares several swimmers time at different meets. The data is stored as follows: <tbody> Date Swimmer A Swimmer B Swimmer C 1/1/2018 01:53.55 01:50.51 6/5/2018 01:34.22 01:45.12 7/9/2018 01:30.10 01:35.12 </tbody> I know times must be...
  12. J

    Set range for Multiple change events on one sheet each referring to a different range of cells

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

    Pivot table; show values as percent and total as number

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

    Creating Userform Controls At Runtime

    Good morning 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...
  15. H

    Variable in Textbox 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 Thanks
  16. K

    Fire change event for ActiveX combobox

    Hi all, 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...
  17. H

    DatePicker 32 & 64-bit

    I've found a datepicker https://www.dropbox.com/s/at2peyyhttnbvnw/New%20Calendar%20Ver%204.xlsm?dl=0 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...
  18. J

    vba change event with cases copying a range and inserting at a named row stipulates rows used which may change

    Hello 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...
  19. J

    COUNTIFS Hours and minutes in range

    <tbody> Duration hours:mins Column A Type of interruption Column B Number of cust affected Column C Event day? Y/N Column D 13:39 Unplanned 13 N 43.27 Unplanned 20 N 6:00 Planned 80 N </tbody> Hi, The above table shows a sample of what I am doing. I'm trying to count...
  20. G

    Solution to Excel Problem

    Hi everyone, 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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top