intersect(target

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...

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...

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...

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...

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...

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...