Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range onclick?
Hi,
I want to run a subroutine onclick in an excel worksheet. More precise: Onclick in any cell I want to check for that cells properties and then react depending on them. Please help, how do I get excel to react on every click in the active sheet. Dennis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
range onclick?
I got it.
sorry to have bothered you for nothing. But - IŽll be back with more profound questions. my solution: "Private Sub Worksheet_SelectionChange(ByVal Target As Range)" thanks anyway dennis -----Original Message----- Hi, I want to run a subroutine onclick in an excel worksheet. More precise: Onclick in any cell I want to check for that cells properties and then react depending on them. Please help, how do I get excel to react on every click in the active sheet. Dennis . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
range onclick?
Hi,
You can you worksheet's SelectionChange event (this is just for a single sheet) or if you want to control this event in workbook base, use Workbook's SheetSelectionChange event. Target variable represents selected cell(s). Private Sub Worksheet_SelectionChange(ByVal Target As Range) if target.count=1 then 'check if just one cell selected. 'Do something end if End Sub OR Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) if target.count=1 then 'check if just one cell selected. 'Do something end if End Sub -- Regards Haldun Alay To e-mail me, please remove AT and DOT from my e-mail address. "Dennis" , iletide sunu yazdi ... Hi, I want to run a subroutine onclick in an excel worksheet. More precise: Onclick in any cell I want to check for that cells properties and then react depending on them. Please help, how do I get excel to react on every click in the active sheet. Dennis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
OnClick | Excel Discussion (Misc queries) | |||
Cell onclick make cell value increase. | Excel Programming | |||
how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming |