events

Greetings; I spent some time searching but did not seem to find the answer I'm looking for, so hopefully this is not a repeat question. Nevertheless, I feel like this should have a simple answer; I just don't know what it is. Say I have a finite list of multiple independent events (no real...

I basically get my Data from external dashboard through Copy then paste matching source as Get data from Web function is not possible due to IE limitation. the Data however, when I paste to excel would only be on Column A, that is fine but I need to process it just like in my Example Column B...

I am needing to do the following: I have a challenge with 3 different events. I have the total score column calculating the sum of all three events. I am trying to fill the total score column red if one of the event scores is lower than 60. Can I manually use an if statement to fill cell color?

On a worksheet, I have created a MS Forms 2.0 Frame and added several commandbuttons onto it. But how can I code some events into the commandbuttons? I can't locate their names and appearance in VBE and elsewhere. The reason of using Frame is to fix the positions of a bunch of already-made...

Hi, I'm creating a project in Excel, programmed in VBA, but I've reached a limit of my understanding, so I thought I'd post for help. Essentially I'm trying to create one of these. In case the link breaks/ to make it relevant to other users: what I'm trying to create is a GUI with some slightly...

Hello Excel World, Hoping someone can help me out or point me in the right direction! I am definitely a noob to Excel but have used YouTube to guide me to where I am so far with this project. I am creating an event register/tracker that is "self-sufficient" meaning that I want it to identify...

I'm trying to identify if a certain cell value changed in a table. Following examples found within the forum here, I'm only able to identify if the change occurs in a specific column. How can I adjust to a specific cell within the table? I want to execute additional code if it's the first cell...

To use copy/paste I have to turn off Events. On all my workbooks that have events, I have to include a button, "Events off/on". Its a pain. This is not a new problem I am having but I'm wondering if it is just a feature of Excel and I have to put up with it. Help appreciated.

Hi everyone! :stickouttounge: I have a workbook with several worksheets, each one of which has a named range called "MyTitle". Besides, each one of my worksheets also has a drop-down validation list placed in another cell named as "MySheets". Every time the user manually changes the value of...

Hi all, Not to savy with excel. I have created three tabs. Tab 1 year veiw (esentially its 12 months in a linear fashion with different work sections), tab 2 is month view (days of the month in a linear fashion with work sections under the days), tab 3 is event information. What im looking to...

How do I get my workbook to declare public variables on the Workbook.Open event? The following code gives an error because I'm trying to declare a public variable inside a sub-routine (this is in the "ThisWorkbook" code) Private Sub Workbook_Open() Public enableTestMode As Boolean...

My first post!!! Woo hoo!! I have a UserForm that contains checkboxes and one frame "FRAME_Main". When I click a check box (say a group of products from a catalog), I want the frame to populate with available items in that group. I create a FRAME_xx (xx it a number 01 to 99), and within...

I want to write some code if a cells comment changes. Worksheet change doesn't fire if you right click a cell and edit the comment and save it. Is there an event that does fire when the comment changes?

I have managed to create a working worksheet change macro but have since learned I can not have two such macros in one worksheet (Excel 2010). The worksheet will have budget data to include two types budget adjustments and budget enhancements. I want to have a cell that allows the user to show...

This one is hopefully a simple answer from an expert. I used a previous program as a template for building a new one, but run into a 1004 error on launch. Don't spend mush time on this as I am sure I will figure it out quickly even without help. Upon launching, I get this error...

Hi All, I am trying get the click events of a label created on a frame, but unsuccessful. What am I doing wrong? Here is the code: Option Explicit Private WithEvents lblCmdCancel As MSForms.Label Private Sub CommandButton1_Click() Dim frmMain As MSForms.Frame Set frmMain =...

Hey guys, I have a problem I would like some of you to help me or at least guide me. I have a Pivot Table with a lot of divisions, like company divisions and are structured on 5 levels of importance and break down as such. Each division has a unique code. My issue is that i would like Excel to...

I create a series of labels and text boxes at runtime. for x = 1 to 10 labelName = "label" & x Set cControlLabel = Me.frameScrollable.Controls.Add("Forms.Label.1", labelName, True) next xHow can I assign an on_click event to these? I have seen some rather complicated...

I have a project which at the very beginning sets calculation to Manual. I also have a spreadsheet "Loans" that has an Event subroutine that calculates certain range whenever it is activated Option Explicit Private Sub Worksheet_Activate() Worksheets("Loan_Information").Rows(4).Calculate...

Im having some problems having the macro triggered by the value change on one of my cells. The cell's value is not manually changed by user or changed by VBA code, rather, it is changed by an external feed that is transfered to excel via DLL (dynamic link library). Basically what I am...