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 |
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 |