event

Hopefully others have encountered this situation. There's a lot I need to wrap my head around in DAX and the order that calculations happen is one of them. I'm not sure whether the following measure is doing what I think it's doing without having to create multiple intermediate helper columns...

Hey all, I have a worksheet event code Private Sub Worksheet_SelectionChange(ByVal Target As Range) which works great. Well, I want to bypass or stop using it if a specific key is being held down. In this case the arrow keys. Reason being the arrow keys are used for scrolling through the...

Hi everyone this is Mike. I am using Excel 2010 and have a active x combo box that is looping the _Change event every time a cell is changed in the spreadsheet - in this case spreadsheet5. Spreadsheet4 has a combo box also but not active x (this one is firing the Worksheet_Change event) and it...

Hi, So, the problem I'm having is that some code I am writing calls another macro. This second macro has a userform with fields that must be completed before it will continue. Is there any way I can have code in the first macro that will enter data into the userform from the second? The main...

Hi, I want to use a select case for the value of a combobox but I don't want to use the combobox change event? Ex. If combobox1.ListIndex = 1 I want a macro to run, and if combobox1.listindex = 2 I want another macro to run?

Hi everyone, is there a way to add comments based on dates? I have a file with three sheets. The first is called "2018" and is used as a calendar for year 2018 and other data. The second is called "2019" and is used as a calendar for year 2019 and other data. The last one is called "'Events" and...

The BeforeDoubleClick event syntax is as follows: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) End Sub I assume the Cancel argument is passed ByRef, so there's no need to write: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, ByRef...

I’m trying to create a excel calendar that keeps track of events based on a few standardized data types for entry. Wondering if anyone has any templates or can point me to some resource that can help. Nothing complex. All I am trying to do is to create an excel file with two tabs. Tab 1...

I've tried looking for Asc 13 in both KeyUp and Keypress events but it is ignored. This isn't how it should be is it? Doesn't show in the Exit event either. How an you tell if a user has pressed Enter, or instead has clicked away from the text box?

Dear Mr.Excel, Happy Holidays; In my Add-In I monitor the SheetActivate event, and create an OLE control by calling active sheet's .OLEObjects.Add() method. When the sheet de-activates its SheetDeactivate event is fired and I need to delete the control by calling its .Delete() member. Excel is...

Hey guys. I have a workbook that our users register client details, and create quotations with. We are working to a more productive way of our users working, by offering them a 'fewer clicks' solution to their daily needs of the workbook, and I would like to be able to have the users click a...

Hi all, I have a month-by-month calendar in an excel spreadsheet, that currently fills the cell with the event title (based of a table of event data). What I really want to achieve is that when the user clicks on the cell, a window/textbox will appear with more details of that event in. I...

Hello, I would assume this would be a simple enough question that I wouldn't have to start a new thread. However, I have searched far and wide for an answer and have come up with nothing. So I am trying to figure out the proper function of the "Workbook_BeforeClose" event. My understanding is...

Hi I use the following event macro to trigger another macro Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Intersect(Target, Range("I:I")) Is Nothing Then If Target.Value <> "" Then eventcopy End If End If End Sub Is there a way to only have it work only once each time...

Hi, I hope I can explain myself properly to get some assistance here. The below data is on my first tab in excel, and I am trying to gain a understanding of how much Actual Revenue a specific marketing event brought in. <tbody> Marketing Event # of Contact Customer Name Cost...

I'm using 3 refedit controls in a form and for some reason I can't figure out how to get it to trigger an event when the value of the control is changed. What I'd like to do is make it trigger an event so that when someone clicks onto the worksheet to change the range, it would cause the focus...

I'm trying to read incoming SMS RThreshold value is set to 1 The Meassage Storage Area is "SM" However, OnComm event is fired only when I send a command (e.g MSComm1.Output = "AT" & vcCrLf).. OnComm is fired when "OK" is returned Why OnComm event is not fired when an incoming SMS is...

Hello, I am new to this site and to VBA, so please bare with me. I need a macro for work to import data from an Excel file into a "Master"-Excel and sort it in a table. The task is to list occured events based on calendar weeks (CW). The input (separate Excel file) is the frequency of events...

Hi, I have been looking at a lot of event change codes but none seem to work... i would like the event change to fire if rows or columns are deleted and if they have been deleted then set the new Range as ActiveSheet.UsedRange to get the true range of cells. I have tried enabling and disabling...

Hi, Is there any way to use worksheet_change event only when user input some value? I do not want to execute event when value will be added by macro. I know that can use Application.EnebleEvents but I really do not like it couse of possibility of demage all macros when some error occurring...