event change

  1. C

    active cell triggering events... only after it's no longer active ?

    I started with hardcoding this task which worked really well. But then, trying to put parameters in here instead has really thrown me off. The scenario: I have three columns: C (percent), D (hours), E (dollars) When the user enters a value into column C for a particular row, I want that...
  2. N

    Excel VBA (Force Paste Special): Cannot capture sheet change events correctly & issue with sendkeys

    Hi Friends, I am trying to use below VBA code to force paste special operation when a user performs cut/copy & paste. I am having 2 issues here: 1. The sheet change event triggers only the first-time (after opening the workbook) and thereafter it does not. 2. When (the first time) the code is...
  3. D

    Help Cleaning up Font.Color Keycells Macro

    Hi all, I'm trying to change the font color in a range when the cell in column G changes. The macro below is only working for the first row (row 8). I imagine this would be easier as a loop but I couldn't figure it out. There are many different font colors and each cell already has...
  4. R

    Two change events in same worksheet

    I have two macros running in a worksheet but one is functioning via a toggle button and the other is a drop down list which uses a change event. I've made some modifications to the spreadsheet and now need a formula to detect the toggle button value. I figured it would be best to get rid of...
  5. V

    Combining 2 worksheet change events

    Hello, need help with combining these 2 worksheet change events. Tried combining both under 1 worksheet change, didn't work. Anyways, here's the code. Please help, what's wrong? Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim MyRange As Range Dim c As Range Dim MyRange2 As Range...
  6. M

    Trouble with event changes

    I am new to VBA and have been following many different YouTube videos. I have had great success until it came to event changes. In a specific worksheet I have entered the following: Sub addition() Cells(3, 1) = Cells(2, 1) + Cells(1, 1) End Sub Private Sub commandbutton_click() Call...
  7. C

    Target Offset problems in Event

    Hello. I am trying to fill a cells interior color if a condition is not met. The issue is while the columns where I am texting the condition move, the column that I want to fill does not. So I think it the offset that I am trying to figure out how to replace. Thanks Private Sub...
  8. J

    Weird event issues

    Hello guys and gals. I got this weird situation that I hope someone can help me resolve. I have tried a lot of googling, but am unable to find a solution. The web is flooded with people not understanding Application.EnableEvents, so it is a bit difficult to find relevant information. I can...
  9. C

    How do I add a range to a Worksheet change event?

    The following code adds a comment to any cell that has been been change. However, right now it applies to the entire worksheet. Is there a way I can limit the target to a specified range? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Comment Is Nothing...
  10. S

    Multiple Cell Change Events

    Hello, I have a sheet where users enter inputs, and I want the sheet to clear all inputs when they change the account name. The code for this is below, and was successfully implemented: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C4")) Is Nothing Then...
  11. M

    Code to Calculate Certain Cells Upon User Entry

    Hi, I have a workbook with a "landing page" where users enter some information, then click a button to run a macro that calculates the (large) workbook. Only the landing page is set for automatic calculation. This works fine, but at one point on the page the user enters a ZIP code and I want it...
  12. S

    Selection Change Event Modification

    Hi All, File can be found at : www.indianwebcompany.com/common/vacation_planner_yearly.xlsb I am very new to excel data but some how managed to found what i needed , it is a vacation planner. I did some modifications to the same but still require some more & that i am not able to do. The...
  13. I

    VBA - Event/Change Macro on Cell Value using a Formula

    I hear this can be very difficult but I want to be having a macro run automatically depending on the contents of a cell, the cell includes a formula. I did find a working example somewhere, but for the life of me I can't find it again - anyway to the point :):) When I mess with the Width and...
  14. A

    Clear cells on adjacent cell change

    New to VBA but feel that using it is the solution to this question: I have text in column F (cells 20 to 199) that changes automatically based on pre-determined time constraints (this is done via an IF formula). I want the 4 cells adjacent to F to clear contents when the text in F changes...
  15. X

    Code in Change event is not run.

    Hallo Excel fans, I have a programming problem I don’t seem to be able to solve on my own…? What I have: A row of cells each containing Data Validation. The user selects an item from the Data validation list. The adjacent cell determine, though an IF statement and the selected value, if a row...
  16. F

    Change Interior Color from VLOOKUP Cell?

    Hi, Got the below piece of code in my worksheet "POSITION SETUP". In that sheet i have two columns in a table, A where i fill in my position title, ex. "POS1", and B where i select the words "NONE","RED","YELLOW","BLUE"....Etc. from a validation list. I use the attached code for that worksheet...
  17. L

    Worksheet Event change macro not working

    I am using the standard BetAngel_1 workbook that links BetFair race details directly into a spreadsheet via Bet Angel I also have 2 other sheets that generate other criteria My problem is that I have an event change macro in the BetAngel_1 sheet that is supposed to clear a range of cells if...
  18. I

    Chaange event to work on every sheet

    Hi All, The below mentioned event code changes the changed cell value to bold. I want this to be applicable to all the worksheets available in the workbook. I know i can paste this code in all the worksheets, but just want to know is there a better way of making it applicable in all the...
  19. W

    Using Worksheet Change when range is updated by formula not user

    Hi I have a problem in using the Worksheet Change event. My code checks the Target range named 'designStatus' and performs various checks and actions if the user changes this cell. My problem comes if the Target range does not equal 'designStatus'. In this instance, I would like the system...
  20. B

    Stop combobox_click code running when the code changes the value

    Hi, I have several combo boxes with varible lists of data; modifiying combobox1 causes the list in combobox2 to be updated. The problem I have is that when the code from combobox1 updates combobox2 I finish with the line below (this line just makes the combobox2.value equal the first value in...

Some videos you may like

This Week's Hot Topics

Top