I've heard of these CASE statements before but had no clue how they worked. It looks promising though. I will give it a try and let you know. Thanks for the help.
Reese Reese E. Walker Financial Systems Analyst Phoebe Putney Memorial Hospital Phone: (229) 312-4259 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Heather Castillo Sent: Monday, June 09, 2008 5:53 PM To: [email protected] Subject: RE: [Talk] VB Help Hi Reese, I am a big fan of the "case statement". It sounds like something you could use, but I am not sure how you're referencing your variables. An example of one I'm using right now: Dim checkCollAg as String checkCollAg = Trim(View(Row, Col, Length....)) ' gets name of collection agency Select Case checkCollAg 'look at the name of your variable Case "" ' if checkCollAg is blank then do the following ...keystrokes Case "PRH" ' if checkCollAg is = PRH then do the following ...keystrokes Case "ARSI" ' if checkCollAg is = ARSI then do the following ...fkdsjaf;ldksja;f Case Else ' if it doesn't match any of these then do the following (this is optional) Jfkdlsjf;dsa End Select I would think with this you could just add a new Case argument, but not sure. Hope this helps. -------------------------------------------------------------------- Heather Castillo HPMIN Analyst/Module Coordinator Information Systems Hays Medical Center 785.623.5084 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Reese Sent: Monday, June 09, 2008 3:49 PM To: [email protected] Subject: [Talk] VB Help Good Afternoon, Is there a way to set a bank or block of variables? For instance, instead of say F("V1") = "A", F("V2") = "B", F("V3") = "C".. and so on. Can you say something like F("bank1") = "A", "B", "C", "D". My script has a list of 9 different charges descriptions that it is searches. Every time I turn around, I have to add another and complete rewrite every IF statement. If I could use a bank, then I would only have to add it to one place. Is this even possible? Thanks, Reese Reese E. Walker Financial Systems Analyst Phoebe Putney Memorial Hospital Albany, GA. 31702 Phone: (229) 312-4259 Pager: (229) 431-7658 Fax: (229) 312-4316 ________________________________ Disclaimer: The HIPAA Final Privacy Rule requires covered entities to safeguard certain Protected Health Information (PHI) related to a person's healthcare. Information being faxed to you may include PHI after appropriate authorization from the patient or under circumstances that do not require patient authorization. You, the recipient, are obligated to maintain PHI in a safe and secure manner. You may not re-disclose without additional patient consent or as required by law. Unauthorized re-disclosure or failure to safeguard PHI could subject you to penalties described in federal (HIPAA) and state law. If you the reader of this message are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, please notify us immediately and destroy the related message.
