multiple condition

  • Thread starter Thread starter cape
  • Start date Start date
C

cape

if a:a = software and b:b = install (show 15.1 in d:d)
if a:a = software and b:b = uninstall(show 15.1 in d:d)
if a:a = user account and b:b = create (show 15.1 in d:d)
if a:a = user account and b:b = delete (show 4.4 in d:d)
i have 28 diffent combinations some will equal blank which is ok any help is much appreciated
TIA
 
I would probably use a select case macro to do this. It could be converted
to a function. From vbe HELP. Then look in the archives or use Ron DeBruin's
google search addin for more examples.
http://www.rondebruin.nl/

Select Case Statement Example
This example uses the Select Case statement to evaluate the value of a
variable. The second Case clause contains the value of the variable being
evaluated, and therefore only the statement associated with it is executed.

Dim Number
Number = 8 ' Initialize variable.
Select Case Number ' Evaluate Number.
Case 1 To 5 ' Number between 1 and 5, inclusive.
Debug.Print "Between 1 and 5"
' The following is the only Case clause that evaluates to True.
Case 6, 7, 8 ' Number between 6 and 8.
Debug.Print "Between 6 and 8"
Case 9 To 10 ' Number is 9 or 10.
Debug.Print "Greater than 8"
Case Else ' Other values.
Debug.Print "Not between 1 and 10"
End Select
 
if you already have this information compiled into a database format
you may be better off using the DGET -fx- . great stuff, in this case
the MS help file is actually pretty good on the explanation!!

not sure if it will apply to you or not, as not all details wer
specified.

HTH

-zac
 
Back
Top