| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select Cell address between Specified Range
If user click between Range("A1:A10") only then i would like to return the
address of the selected cell for calculation purpose. Is it possible in vba ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to select Cell address between Specified Range
Look at the Selection_Change event of the worksheet where you want
this to happen: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A1:A10")) _ Is Nothing Then MsgBox Target.Address End Sub Max wrote: If user click between Range("A1:A10") only then i would like to return the address of the selected cell for calculation purpose. Is it possible in vba ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to select Cell address between Specified Range
msgbox Selection.Address & ", " & ActiveCell.Address
-- Regards, Tom Ogilvy "Max" wrote: If user click between Range("A1:A10") only then i would like to return the address of the selected cell for calculation purpose. Is it possible in vba ? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to select Cell address between Specified Range
and here is another interpretation:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Selection, _ Range("A1:A10")) Is Nothing Then MsgBox Target.Address End If End Sub Right click on the sheet tab and select view code - then paste in the above. -- Regards, Tom Ogilvy "Max" wrote: If user click between Range("A1:A10") only then i would like to return the address of the selected cell for calculation purpose. Is it possible in vba ? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to select Cell address between Specified Range
Thanx JW,
Your solution solve my problem. "JW" wrote: Look at the Selection_Change event of the worksheet where you want this to happen: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A1:A10")) _ Is Nothing Then MsgBox Target.Address End Sub Max wrote: If user click between Range("A1:A10") only then i would like to return the address of the selected cell for calculation purpose. Is it possible in vba ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am trying to select a new cell whose row address is based on a variable | Excel Programming | |||
| Is is possible to have a macro select a cell and return the address for use as a variable? | Excel Programming | |||
| select range and put range address in variable | Excel Programming | |||
| Select Cell based on Variable address | Excel Programming | |||
| How do you select a cell with an "absolute" address with a cursor? | New Users to Excel | |||
Linear Mode
