C
Christine Flott
Could someone please provide me the basics on the "select case"
statement? I am working on a Workbook_change procedure that performs
some calculations based on text that is entered into a target cell.
If the person types "2002Q1" the calculations performed are different
than if the person types in "2002Q4" or "2004Q3" etc. I only have one
test case written now for "2002Q1" but the calculations are performing
no matter what I type. Here's how I have started it, I intend to
create a case for each quarter from 2002 - 2008. Please advise! I have
a feeling I really don't understand the basic syntax of the Select
Case statement.
Select Case Quarter
Case ActiveCell.Offset(0, -4).Value = "2002Q1"
Many thanks,
Christine Flott
statement? I am working on a Workbook_change procedure that performs
some calculations based on text that is entered into a target cell.
If the person types "2002Q1" the calculations performed are different
than if the person types in "2002Q4" or "2004Q3" etc. I only have one
test case written now for "2002Q1" but the calculations are performing
no matter what I type. Here's how I have started it, I intend to
create a case for each quarter from 2002 - 2008. Please advise! I have
a feeling I really don't understand the basic syntax of the Select
Case statement.
Select Case Quarter
Case ActiveCell.Offset(0, -4).Value = "2002Q1"
Many thanks,
Christine Flott