Kod: Zaznacz cały
Sub ZmianaZakresuKombo(oEvC)
Dim ComboT as object
objC = oEvC.Source
sNameC = objC.Model.Name
oNameC = ThisComponent.NamedRanges.getByName(sNameC)
oCellC = oNameC.getReferredCells()
ComboS = objC.Model.Text
oCellC.setFormula(ComboS)
if sNameC like "Kombo_01" then
ComboT = ThisComponent.Sheets.getByIndex(0)
ComboT=ComboT.DrawPage.Forms.getByIndex(0).getByName("Kombo_02")
nCount=ComboT.ItemCount
if nCount>0 then
ComboT.removeItems( 0, nCount )
end if
Select Case ComboS
Case "Grupa 1"
sItems = Array( "Marka A-1", "Marka A-2", "Marka A-3")
Case "Grupa 2"
sItems = Array( "Marka B-1", "Marka B-2", "Marka B-3")
Case "Grupa 3"
sItems = Array( "Marka C-1", "Marka C-2", "Marka C-3")
Case else
'MsgBox "Błędny Wybór"
End Select
ComboT.addItems( sItems, 0 )
Endif
End Sub