selection change

  1. K

    Conditional Locking if Cells below are blank

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

    Cell Selection show userforms

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

    disable selection change vba while running other code

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

    Worksheet Selection Change to work on all sheets

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

    VBA: Using Selection.Interior.ColorIndex on multiple columns but only once a line

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

    Locked cell behavior

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

    Code for value replacement

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

    Calling

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

    Worksheet Change Event and Selection change not working

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

    worksheet_SelectionChange for a specific column

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

    Automation help with VBA

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

    Selection change VBA has slowed Excel

    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" &...
  13. andrewb90

    Worksheet Change Help

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

    How to get worksheet_selection change to work

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

    Error Code 400 in VBA help

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

    Run VBA on Event Change Delete Row

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

    Cell Offset using Worksheet_SelectionChange subclass

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

    Autofilter search help

    I've got a database and I want people to be able to type in their initials and have only the rows that apply to that person remain. This is what I have so far: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("a2") = "" Then...

Some videos you may like

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