active cell to run macro

[kalpeshpatel]

hi,


it is possibel that when in sheet1 a1 cell is active to run macro

 

[SirJB7]

Hi, kalpeshpatel!

It isn't very clear what do you want to do, is it running a macro when something entered in A1? Please explain.

Regards!

 

[vijaySharma]

@Kalpesh,


1. Press Alt+F11 to get the VB Editor on the Screen.

2. Go to View Menu and Click on Project Explorer.

3. On the Left Hand side.... Double Click on Sheet1

4. Paste the below code...


Now everytime you click on Cell A5... you will get the message box... (change this to run your code)...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Address = "$A$5" Then

MsgBox "You just clicked cell A5.... Now i will run"

End If

End Sub

~VijaySharma

 

[kalpeshpatel]

actually i will make a macro to lock scroll area


when a1 cell is active a1:f10 range only for scroll.

 

[vijaySharma]

Do you mean... when you click on cell A1... then lock the scroll area to A1:F10... and if any other cell is clicked then unlock the scroll area?


~VijaySharma

 

[kalpeshpatel]

wow it is great


code will work perfect

thanks for help


it is possibel to active cell range e.g


cell active between a1:B10 range to run macro

 

[Luke M]

Sure. You can do something like this:

[pre]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Range("A1:B10"),Target) Is Nothing Then Exit Sub
MsgBox "You are in the target range.... Now i will run"
End Sub

[/pre]

 

[kalpeshpatel]

i can't believe this


thanks very much


nice answer 100% work correctly.

 

[Luke M]

You're very welcome. =)

 

[kalpeshpatel]

when sheet1 is active then run macro


how it is possible