Dim aChoices (0 to 4) As String
aChoices (0) = "100"
aChoices (1) = "200"
aChoices (2) = "300"
aChoices (3) = "700"
aChoices (4) = "900"
Selection = mworkspace.Prompt(PROMPT_OKCANCELLIST, "Select Batch Number", "Select Batch Number from the List", PROMPT_LISTMULT, aChoices (0), aChoices)
Das Befüllen des Arrays geht mit Split eleganter:
Dim aChoices As Variant
aChoices = Split( "100,200,300,700,900", ",")
...
Wobei, wenn ich mich richtig erinnere, gab es Split in R5 nicht :(
Hallo,
hier eine kleine Funktion als Splitersatz unter R5.
Public Function fktSplit(Byval strAusdruck As String, Byval strTrennz As String) As Variant
Dim strCmd As String
Dim vntReturn As Variant
strCmd = "@EXPLODE(" + Chr(34) + strAusdruck + Chr(34) + "; " + Chr(34) + strTrennz + Chr(34) +");"
vntReturn = Evaluate(strCmd)
fktSplit = vntReturn
End Function