byval target as range

  1. T

    Private Sub Worksheet_Change(ByVal Target As Range) with multiple targets

    Hello, I am still fairly new to VBA programming but have been learning quickly. When looking for a way to add conditional formatting to a shape to make it change color, I came across "Private Sub Worksheet_Change(ByVal Target As Range)." While I was able to get this to work with a single shape...
  2. B

    VBA Timestamp/Run-time error 13

    Hello all, First time posting, I'm having trouble with a simple VBA sub I've been working on. The idea is that the code drops a timestamp into a specific cell when the Plan-Do-Check-Accept (PDCA) status of that row changes. Sub Worksheet_Change(ByVal Target As Range) Dim D As Range: Set D =...
    • bencharn
    • Thread
    • byval target as range runtime error 13 mismatch subroutine timestamp vba & macros
    • Replies: 4
    • Forum: Excel Questions
  3. B

    Worksheet_Change(ByVal Target As Range) - Two Condition

    I have dropdowns in Cells(44,1) and Cells(44,6) with simple values of Yes or No I am attempting to do a ByVal but I need allow the user to select in any order - meaning changing the value of Cells(44,6) first and Cells(44,1) second and vice versa. I have tried AND in my statements as well and...
    • bsquad
    • Thread
    • byval target as range cells44 end row worksheet_changebyval
    • Replies: 6
    • Forum: Excel Questions
  4. S

    Need a little VBA assistance..

    I have a Excel sheet. with the following basic lay out.... <tbody> A B D E F G I J 0002841124 Jane Doe 0002841109 08 March 2016 22:07:53 Class 73 Jane Doe 0 </tbody> To...
  5. H

    Please help with compressing multiple Private Subs

    Hi All, Thanks for checking out my question. I've been asked to create a button that only appears based on 3 of 4 values available from a dropdown box(K6). The values are "REMOVE", "ADD ON" and "REPLACE EXISTING". Here's what I have so far. I can get it to work for one value like, "REMOVE", but...
  6. Benders

    Private Sub Worksheet_Change(ByVal Target As Range) not working

    Column A may have entries like A001, A002...A00n! For certain such entries a message box should pop up if the corresponding 'Fruits' are not found in Row 23. I tried the following code but cannot get it to work. Where am I going wrong? Private Sub Worksheet_Change(ByVal Target As Range) On...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top