General question about using "worksheet" when select from the VBA Editor?
question about Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
This probably seems basic to you, but Im trying to create a
spreadsheet that would need to be updated as the user
changes/manipulates the worksheet. The only way I see to change
things as the user manipulates is to use the if else statement. Is
there a more general statement that can be used. I have tried
..selection. The for, while, case select dont work as I intended
When something is changed/moved/manipulated on that sheet does what
you have coded run from the very top all the time?
This is difficult to explain, but any advice is appreciated
Thanks
|