select case help please

  • Thread starter Thread starter Christine Flott
  • Start date Start date
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
 
Christine,

Try something like

Select Case Target.Value
Case "2002Q1"
' code
Case "2002Q2"
' code
Case "2002Q3"
' code
....
Case Else
' code
End Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Select Case Sheets("Sheet1").Range("A1")

Case "2002Q1"
'Your code here
Case "2002Q4"
'Your code here
Case "2004Q3", "2002Q1" ' if both having same
calculation
' your code here
End Select


Abdul Salam
 
Thanks guys. I don't know what my problem was but it got it a few
minutes later. It looks like this:

Select Case ActiveCell.Offset(0, -4).Value
Case "2002Q1"
code
code
Case "2002Q2"
code
code...
Case Else
Msgbox "Please enter date in the correct format"

etc.

Thanks again for your assistance I think I needed to give up for a
while and go back to it later.

Christine
 
Christine,

Don't feel bad - it took me forever to understand how to put together one of
these. And I am just beginning to get the hang of it.

steve
 
Back
Top