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.
Important: This email and any attachments may contain confidential information subject to protection under the Federal Standards for Privacy of Individually Identifiable Health Information (45 C.F.R. Parts 160 and 164). If you or your organization is a “Covered Entity” under the above mentioned regulations, you are obligated to treat such information in a manner consistent with the regulations. If it appears that this email was sent to you in error, (1) you are prohibited from utilizing or disseminating this email or any attachments; (2) please immediately delete it from your computer and any servers or other locations where it might be stored, and email this sender or call the Hays Medical Center Privacy Officer at (785) 623-2188 advising that you have done so. We appreciate your cooperation.
