|
Activate macro after clicking on a particular cell
What do I have to code in order to call a macro after a select, or clikc on a
paricular cell?, for example, I would like to run the macro after a select the cell A10 or a range of cells that have a format of merge so they look like a big cell ? Thanks -- Moises |
Activate macro after clicking on a particular cell
Which is it: A10 or a range of cells that have a format of merge so they
look like a big cell? -- Regards, Tom Ogilvy "Moises" wrote: What do I have to code in order to call a macro after a select, or clikc on a paricular cell?, for example, I would like to run the macro after a select the cell A10 or a range of cells that have a format of merge so they look like a big cell ? Thanks -- Moises |
Activate macro after clicking on a particular cell
hi tom, i've got same question as moises, how can i start macro once a cell,
with a pulldown list, has a value entered? "Tom Ogilvy" wrote: Which is it: A10 or a range of cells that have a format of merge so they look like a big cell? |
Activate macro after clicking on a particular cell
I have both cases, one with a single cell like A10, and the second case a
range of cells with a merge format so they are displayed as a big cell (for example range b2..d3, with a merge format). Thanks -- Moises "Tom Ogilvy" wrote: Which is it: A10 or a range of cells that have a format of merge so they look like a big cell? -- Regards, Tom Ogilvy "Moises" wrote: What do I have to code in order to call a macro after a select, or clikc on a paricular cell?, for example, I would like to run the macro after a select the cell A10 or a range of cells that have a format of merge so they look like a big cell ? Thanks -- Moises |
Activate macro after clicking on a particular cell
Right click on the sheet tab and select view code and put in code like this
Private Sub Worksheet_Change(ByVal Target As Range) Set rng = Target.MergeArea Select Case rng.Address(0, 0) Case "A10" Case "B2:D3" End Select End Sub then call the procedures within the case statements or put your code there. -- Regards, Tom Ogilvy "Moises" wrote: I have both cases, one with a single cell like A10, and the second case a range of cells with a merge format so they are displayed as a big cell (for example range b2..d3, with a merge format). Thanks -- Moises "Tom Ogilvy" wrote: Which is it: A10 or a range of cells that have a format of merge so they look like a big cell? -- Regards, Tom Ogilvy "Moises" wrote: What do I have to code in order to call a macro after a select, or clikc on a paricular cell?, for example, I would like to run the macro after a select the cell A10 or a range of cells that have a format of merge so they look like a big cell ? Thanks -- Moises |
Activate macro after clicking on a particular cell
I have a similar issue. I tried the solution listed here and it worked... a
little too well. In the Private Sub Worksheet_Change(ByVal Target as Range) (I'm not clear on what the ByVal Target as Range does,) the macro makes changes to the worksheet. Specifically, it inserts a row in the current worksheet and copies some formulas from an adjacent row. The problem with this is that the Private Sub is calling itself when it makes the change since the Sub causes the change that activates itself. This sends the macro into an infinite loop whenever I make a change and I have to ctrl+break to regain control. The macro stops in the middle of execution and restarts. Any ideas on how to make the macro only execute once or only execute when the user makes the change instead of the macro? "Tom Ogilvy" wrote: Right click on the sheet tab and select view code and put in code like this Private Sub Worksheet_Change(ByVal Target As Range) Set rng = Target.MergeArea Select Case rng.Address(0, 0) Case "A10" Case "B2:D3" End Select End Sub then call the procedures within the case statements or put your code there. -- Regards, Tom Ogilvy "Moises" wrote: I have both cases, one with a single cell like A10, and the second case a range of cells with a merge format so they are displayed as a big cell (for example range b2..d3, with a merge format). Thanks -- Moises "Tom Ogilvy" wrote: Which is it: A10 or a range of cells that have a format of merge so they look like a big cell? -- Regards, Tom Ogilvy "Moises" wrote: What do I have to code in order to call a macro after a select, or clikc on a paricular cell?, for example, I would like to run the macro after a select the cell A10 or a range of cells that have a format of merge so they look like a big cell ? Thanks -- Moises |
Activate macro after clicking on a particular cell
Tom,
How far away am I from getting this to work? I try and avoid macros at all costs and I am now knee deep in this. Can you spare a moment to advise? I am trying to get a calendar form to appear when a user selects either cell B9 Or Cell C9 in the concerned worksheet....Thanks in advance for whatever advice you can supply... Walt "Tom Ogilvy" wrote: Right click on the sheet tab and select view code and put in code like this Private Sub Worksheet_Change(ByVal Target As Range) Set rng = Target.MergeArea Select Case rng.Address(0, 0) Case "A10" Case "B2:D3" End Select End Sub then call the procedures within the case statements or put your code there. -- Regards, Tom Ogilvy "Moises" wrote: I have both cases, one with a single cell like A10, and the second case a range of cells with a merge format so they are displayed as a big cell (for example range b2..d3, with a merge format). Thanks -- Moises "Tom Ogilvy" wrote: Which is it: A10 or a range of cells that have a format of merge so they look like a big cell? -- Regards, Tom Ogilvy "Moises" wrote: What do I have to code in order to call a macro after a select, or clikc on a paricular cell?, for example, I would like to run the macro after a select the cell A10 or a range of cells that have a format of merge so they look like a big cell ? Thanks -- Moises |
Activate macro after clicking on a particular cell
oops:
Private Sub Worksheet_Change(ByVal Target As Range) Set rng = Target.MergeArea Select Case rng.Address(0, 0) Case "B9" Sub OpenCalendar() ' Displays the UserForm and calendar ' Shortcuts should be made to this procedure End If Case "C9" Sub OpenCalendar() End Sub "Tom Ogilvy" wrote: Right click on the sheet tab and select view code and put in code like this Private Sub Worksheet_Change(ByVal Target As Range) Set rng = Target.MergeArea Select Case rng.Address(0, 0) Case "A10" Case "B2:D3" End Select End Sub then call the procedures within the case statements or put your code there. -- Regards, Tom Ogilvy "Moises" wrote: I have both cases, one with a single cell like A10, and the second case a range of cells with a merge format so they are displayed as a big cell (for example range b2..d3, with a merge format). Thanks -- Moises "Tom Ogilvy" wrote: Which is it: A10 or a range of cells that have a format of merge so they look like a big cell? -- Regards, Tom Ogilvy "Moises" wrote: What do I have to code in order to call a macro after a select, or clikc on a paricular cell?, for example, I would like to run the macro after a select the cell A10 or a range of cells that have a format of merge so they look like a big cell ? Thanks -- Moises |
| All times are GMT +1. The time now is 05:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com