intersect(target

  1. cpg84

    Tab name change issue

    Hi All, As a follow on from my previous post a few weeks ago, this is the code I have at the moment. It works perfectly when I change the value in cell G7. What I didn't account for was when you clear the contents of G7. I want to be able to either have the tab name to stay as it was...
  2. B

    VBA: Vlookups to auto-populate data into a list - can it be more efficient?

    Hi, I have created some code for doing some vlookups to auto-populate data into a spreadsheet list. Against each record, the user selects the correct value from a drop down list, then, based on the value chosen, the vlookups find the matching value from a different sheet (the ‘Hosts List’) and...
  3. 9tanstaafl9

    Run macro when cell value changes in named range. Silly error?

    Hi, I want to be able to run a macro whenever the user changes the value in a specified range. Right now there is data validation and a pick list where users can change the default value from E to A or F. I found code on this board but nothing seems to happen. I've never run a macro using this...
  4. C

    Run userform when cell in range changes to a specific value

    Hello gurus :) I have a range of data validation list cells (c2:c300) and I'd like to call a userform when the user selects "Add..." from the dorpdown list of one of those cells. I need this part of code because I'm trying to let the user add items to the validation list. If you have any...
  5. R

    VBA Create a different "Target" inside each procedure.

    Hello. I am trying to make a code that calls different procedures depending on the ranges I select. The problem is, inside that procedures I have other Intersects to call other procedures. And it gives me errors because the target is not defined on those sub procedures. Here the code I have to...
  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...

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