HI I would like to combine two VBA codes but 1 works the other one does not :( I need the first code to monitor the two columns in the last code.
Hope someone can help
Dim xRg As Range
Dim xChangeRg As Range
Dim xDependRg As Range
Dim xDic As New Dictionary
Private Sub Worksheet_Change(ByVal...
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...
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?
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...
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...
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...
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...
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"...
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...
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...
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...
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.