selection change

I am extremely new to VBA, so I hope that this is easy to do and I am just missing the obvious. I have code that defines a named range as the active row, and another that does the same for the active column. How to I combine the two into one sub so that I can automatically calculate active row...

Hi, I currently have a searchable checklist that I would like to build in a function where if a row is selected by the values in column A, if there is already a True value for it in offset column E, it bounces back a message saying that it already is True (checked). User is only allowed to...

Hi! I've searched everywhere (not just this forum) and I can't figure this problem out and therefore I hope someone here can assist :) What I want: I want to be able to create a folder whenever a new entry is made in i.e. column A with the folder name being whatever is entered in the row. I.e...

I was able to get the coding below to working using the logic in this link below; however, when I apply this to 30 lines of data I get so many message boxes you have to force excel to close to move on. How can I consolidate this code to only show one error message? Private Sub...

Need some help here. I have a spreadsheet with about 400 different editable cells. About 50 of those cells have a different Userform to insert that cell' data. I would like to be able to select the cell and have the corresponding Userform show. For example is "B6" was selected it would show a...

Hello all, I notice that my code is always running through my various selection change codes when I run a macro, is there any way I can have those bypassed while macros are running? I feel that would speed things up.

Hi I have a macro that works fine if it is in the workbook that is being used, but i want to be able to make it work in any active workbook by assigning the macro to the quick access toolbar, but i cant get a worksheet selection change event in a module in my personal xlsb. This is my code i...

Hi everyone, I would like to be able to: - use Selection.Interior.ColorIndex on several columns but only once every line. - if 1 cell (B5) on the line (5) has already been "colored" (selected) and I select an other cell (D5) one the same line then the the first cell (B5) go back to no color...

Is there any way to completely lock out a cell from a user deleting the formula/information contained in it? Even with the cells being locked and hidden on a protected sheet, all a user has to do is click on an unlocked cell and drag their selection into the locked cells. If they hit delete, all...

Hi everyone, first post here. So, I have this spreadsheet that needs to change the values A B C D E F G <colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> 5 e e z z u u 10...

Hi Gurus, :-D This is my first post so if I'm not playing by the rules, I'm happy to take on any feedback... So I have a code that I use frequently that I want to place in my "personal macro workbook" so I can call it quickly without re-writing it each time I wish to use it. The code...

Hi I have a suggestions log, and I would like to keep a track of Likes and Dislikes. I have an Excel table with a specific column to vote, but entering "L" or "D" (for Like and Dislike). I have code which will tally this up and identify net Like or Dislike. However, to call this macro, I'm...

I have a worksheet that contains invoice numbers in column D. I'd like to copy the invoice number to another worksheet ("Details") when one is selected. I've added the "If IsNumeric" condition to make sure that only cells containing an invoice # can be copied over. The code is in the Sheet1...

So I have a selection change that checks the string in a data validation drop down box and changes a tables values. My first issue is that it only changes after I select my value of the drop down then click the cell again. How can I make it so it changes the table when i just select the drop...

Hello all, I have this code in place: Range("G18:M28").Interior.Color = xlNone Range("G18:M28").Font.Bold = False Set S = Application.Intersect(Range(Target.Address), Range("G18:M28")) If Not S Is Nothing Then Range("G" & Target.Row & ":M" &...

Hello, I have this: If Len(Target.Value) > 3 And Len(Target.Value) < 31 Then, I am trying to see if I can go from requiring an entry length to requiring a certain entry. such as "Blue Moon" basically once that phrase is entered, then my code will execute. thanks, Andrew

hello, I need a help with the following task: when a cell from H column is changed then I need a formula in I cell column to be written. Obviously I do not want to use Excel formulas like: =if(H1="","",weeknum(H1)) or any other variation of any formula as the file needs to be used by various...

I am hoping this is pretty minor, but I have a macro that I am trying to run, and when I do, it seems to interfere with my selection change code on my sheet. They both work independently, but when they are on the same sheet I have issues. Can anybody help with this? Here is one of my macros...

I have some VBA built that handles code on worksheet Selection Change that works fine. But I have some formulas that it is automatically inserting referencing other cells. However, when I have to delete a row (due to duplicate information), the cell formulas do not automatically update. I...

I have a scanner that scans and tabs across to next column. Once it gets to a certain column (i.e. column D) I need it to return 1 row down, back to column B. I figured the best way to handle this would be the SelectionChange excel object in VB. However, I just attempted to just use the...