Case Select Statement issue - no errors, but doesn't "work".

[RNDinov8r]

I have written some code to look at different cases (still in progress), so it is meant to flag certain issues with dimensions that are outside of certain ranges. That said, when I comment out the code as seen below, and only run the four or five lines, it seems to work fine, but when I introduce the Select Case Process, it doesn't throw an error, it just seems to no run, or run, but not do anything. I know enough about VB and iLogic to be dangerous, as you can see here.

Dim WidWarn As String
Dim WidCalc As Double

'Select Case "ProuductShape"
' Case "Disc"
	WidCalc = PouchWid - MinPouchWid

	If WidCalc > (SealWid / 2) Then
		MessageBox.Show("Pouch Width Too Small", "Width Warning")
	Else
		MessageBox.Show("Pouch Width Acceptable", "Width Warning")
	End If	

'Case "Cylinder"
'	WidCalc = PouchWid - CylMinPouchWid
'
'	If WidCalc > SealWid / 2 Then
'		MessageBox.Show("Pouch Width Too Small", "Width Warning")
'	Else
'		MessageBox.Show("Pouch Width Acceptable", "Width Warning")
	'End If	
'Case "Plate"
'	MessageBox.Show("Pouch not Designed", "Width Warning")
'Case "Half Sphere"
'	If HalfShellTop > 20 deg Then
'		MessageBox.Show("Pouch Length is likely too Short", "Pouch Shape Warning")
'	End If
'	If HalfShellSide > 20 deg Then
'		MessageBox.Show("Pouch Width is likely too Narrow", "Pouch Shape Warning")
'	End If
'End Select

[JelteDeJong · Accepted solution]

after a select case i would expect a variable but in your case ther is a string "ProuductShape". now that case is compared with the strings of your cases "Disc", "Cylinder", "Plate" and "Half Sphere". that will never be true therefor none of your cases will evre be executed.

i expect that "ProuductShape" is a parameter. if so your select case statement should look something like:

Select Case ProuductShape

 notice that i left out the parentheses

[RNDinov8r]

That was it! a stupid syntax error. I even had another rule running a select Case argument, which I had written correctly, and never noticed the difference in Syntax.