event

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

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

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

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

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

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

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

I've been googling this issue a lot without finding a solution. I have a code in the Workbook_Open event that runs normally when I double click my excel file and wait till it's open. But if I double click hte file and then activate another window (i.e. my internet browser or a file folder)...

Hi all! I am in need of code that will fill in the below formula in E7:E5000 with a deactivate event. =IFERROR(INDEX(Instruments!$C$3:$C$40,MATCH(B7,Instruments!$B$3:$B$40,0)),0) Thank you!

I'm currently using a keybind to suppress messages about document inspector and then save using the following code Sub Remove_Information_Save() 'Macro Activates when CTRL+S is used Application.DisplayAlerts = False ActiveWorkbook.RemovePersonalInformation = True...

I am working on a split form in ms access. I would like my form to not add a record if the Sending_Category = Contractors or Salaries & Benefits, and the Sending_FTE is blank. I have tried this as an on click event for the "Add Record" Macro, and on the form as a before update event. My "add...

Hi everyone, I was tinkering with the selectionchange event but came across an error. "Cannot run the macro ''.xlsm'!DropdownList'. The macro may not be available in the workbook or all macros may be disabled." I checked in my options if the trust center blocked my macro but it's on "enable all...

Hi All, my first post so sorry if its in the wrong place! Im looking to make a spreadsheet for a local club which im involved with that will track their points throughout a season and show who is the winner at the end. Basically its a horse riding club and they have around five events a year...

I have a situation where I want to delete all records in a table - I don't want to delete the table - just the records. Is there a way to do this in VBA (click button event) My table name is "ModelGeneral_vluItem1" Thanks! I really appreciate the help.

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

Is there a way to insert a character while the user is still typing. For example if the user is entering the date, automatically insert either a "-" or "," or "/", or a "." after the first two characters. For this instance I just need to insert the character after the two digit month followed by...

I'd like to have a text box appear after an event but only last for several seconds -- maybe 20. Just to verify that the event took place.

I have 2 files. In File1.xlsx, Column A contains the time of day and Column B is where I need work codes copied from File2.xlsx. So before anything happens, File1.xlsx looks like this A1 = 06:00 A2 = 06:01 A3 = 06:02 A4 = 06:03 A5 = 06:04 A6 = 06:05 Etc. all day long, 1 row for every minute of...

Hi guys, Hopefully there is a simple solution to this problem. I would like to create a list of dates in a column based on the results of the data in another column. So, In col A i have a range of dates that are random dates from throughout the year. In col B I have either a 1 or a 0...the 1...

I've a button on a web page that I am trying to click using vba. The button exports the table to excel; it does not have any text but only the excel logo. Below is the html of the button retrieved using the 'inspect element' property of the web page. < a class="x1" tab index="0"...