- Katılım
- 22 Temmuz 2014
- Mesajlar
- 42
- Excel Vers. ve Dili
- Excel 2007
Merhabalar
kendi ozel sekmeme asagidaki xml kodlariyla iki adet checkbox ekledim
( Microsoft Office icin Custom UI Editor ile )
Ve Bu checkboxlar asagidaki kodu calistiriyor :
Gordugunuz uzere gelen checkboxun id sini arastirip bulunan degerleri gosteriyor digerlerini gizliyor.
Yapmak istedigim ise bu iki checkbox"un beraber calismasi.
Yardimci olacaklara cok minnettar kalirim cok tesekkurler.
kendi ozel sekmeme asagidaki xml kodlariyla iki adet checkbox ekledim
( Microsoft Office icin Custom UI Editor ile )
Kod:
<checkBox id ="F16" label="F16" onAction="Show_Column" />
<checkBox id ="F20" label="F20" onAction="Show_Column" />
Kod:
Sub Show_Column(control As IRibbonControl, pressed As Boolean)
Dim strn As String
ActiveSheet.Cells.EntireColumn.Hidden = False
Range("B:ZZ").EntireColumn.Hidden = True
strn = control.id
Search strn, pressed
End If
End Sub
Sub Search(fnd As String, pressed As Boolean)
If pressed = True Then
Dim firstfound As String
Dim foundcell As Range,rng As Range
Dim myRange As Range, lastcell As Range
Set myRange = ActiveSheet.UsedRange
Set lastcell = myRange.Cells(myRange.Cells.Count)
Set foundcell = myRange.Find(what:=fnd, after:=lastcell)
If Not foundcell Is Nothing Then firstfound = foundcell.Address
End If
Set rng = foundcell
Do Until foundcell Is Nothing
Set foundcell = myRange.FindNext(after:=foundcell)
Set rng = Union(rng, foundcell)
If foundcell.Address = firstfound Then Exit Do
Loop
rng.EntireColumn.Hidden = False
Else
Exit Sub
End If
Yapmak istedigim ise bu iki checkbox"un beraber calismasi.
Yardimci olacaklara cok minnettar kalirim cok tesekkurler.
Son düzenleme: