Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to call a macro on selection of a cell in a range
Hi,
This might come across as a novice question, as I am in fact, a novice at vba. I'm trying to call a macro if a specific cell in a range is selected. This is what I've coded. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Start_Range As Range Set Start_Range = Range("C2:C1001") Dim End_Range As Range Set End_Range = Range("D2:D1001") If Target.Range = Start_Range or Target.Range = End_Range Then frmCalendar.Show End If End Sub However, I'm getting a Compile error stating Argument not optional. Can anyone please guide me to code this correctly? Thanks in advance. Sam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to call a macro on selection of a cell in a range
Got a solution to this through another forum. This is what was suggested and
worked. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim my_Range As Range Set my_Range = Intersect(Target, Range("C2:C1001,D2:D1001")) If Not my_Range Is Nothing Then frmCalendar.Show End Sub "The Narcissist" wrote: Hi, This might come across as a novice question, as I am in fact, a novice at vba. I'm trying to call a macro if a specific cell in a range is selected. This is what I've coded. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Start_Range As Range Set Start_Range = Range("C2:C1001") Dim End_Range As Range Set End_Range = Range("D2:D1001") If Target.Range = Start_Range or Target.Range = End_Range Then frmCalendar.Show End If End Sub However, I'm getting a Compile error stating Argument not optional. Can anyone please guide me to code this correctly? Thanks in advance. Sam |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to call a macro on selection of a cell in a range
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Start_Range As Range Set Start_Range = Range("C2:C1001") Dim End_Range As Range Set End_Range = Range("D2:D1001") If Not Intersect(Target, Start_Range) Is Nothing Or _ Not Intersect(Target, End_Range) Is Nothing Then frmCalendar.Show End If End Sub -- __________________________________ HTH Bob "The Narcissist" wrote in message ... Hi, This might come across as a novice question, as I am in fact, a novice at vba. I'm trying to call a macro if a specific cell in a range is selected. This is what I've coded. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Start_Range As Range Set Start_Range = Range("C2:C1001") Dim End_Range As Range Set End_Range = Range("D2:D1001") If Target.Range = Start_Range or Target.Range = End_Range Then frmCalendar.Show End If End Sub However, I'm getting a Compile error stating Argument not optional. Can anyone please guide me to code this correctly? Thanks in advance. Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
call range by cell value | Excel Worksheet Functions | |||
Call Macro when Cell within Range Changes | Excel Programming | |||
Passing a range in a macro call | Excel Programming | |||
Macro to change list box input range based on selection made in another cell | Excel Programming |