from the xlVBA help:
SelectionChange Event
Occurs when the selection changes on a worksheet.
Short and nice definition.
But when does a selection change?
Does the selection change when the selected range moves to another range?
Or does the selection change when its value changes?
Or both?
And how to deal with that?
how I can make something happen when hitting enter. like an on enter event or something.
View 9 Replies View RelatedI have a reference sheet that the only cell that should be accessed is in col A
Rather than protecting the sheet I have made it so that what ever cell is selected it changes to select the cell in A
however if the selection is made using the col, header (ie clicking the C) it falls over.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(ActiveCell, Range("A6:A1000")) Is Nothing Then 'makes sure A isn't already selected
x = ActiveCell.End(xlToLeft).Cells.Count
ActiveCell.Offset(0, -x).Select
Else
If Selection.Cells.Count > 1 Then ' fixes the problem of selecting a range that starts with an A
ActiveCell.Select
End If
End If
End Sub
I have a page that is protected so formulas are not changed mistakenly, and have check boxes on the paged that link to cells and display True of False based on the checking of the box or not. If I leave the page unprotected I risk the True or False being changed. Is there a lay to protect those cell from the user but still change when the box is checked or not. The checkboxes are Form Control type.
View 6 Replies View Relatedtime-to-time an unexpected eventcode appears in my worksheet modules
View 10 Replies View RelatedI have a SheetSelectionChange event that stores the Target.Row in a cell on the active worksheet.
View 15 Replies View RelatedI have code in my Worksheet_SelectionChange.
However it will not update until I physically click on any cell within the U33 to U38 range.
How do I tell Excel that I physically clicked on any of these cells? I have tried Activate..., blank and re-populate, select cell, select range... In VBA it does not think it is being clicked on.. it is just doing the code... when done I have to again manually/physically click on it.
I have a large amount of data and I'm trying to count how many unique values I have in one column. I also want to know how many times each duplicate appears. I tried using a pivot table but it's not working for me.
I also tried the following formula: =SUM(IF(FREQUENCY(H:H,H:H)>0,1)) but it's not quite working.
