listbox rowsource abhängig nach zellinhalt?
16.01.2004 14:05:24
soendi
If Teams_Fahrer!E2 = "" Then Formel_1.TeamMembers.RowSource = "Teams_Fahrer!E1"
If Teams_Fahrer!E2 <> "" Then Formel_1.TeamMembers.RowSource = "Teams_Fahrer!E2:E5"
' ListBox (TeamMembers)
If Teams_Fahrer!E2 = "" Then Formel_1.TeamMembers.RowSource = "Teams_Fahrer!E1" _
Else Formel_1.TeamMembers.RowSource = "Teams_Fahrer!E2:E5"