worksheet_selectionchange

  1. T

    Worksheet_Change / Worksheet_SelectionChange with Data Validation

    Further to my thread here: https://www.mrexcel.com/forum/excel-questions/1096576-vba-worksheet_chnage-event-bug-3.html Here is the code: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) With Application .EnableEvents = False Select...
  2. T

    VBA Worksheet_Chnage event bug

    My program has both a Worksheet_Change event and a Worksheet_SelectionChange event. For some reason, when it runs to the end of the Worksheet_Change event, it jumps to the Worksheet_SelectionChange event. Has anyone experienced this before?
  3. L

    Worksheet_SelectionChange won't work with Protected Sheet

    The event is triggered just fine when the worksheet is not protected. When I protect it, however, this event is no longer being triggered. Nothing else has changed. Is this how Excel is supposed to work? Not sure if I'm missing something here...
  4. P

    Automatically re-filter when I change a value in a cell

    Hello, I have a column starting from cell D22, which is set on a filter to eliminate the value "N" and keep the value "Y". The value ("Y" or "N") is generated by a formula that looks at whether the corresponding value in column A matches a value selected from a dropdown list in cell A6. The...
  5. J

    Excel 2010 Chnage Auditing - Combine Worksheet_SelectionChange and Paste?

    I have a requirement to add change auditing to an Excel 2010 workbook. If the user changes the value of a cell in columns A, B, C, or J, I need to capture the old value, the datetime of the change, the username, and the new value that they enter. I was able to do that - this code captures the...
  6. Prevost

    Run Macro on click of cell in range target - Intersect/Target Clarification

    Hi There, I have a question regarding the code below which is written on a worksheet. Firstly, does all code written on a worksheet have to be named "Worksheet_SelectionChange"? And what is "ByVal Target" mean? Lastly, the line "If Not Intersect(Target, CheckRange) Is Nothing Then" is not quite...
  7. D

    Worksheet_Selectionchange for 2 ranges and outputs

    The below macro allows users to select a cell from the named range "rngStructure" and produce a value in "valSelItem". This value I use to dynamically drive a dashboard. I now need to expand this dashboard to include a 2nd variable (output) "valSelItem2" from a 2nd range "rngStructure2"...
  8. D

    Colour cell if used in a new formula

    Hi again people, I've an odd question (again): I'm trying to change the background colour of a cell if the cell is used in a formula on a different sheet. My idea was to use the code below to change the cell colour when I clicked the cell: Private Sub Worksheet_SelectionChange(ByVal Target...
  9. B

    How do I us If Then to do Worksheet_SelectionChange over multiple columns

    Here is the code I wrote that doesn't work because I don't know how to set the column nnumber as an appropriate variable (I think that is the problem): Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim iColumn As Integor If Target.Count > 1 Then Exit Sub iColumn = Target.Column...
  10. N

    Private Sub Worksheet_SelectionChange

    Hi there, I am having a problem with the Paste' function in excel being disabled - i think this is down to the Private Sub Worksheet_SelectionChange(ByVal Target As Range) (as this seems to be the probelm from my web searches), however I'm not competant enoough in VB to know what in the sub is...

Watch MrExcel Video

This Week's Hot Topics

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
Top