| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Run Macro on Mouse Click
Is is possible to run a macro that displays a pre-set number upon clicking in
a cell? For example: everytime someone needs to see the value 24 in cell b4 all they have to do is click in that cell to make that number visible. Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Macro on Mouse Click
On Thu, 13 Jul 2006 10:58:02 -0700, vacation
wrote: Is is possible to run a macro that displays a pre-set number upon clicking in a cell? For example: everytime someone needs to see the value 24 in cell b4 all they have to do is click in that cell to make that number visible. Thank you The following in the Worksheet Selection Change event should do the trick Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("B4")) Is Nothing Then Range("B4") ="24" End Sub HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Macro on Mouse Click
Thank you! I appreciate it!
"Richard Buttrey" wrote: On Thu, 13 Jul 2006 10:58:02 -0700, vacation wrote: Is is possible to run a macro that displays a pre-set number upon clicking in a cell? For example: everytime someone needs to see the value 24 in cell b4 all they have to do is click in that cell to make that number visible. Thank you The following in the Worksheet Selection Change event should do the trick Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("B4")) Is Nothing Then Range("B4") ="24" End Sub HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Macro on Mouse Click
I am working in Excel version 2000. Is Worksheet Selection Change event in
there? "Richard Buttrey" wrote: On Thu, 13 Jul 2006 10:58:02 -0700, vacation wrote: Is is possible to run a macro that displays a pre-set number upon clicking in a cell? For example: everytime someone needs to see the value 24 in cell b4 all they have to do is click in that cell to make that number visible. Thank you The following in the Worksheet Selection Change event should do the trick Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("B4")) Is Nothing Then Range("B4") ="24" End Sub HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Macro on Mouse Click
It's in all Excel since Excel 97.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vacation" wrote in message ... I am working in Excel version 2000. Is Worksheet Selection Change event in there? "Richard Buttrey" wrote: On Thu, 13 Jul 2006 10:58:02 -0700, vacation wrote: Is is possible to run a macro that displays a pre-set number upon clicking in a cell? For example: everytime someone needs to see the value 24 in cell b4 all they have to do is click in that cell to make that number visible. Thank you The following in the Worksheet Selection Change event should do the trick Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("B4")) Is Nothing Then Range("B4") ="24" End Sub HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Macro on Mouse Click
Thanks
"Bob Phillips" wrote: It's in all Excel since Excel 97. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vacation" wrote in message ... I am working in Excel version 2000. Is Worksheet Selection Change event in there? "Richard Buttrey" wrote: On Thu, 13 Jul 2006 10:58:02 -0700, vacation wrote: Is is possible to run a macro that displays a pre-set number upon clicking in a cell? For example: everytime someone needs to see the value 24 in cell b4 all they have to do is click in that cell to make that number visible. Thank you The following in the Worksheet Selection Change event should do the trick Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("B4")) Is Nothing Then Range("B4") ="24" End Sub HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Macro on Mouse Click
I have been searching in Excel to find this function for words like it in the
function drop down lists. Do you know where it is? When used help I found worksheet_function but not worksheet_selection change. "Bob Phillips" wrote: It's in all Excel since Excel 97. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vacation" wrote in message ... I am working in Excel version 2000. Is Worksheet Selection Change event in there? "Richard Buttrey" wrote: On Thu, 13 Jul 2006 10:58:02 -0700, vacation wrote: Is is possible to run a macro that displays a pre-set number upon clicking in a cell? For example: everytime someone needs to see the value 24 in cell b4 all they have to do is click in that cell to make that number visible. Thank you The following in the Worksheet Selection Change event should do the trick Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("B4")) Is Nothing Then Range("B4") ="24" End Sub HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Macro on Mouse Click
Just lookup SelectionChange
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vacation" wrote in message ... I have been searching in Excel to find this function for words like it in the function drop down lists. Do you know where it is? When used help I found worksheet_function but not worksheet_selection change. "Bob Phillips" wrote: It's in all Excel since Excel 97. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vacation" wrote in message ... I am working in Excel version 2000. Is Worksheet Selection Change event in there? "Richard Buttrey" wrote: On Thu, 13 Jul 2006 10:58:02 -0700, vacation wrote: Is is possible to run a macro that displays a pre-set number upon clicking in a cell? For example: everytime someone needs to see the value 24 in cell b4 all they have to do is click in that cell to make that number visible. Thank you The following in the Worksheet Selection Change event should do the trick Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("B4")) Is Nothing Then Range("B4") ="24" End Sub HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Run Macro on Mouse Click
Tried that and other variations but it was not found in Excel help. Any other
ideas? SelectionChange is not in my help index. Are we positive its in Excel 2000 or maybe its in Excel 2000 but under another term? "Bob Phillips" wrote: Just lookup SelectionChange -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vacation" wrote in message ... I have been searching in Excel to find this function for words like it in the function drop down lists. Do you know where it is? When used help I found worksheet_function but not worksheet_selection change. "Bob Phillips" wrote: It's in all Excel since Excel 97. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vacation" wrote in message ... I am working in Excel version 2000. Is Worksheet Selection Change event in there? "Richard Buttrey" wrote: On Thu, 13 Jul 2006 10:58:02 -0700, vacation wrote: Is is possible to run a macro that displays a pre-set number upon clicking in a cell? For example: everytime someone needs to see the value 24 in cell b4 all they have to do is click in that cell to make that number visible. Thank you The following in the Worksheet Selection Change event should do the trick Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("B4")) Is Nothing Then Range("B4") ="24" End Sub HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run macro on double click only | Excel Discussion (Misc queries) | |||
| I click on something and my Macro buttons disappered. Help. | New Users to Excel | |||
| adding macro to right mouse click menu | Excel Discussion (Misc queries) | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Mouse right click problem | Excel Discussion (Misc queries) | |||
Linear Mode
