724 |
Highlight the match once the filter is applied
' FilterChange event - Notifies your application that the filter is changed. Private Sub Tree1_FilterChange() With Tree1 format = .FormatABC("`lower(value) replace lower('` + value + `') with '<bgcolor 000000><fgcolor FFFFFF>` + value + `</fgcolor></bgcolor>'`",.FilterBarPromptPattern) .Columns.Item(0).FormatColumn = format .Columns.Item(1).FormatColumn = format .Columns.Item(2).FormatColumn = format End With End Sub With Tree1 .BeginUpdate .SelBackColor = .BackColor .SelForeColor = .ForeColor .ColumnAutoResize = True .ContinueColumnScroll = 0 .MarkSearchColumn = False .SearchColumnIndex = 1 .HeaderAppearance = 4 .HeaderHeight = 23 .BackColorLevelHeader = .BackColor .FilterBarCaption = "`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)" .FilterBarPromptVisible = 2055 ' FilterBarVisibleEnum.exFilterBarCompact Or FilterBarVisibleEnum.exFilterBarCaptionVisible Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible .FilterBarBackColor = .BackColor .FilterBarPromptPattern = "and" With .Columns With .Add("Name") .Def(17) = 1 .FormatColumn = "lower(value)" End With With .Add("Title") .Def(17) = 1 .FormatColumn = "lower(value)" End With With .Add("City") .Def(17) = 1 .FormatColumn = "lower(value)" End With End With With .Items h0 = .AddItem("Nancy Davolio") .CellCaption(h0,1) = "Sales Representative" .CellCaption(h0,2) = "Seattle" h0 = .AddItem("Andrew Fuller") .CellCaption(h0,1) = "Vice President, Sales" .CellCaption(h0,2) = "Tacoma" .SelectItem(h0) = 1 h0 = .AddItem("Janet Leverling") .CellCaption(h0,1) = "Sales Representative" .CellCaption(h0,2) = "Kirkland" h0 = .AddItem("Margaret Peacock") .CellCaption(h0,1) = "Sales Representative" .CellCaption(h0,2) = "Redmond" h0 = .AddItem("Steven Buchanan") .CellCaption(h0,1) = "Sales Manager" .CellCaption(h0,2) = "London" h0 = .AddItem("Michael Suyama") .CellCaption(h0,1) = "Sales Representative" .CellCaption(h0,2) = "London" h0 = .AddItem("Robert King") .CellCaption(h0,1) = "Sales Representative" .CellCaption(h0,2) = "London" h0 = .AddItem("Laura Callahan") .CellCaption(h0,1) = "Inside Sales Coordinator" .CellCaption(h0,2) = "Seattle" h0 = .AddItem("Anne Dodsworth") .CellCaption(h0,1) = "Sales Representative" .CellCaption(h0,2) = "London" End With .EndUpdate End With |
723 |
ADOR, MDB (JET)
With Tree1 .ColumnAutoResize = False .ContinueColumnScroll = False Set rs = CreateObject("ADOR.Recordset") With rs .Open "Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Exontrol\ExTree\Sample\Access\sample.mdb",3,3 End With .DataSource = rs End With |
722 |
Re-order the cell's caption, icons and images/pictures
With Tree1 .BeginUpdate .Images "gBJJgBAICAADAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEahkZAIAEEbjMjlErlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrlTiFdib/sNjr9gs1nldlrlqtFtt0stlguNvulyh91ud1vVVvNuvt7wFHr9/vl3luEwOJouIq+Dw2KyGRyWTymVy2XzGZzUuiw+lmej0gkUaksljaAnmD" & _ "cD/cEbf7w1+ufD/fEbeB028bYAO3enB6AB++4EoA4A4sb4vHjXJ4nG5vKAHA4ca6XBjTAD/Y2x/eB/jcB" With .Columns.Add("ToLeft") .Def(0) = True End With With .Columns.Add("ToRight") .Def(0) = True .Def(34) = "caption,picture,icons,icon,check" End With .DefaultItemHeight = 32 .DrawGridLines = 2 .HeaderAppearance = 4 With .Items h = .AddItem("Caption") .CellImage(h,0) = 2 .CellImages(h,0) = "1,2" .CellPicture(h,0) = Tree1.ExecuteTemplate("loadpicture(`gCJKBOI4NBQaBQAhQNJJIIhShQAEEREAIA0ROZ6PT0hQKYZpIZDKBJkIgKByN5mNJsMsKPABVqXBI4KjrD7HL6GWKPJKiCIhMiySidKxbOzZZJWMLs" & _ "GL2FqyLjZMonNa2CyiZDOUqsQqUEq0ZCNISFXDIFxzZ4hUrbdrefZ/fz3ZgzZ75Tz3XjvHZnZznPieb55AKgAqmRyOOzEhR7XirWaWQQMTa+QIhDbZOZAAoYUCPDAQG7" & _ "FXI4JRrNCoIRdPyyFr0AYifDUKZ+PCufK4RReALLUbtdBHSrGTCCNKqT4MbRqUxxQx+CAAEQ2VCBbxqGaLYDZNgzFbCbLDarRCrqMYMM6cWqpHKUDqhZjnVijEoLcp0F" & _ "CjVg2OYhTjN/QWk4bo4iseBsAcABIDoPA5g2HgADIkQfDCNxwkEQYnFmAIAB4OJHGcKAPioGRKFKdh2g6UB8iiZ5QkYQp3gKWhDlsWYmAARBcgCIAUniVpmiSA5AF3A4" & _ "wG8P41nGWwDDAW4MAAIpSG+bRzBoGx3AeCJhh6C4ljCUJGnSRBUFKAIQA6EgIHMWBoHqYgAngHJDCALBmhCCAfHOARAScUBvAmc5zHYXxoguXQ8DEMIAH8dI8HmP4/Ay" & _ "QJAEAYAoHqRByEQGJiECBAzAkKIpBYNIcikAp8kcZhDn4EBChmUoMgqHIqhiWoIgaDImgyVQImaRw/F0EZGCcSw3DaM4Kn6GBBhwYYZDGZo3C+RgOAmNQnhYeYqgsTZe" & _ "nEVgSFYLo2CydhGg4OROF2HJjlydR7i+cJjDGFo8BgHgVl4Po+DufJRgcbQOlkCxyKuCJNAsdwIhSC4mgieYKkeHJWD0Ih8BQaYYkkMYppwTg0EsFhJC0SxEkgeodDSF" & _ "pTheV5SDgLBIieRIigyVo5CeOpymoWhtEQfRACMR4zE2KxRnsV5dF2ehFCeC50G+GBkBiZgaCUGYnBySY+BsdIuEkJJJDSSRsjGeYqEWOhliYVYOHWDYbFuNhFmcS5si" & _ "qbZrnGLYOh0DpPhyXo7D8d4ZHGXR1CcdRAnsMh7GELwIHiSx7CiXY0HYNZ1nOcoPg0SB+CWLwwGqUpbFAQJwEeEImlCVQwk4cJxAiFRIhMS4ulGYRRlmMQVDEHZxG8Yx" & _ "XhIaQSniLhIiaGwnDiJZGicZYnjeZw8D6OoSkWEIthwI4emudwtGwepNhuLQ3F8Zojm4bQrhALo0D0HZwCcJwoimeI0ASWR6CAJkJQORfAiFcLIXgahaiGCgMsKIpw8D" & _ "PH8H4Pj2BhjrBMGQGYfxFjuEGIsB4rxbg+DSFsPAxBtChHoAQaYmRojVG0D0e6JALjVD2K0F4qxfjjGyPIRY/QXi1AOAILwFQGgOF8KYDwOgdBsHmCYcobRtjIHoGgZA" & _ "mBgi7HgPcWoHxTAmCQCcVwTgDB+FYJgfQMAOj0F2PoZgkRMjeKQLkWATwdDzEkPMF4FxzAXDGJYfAlgPAuB+FkeIWxuizC0LkUwvQbD9ByHIDouxvBCBgCMCAvh4CXCM" & _ "EgSA0BJDEH+AsfwMgfjhDeL0Ro/xkgvH4JMXA7RYjyAONgPAWhfjyCuBEcAFRSAWE4BIOwEAUgTCaIYfA4wSBUAcAsDowQOBFA4J0Hg9h2B4EmCQTYVBdB0FwIwU4rBy" & _ "jJGmHIRQ8gJAKB4IoZgShaDKAQOUIolQkjVBuGoSw6hugaFaJoeoWgajaDKDoO4dB5j0FcJ0Zw1Ang3CQDEdgNQnA6EmHgGw4QuCiCSAKFIXBgilEwGcLAZAtDmC0N0W" & _ "gLhaApFiK0HgfxniuGKP4GIvhrhhGgHEZgaRtB5GSBUcIhg5BnHkOAeQFB5A6DiEEao2xoDHH0KIQ4bxYBfFEP8RogB5BfA8AQHwvwqAZBIBURgCgwgPAqAkKYCgfgTH" & _ "CBwDIegcgjFUDQXQPQzA4DsCkDwnRABNAwE8OgTw5C6AkJEPgPRSg+DqCANoMRBjuHUKEJglQWDrHYOATg3BuDGDWEMa4CQbj3HMB0Z4Pw5jLFuCAWYsB/D2DgBEUQmB" & _ "1iuDEMkfI0hUCyEkPIfwihKgqGsGobIGhNhfFGGoZY6gDDuGWDceANA1A2DyDUM4txaA/EwG0bo0wTDXEcH8Sg/BcD2GSHQC4pgtiuGOOkNIRg3hbG+MIGYjhzgaBeHw" & _ "L4FgHAMAYFIfgJh4nJBQGkfAwRNiFAiO4KIlhoiKFiOoO4EwPiYGONUE4RATg6BOMcUwEApgZGmP4X4lxnjYGaLIZg7RNirH6FQG47xZCAC6OQLK5B1BYF8LgOQZAqh0" & _ "FqGcBo/xMhpE6HsXomQwBKCwIcfA6w/DxA+IURAIxwgmBSCMKoJgOhFD0JMeIkQdhREwFAEQKRFioAYKkJIqQlhpBYFEPYUQui0GCGgFI9BlCOAUDoS4nRhA7HOOkFYd" & _ "guhgEgGYUgZB2DeE6IIYIMQEgyAiPYHgYgnBlFiNsPYghKiODqISfddhPgVEOCQE4hg5iWHWPEfwfB3BgFYPkAIWQPAOC8BIb1MwrD+QsNEQ43ACAMAKGUQgsBhBoHCG" & _ "USNrxBBoEqNgGo8QMAJF+MMOwRxGCOFUBwHYdhODvDwMEBILgk21AKKkOI6RrgyD6LIDoJxNjkDUOQF4yAXgoC4FMXgqhKCiE4KACQow9D5CoJgLQiA9CwEMLUYwOxmh" & _ "AFaEAdoSwdBBF0CEPQEWWDrGOBoEgGhTAaDyBsPoNgXA4CmHIWw+guCDCSJsNIjxsgADcNQPg2hxC2FKLACo2hNDFEMMcKw/BeCcE6LYXoGRvDJGCN8GIxgUjYAyOUbg" & _ "6BpDrB0OYWw5AgjtGSOoEofAgjRG2NgY4+RRCfBeKUN4qQvi7H+HAYAchwCOCWAcQQZBBFiG4EIUYww3CFFuEQSgRAlBdDMIwCQiRrCMGCMcIwxhuiKDeE0PAlxCC8GF" & _ "ZQS4YhIgaEkJYS43hLAxE8EkTodQUBbBWMcHoNxy0lHqOETYyAeDeD4I0AQlRhD0G2E0O4PgKCjHeEoSgmBKCGEsBUS4vxUA8C6M0K4ox7irD+O0VouhfD7FUA33I+gm" & _ "iXE0IsLY1gtipG0CQbQLQPjFDuDQHw2RtjFGsK0bw4x9j0CcO8N4/RtBnhSgvAcBehmAOh0ANgiAhAnhih8gwh1gbhugRhSBRhDhjh2Bvgyhfh3gPhThOBIBOA6B9gsA" & _ "YAah+BdhlBWBtAuBoBThtB8gnhFheAlhcByh6BKhvAahNBnh5B1gJB1g+hCAsgAAbB1gOguAJhIAoAmhFBvqzACABh0BlgFggA6CaBvBQA7BDEHAaA0AABoAcgGBEACg" & _ "5AAgYgZgLAIBKgFBBhWh9AggCAIBoBNgAANA9AJhwABBxBwAKAYAAALCJu9ADAYAFBLExBEAiBEgmBEgxBEANBENbhmgJh5gJBNgJgzgJBfgRAvAhpKhnAQg5AIpkARA" & _ "SA/ASKGAPBJhZBIAdBJAbARh7n4BIhshkAnAZDVgkBZAUg5AWh5AVB5AEgFAbBFA4BFACglA5hlAfAVAChVAtBVAig1AQh1ABBNB+gaAcgUA7AqAbAWgTg2gfB2gSB9A" & _ "IBdA1BDh2BHAnBdAZg6Apgdh+h0g7lCBoAXh3BJBugahkBwBihkBkAsBYgtg/h7gNATBNgkhIgUhBg0gzI6BZgJRJglhvAvARgrAtBrALBbBFh2BxB2BZh9hFAcgOAcA" & _ "dAcgCgcBzhcAVB7h9g5BlgxhohsArgDh5A8heA8BKh8hMB8gzB8APgPBmAdByAShQAVgUAWMMAaAThuATgpAWhNASgLARB3ASAwg+AsEwhiAoimBTBxhUAJhEAJhVhJB" & _ "PhSBTBSBjgyhvBPlWAbgUgfhRhYBUAkAoBTAoBQgrgygfyhgTBShXBSgwhUh0hWgKhTguhQBphRAdhWAjhoBvg1gQA0g0A1AKACAehLgegzgrgmhcAmBahmB+A4AihzA" & _ "hhLA6ArAFBrAfAbAyhbAPh2hYB7BzB8AOBDgwhTg+hnALAXB8hXBph3AxAPA/BPA2gLg7A8hxg+AlAXANB9ARB+A6B+h5gBgEBAg9BLhFBBAUghAWAhANhhhsgRgBARB" & _ "vgjAUgiALhjBpBig8hjhHgSA1ASBqgvA4gkhzAmgkglhRgnB7hlh8BKA0hNgxhMBtg7guh5gjAzhPAtB/BJgBBmhhBvAdhDAighg7g2glAzBlg+AVhUAVAphVAHhqURA" & _ "Ghvh7g0AgAahvA2FigMg2BhhaBrg6AMAegTA6AVi5B6BlgehNgMgoA9gigMAZA/hBgMgGg+hfgbAvAegSgbApgegXhZhqBagzBYgogfgwB/Cwg7hgh/hDA/gTg5B+gNh" & _ "/gXh6B8hbh8B/hEhfASg2h/BHh6BfhZBbhuAjB/g9h7BbBth0h/gbh2Ayh/hAh+h/gnh/Ajh3AwgnA/gigPBzBPBVBegigfA1h8BPhshr1HgNhvAxB/hoBdgGgBhZh3s" & _ "UhMh0gmh1hLg9hIgchQB7BthugQh5hbgugth6BTgLi/ALBkocoPgCA/BQBfhmh+hXhzA/hzh+g7B1hbgch/heh4gvhEg3hsBfBOgbA2B9ArhrANhPTSKXAMg7A+Bhh4A" & _ "fgZh/AVhdg/hzB7BTBsgfh5B+gdhZh/g7oQBogSh/BMrPhUhYBshvheBfA9AThph7ANhvhNgog/hZBNg/hdhvgIAxhjB2hHBhhOBtg1gPBCg3hZBDAmhDg0gfhNhAg8x" & _ "MhgBiBvkig7BGgKBHBDBfBJhDBWhPg6BPxKAvBOBUhPB5hMhLhAh0mXBXAFhhB/A3hXBIhwB9AAgUBKg4AHA8AMgdgDhuB8hGghhcACgUAAgOA4AAA8AQABh2BQAegHA" & _ "2BOB9BYhxhrBAA/hfg7hah4BCBrAxgABkAdAcK4BtgsAshdhZCSAVglgFgbASgeB3AQAPhNhIFJ2TBnhahchDBBh9gQBogABSAlhhBUgbBLANBvA+hbh+gAgWBzB5BXB" & _ "WhFh/knAAADgLAkgiAggqAsAEhigrA1g2AKAqgKBfAZgdh9g2BbhugjhUgCgtgBALAtAYy+AWhEgmgAhFgSAaT4gAASgaATAahIgxACB9ghhGgfgmBoAEB4gIg/ANBag" & _ "xAkhGBRA0gs3yBaBjTNAFBCBFBghCACAJAlhFh+AAAEgCAQgQg+h2g7Bbhdgdgdhdhxh7gGvUhbBHhah/B5ATAzh3BOtAWchuh3hOA9h3XvAfgbh0hfh8Brg6hegDB9B" & _ "tnWDQByA4gkAGJIAZAEgcgFh8gvBJBSAdh0BLhqBLACAABHBtgwB2x8yngsg+gAByA2gAB8hxhvh6Byg+AFBp4nBShMgmBzANgAB8ACBZADARBLPVhQh7uKBOg/B7hqB" & _ "UgphbA+AfALAygQYohXBZi2AThYhcAeBPhAuwhdgIBEgiB7B9YzhDA0AvAthIBAg8AeBfApAohKA/B2BRA+BYm/gGBCguAG5JhAhjZLAgAvgvhPg1gYgehmAbgLZQhDA" & _ "jAjgjgOh5heAxzgABhx5Wgig0AfgQA/B13iBgBchVgrhXgVXFhbh9gKBdgugUAbXDgygsg+A/B+B8AqA6g6hahbBsANBmA/hCgmhegeSVgeADBwB+BKg+BnA0hwBxBih" & _ "Fh7BxBxAxAIgGACAiAYAMAKA/BPgnguAMgPBbBngak8B+hsgqAVBag2hnBOAoBWAJhYgsA2AchvAHhIEMAmgmAmAkAjhHgPB6hUBkhSAqApgpjehsBcgZhAhuAYBOBdA" & _ "uAXAwgpgPBMBwAOB5AjB+AeAYBwANACghgnBTgph3h0B0BMB4h91BgMAJhxAmgSByhshbajBaWPgTgCAYA4ACWGg3g/AyBfgzhnhPBxA1hrhXBshehChChRBQBQAgAeA" & _ "FBNAtg7h3hHB7h7B7A9BOgHBDgggfhrBEBHA+h9gRB+68hPAfg3huAoAzbAAiAGBZA7B2htAqB7hYgxgwhVgehOVIFFBRgchLhhgAA7BfBthdB9hkhkgkg0hyBlAKhBg" & _ "3ABAgAZBEg4AcBWAGYIhzgXAEgDA6gmhphwAtgRBYBmBwBwBQAThBA3gvBXn3hrBDBuBcA/BugnANgEBLhKhCgzhwYzhAAiARAohGgHgggJgMg9gMBrA4g+A6BoAUhch" & _ "ug3BBgAhZAIBPBNApAFAFAFh6hZBZAZAWhMgkAkBEgyApb1BOAqBGBIBmATAShAhsgOgHBuhxh4gsBOhph2ArAfBmBLCWgigxgOhZhshtAMBrghhDgHgjgfrIB5ABBCB" & _ "QAcAgV4gPhcgIBWhVhXgnhBApA4hVBXhngFhTLMgcgOhRgtAMh+hFh2h2gohnAsgshCg+rTAGgNhcgjgvwhAsA0BOA8gV4dBN8qBJh68rgUgoB2BdA6h5hTABhMgWAxh" & _ "Tg9A2guguhJBDB0g4B5hzBmsvhwgwgzgog4g4gDAmAygPBUhWAqANgbg3AmBAI2AOBzhDA8hmBKgxBIAFgAAJhbCuhGgKl7BwhwAmgcAKAigDh2gZAJArABANgDBegx5" & _ "WgZADgwBGBEAkBegAg2AYg9gwKABtBmhPABBoBZAPgFhHBMAPhmB/B6bdhZhdhdhth1hh8lBGgIBEAUgOhEgKgVgrA0AngaAaBiBIgyB5A3gLgXBcAEhlJjAJgEAsAJA" & _ "kgqqlhththThrhrhrBVBTAWhZhDhPhThIBWARg+Bn7Sg7A3gDhZAvAphEgegGgehuhpAJAyAJBZQ9gBggAAgAgwBDg3BCAAhkgTh0hkAAhLhthWhTgqAqhJBIAhhmAEg" & _ "qgqgCgbBiB6h9BD8zhxhmABrOhfAqhMg7ghwiA4BSJNhMgqg4BEhkY8AjBphNATBaA6AtAwBYgEACBBiEBABIAggbg7gmh1AlglAlgahXBmhmB1BgBPBEAmAnwZgogyh" & _ "VgmgABcgxsNBUAWAAB2B4AHBvA5h3B3ggAQBIAwg+hPhSgqBQCEA/gQBQA2htKUgfAJhFgkhkAYBtAIAMHpgbAasHg0gVAsBhhIgbBVAxAi/MgFBnAZBDBpB2ABgwADB" & _ "Wh3gchuBwBxhrhkB1BbhWAFAP5mBCghgTgnA8AgBV+OgqhSg2g1g3AnBOAcg+hNAYgbhHBRg8g6BjhjhjA2ADgdAdhTg/Aeg/hvA6h1h7A2gChLhKfjAdAxhahigYgMA" & _ "GAshzg5AAaYh/AGAjh2AChABwBOgwXnBFh/ApAzgT2GBZBGvTBHAjBGhAF0wAgsDi1w4Nza2UkyBUYiA+maxm6g1K32ad3s2Qg8AKlRaBlKD1wKE+rCCjSObAK8iGsFO" & _ "rC0vR0lTeDV8IUatHu6GO2jkAHgAwgfgC5TYrVsKk2Y3MBRcpBQkgmOUuznY2FqKy0WSymXeX0ASwel0olHI5AwJ1mx0gL1mTXU6XS8Vpdj4hyg8BemDYZHqMFOUyYZT" & _ "WP1WJ1CN1MTR6gH4cmysjKr2mlCqn3GuR+jDoJHGWlKkU+ajXpgg1yq2FQDFigSEBROwkCKnQwGwjliIU45x2HGyIB4dnM0UmUC+PhaLxefwOdia5zMT3+8wwYCQmEwd" & _ "i4vQKqHKvigKHoKnc9Rs7GMDUOhhGOnAYjWkzKKRGyxsDUA01QCw0QCOF0uh0OkfRUMMbyRNwTBiCYZwKMIYyZAUkSlBYkxsCYAAHG4qwCBwMQfBYlxsNgsDhLEgwHA8" & _ "PiPNg1ygP4uywIgMSwK4zSQG46BnFAATDJcL3IHM6DQBsPR3O83j/AsJyGH8w4ZJY5TsN8EAdFojTwJ0AAoA4MgATIMDqAcrQPMEwTDBgVy0LYtiuK8qyrFs6QtCocnL" & _ "Cs8wAGAChOGM+CZJ0HAaoQHQYocBiaHtJT3LEfgCLYIgQNYgw4IQiSaBcAABBEAB/DAXS4HgPAgLUSCzGkPjkIATyXPQoCeNYfR6Do7QGI8Zj+CAHiyCY2SkIQTSSCIy" & _ "DQCkpDBJQJinMMuAUPgOxGOcpA/AkoTzJwyiYFMiDwJEsShFAURFCwJRVFceQXKQIS8P8STlBgLggAcrAQCQATjIgZA0JgVSxL0OAmKI6CpEc4SuOkeBeOwMRnLQuQhO" & _ "ApDJAImYmD44BPIgAzFMYiR3LcQw4JwqhQAknAMFAxwEEwJwUO4ljCHgmxzNwNQ3EU3ScLYEAACocDePwZgCLI+yFN8jg7FEQTtKMcwrAAOhgHw6SQI4OCmJgjDmNAjj" & _ "5Gw+wbHkkTpEw7gpFgIAA2sABJEUThEK4QhgIJAQ==`)") .CellCaption(h,1) = .CellCaption(h,0) .CellHAlignment(h,1) = 2 .CellImage(h,1) = .CellImage(h,0) .CellImages(h,1) = "2,1" .CellPicture(h,1) = .CellPicture(h,0) h = .AddItem("<b>HTML</b> <off 4>Caption") .CellCaptionFormat(h,0) = 1 .CellImage(h,0) = 2 .CellImages(h,0) = "1,2" .CellPicture(h,0) = Tree1.ExecuteTemplate("loadpicture(`gCJKBOI4NBQaBQAhQNJJIIhShQAEEREAIA0ROZ6PT0hQKYZpIZDKBJkIgKByN5mNJsMsKPABVqXBI4KjrD7HL6GWKPJKiCIhMiySidKxbOzZZJWMLs" & _ "GL2FqyLjZMonNa2CyiZDOUqsQqUEq0ZCNISFXDIFxzZ4hUrbdrefZ/fz3ZgzZ75Tz3XjvHZnZznPieb55AKgAqmRyOOzEhR7XirWaWQQMTa+QIhDbZOZAAoYUCPDAQG7" & _ "FXI4JRrNCoIRdPyyFr0AYifDUKZ+PCufK4RReALLUbtdBHSrGTCCNKqT4MbRqUxxQx+CAAEQ2VCBbxqGaLYDZNgzFbCbLDarRCrqMYMM6cWqpHKUDqhZjnVijEoLcp0F" & _ "CjVg2OYhTjN/QWk4bo4iseBsAcABIDoPA5g2HgADIkQfDCNxwkEQYnFmAIAB4OJHGcKAPioGRKFKdh2g6UB8iiZ5QkYQp3gKWhDlsWYmAARBcgCIAUniVpmiSA5AF3A4" & _ "wG8P41nGWwDDAW4MAAIpSG+bRzBoGx3AeCJhh6C4ljCUJGnSRBUFKAIQA6EgIHMWBoHqYgAngHJDCALBmhCCAfHOARAScUBvAmc5zHYXxoguXQ8DEMIAH8dI8HmP4/Ay" & _ "QJAEAYAoHqRByEQGJiECBAzAkKIpBYNIcikAp8kcZhDn4EBChmUoMgqHIqhiWoIgaDImgyVQImaRw/F0EZGCcSw3DaM4Kn6GBBhwYYZDGZo3C+RgOAmNQnhYeYqgsTZe" & _ "nEVgSFYLo2CydhGg4OROF2HJjlydR7i+cJjDGFo8BgHgVl4Po+DufJRgcbQOlkCxyKuCJNAsdwIhSC4mgieYKkeHJWD0Ih8BQaYYkkMYppwTg0EsFhJC0SxEkgeodDSF" & _ "pTheV5SDgLBIieRIigyVo5CeOpymoWhtEQfRACMR4zE2KxRnsV5dF2ehFCeC50G+GBkBiZgaCUGYnBySY+BsdIuEkJJJDSSRsjGeYqEWOhliYVYOHWDYbFuNhFmcS5si" & _ "qbZrnGLYOh0DpPhyXo7D8d4ZHGXR1CcdRAnsMh7GELwIHiSx7CiXY0HYNZ1nOcoPg0SB+CWLwwGqUpbFAQJwEeEImlCVQwk4cJxAiFRIhMS4ulGYRRlmMQVDEHZxG8Yx" & _ "XhIaQSniLhIiaGwnDiJZGicZYnjeZw8D6OoSkWEIthwI4emudwtGwepNhuLQ3F8Zojm4bQrhALo0D0HZwCcJwoimeI0ASWR6CAJkJQORfAiFcLIXgahaiGCgMsKIpw8D" & _ "PH8H4Pj2BhjrBMGQGYfxFjuEGIsB4rxbg+DSFsPAxBtChHoAQaYmRojVG0D0e6JALjVD2K0F4qxfjjGyPIRY/QXi1AOAILwFQGgOF8KYDwOgdBsHmCYcobRtjIHoGgZA" & _ "mBgi7HgPcWoHxTAmCQCcVwTgDB+FYJgfQMAOj0F2PoZgkRMjeKQLkWATwdDzEkPMF4FxzAXDGJYfAlgPAuB+FkeIWxuizC0LkUwvQbD9ByHIDouxvBCBgCMCAvh4CXCM" & _ "EgSA0BJDEH+AsfwMgfjhDeL0Ro/xkgvH4JMXA7RYjyAONgPAWhfjyCuBEcAFRSAWE4BIOwEAUgTCaIYfA4wSBUAcAsDowQOBFA4J0Hg9h2B4EmCQTYVBdB0FwIwU4rBy" & _ "jJGmHIRQ8gJAKB4IoZgShaDKAQOUIolQkjVBuGoSw6hugaFaJoeoWgajaDKDoO4dB5j0FcJ0Zw1Ang3CQDEdgNQnA6EmHgGw4QuCiCSAKFIXBgilEwGcLAZAtDmC0N0W" & _ "gLhaApFiK0HgfxniuGKP4GIvhrhhGgHEZgaRtB5GSBUcIhg5BnHkOAeQFB5A6DiEEao2xoDHH0KIQ4bxYBfFEP8RogB5BfA8AQHwvwqAZBIBURgCgwgPAqAkKYCgfgTH" & _ "CBwDIegcgjFUDQXQPQzA4DsCkDwnRABNAwE8OgTw5C6AkJEPgPRSg+DqCANoMRBjuHUKEJglQWDrHYOATg3BuDGDWEMa4CQbj3HMB0Z4Pw5jLFuCAWYsB/D2DgBEUQmB" & _ "1iuDEMkfI0hUCyEkPIfwihKgqGsGobIGhNhfFGGoZY6gDDuGWDceANA1A2DyDUM4txaA/EwG0bo0wTDXEcH8Sg/BcD2GSHQC4pgtiuGOOkNIRg3hbG+MIGYjhzgaBeHw" & _ "L4FgHAMAYFIfgJh4nJBQGkfAwRNiFAiO4KIlhoiKFiOoO4EwPiYGONUE4RATg6BOMcUwEApgZGmP4X4lxnjYGaLIZg7RNirH6FQG47xZCAC6OQLK5B1BYF8LgOQZAqh0" & _ "FqGcBo/xMhpE6HsXomQwBKCwIcfA6w/DxA+IURAIxwgmBSCMKoJgOhFD0JMeIkQdhREwFAEQKRFioAYKkJIqQlhpBYFEPYUQui0GCGgFI9BlCOAUDoS4nRhA7HOOkFYd" & _ "guhgEgGYUgZB2DeE6IIYIMQEgyAiPYHgYgnBlFiNsPYghKiODqISfddhPgVEOCQE4hg5iWHWPEfwfB3BgFYPkAIWQPAOC8BIb1MwrD+QsNEQ43ACAMAKGUQgsBhBoHCG" & _ "USNrxBBoEqNgGo8QMAJF+MMOwRxGCOFUBwHYdhODvDwMEBILgk21AKKkOI6RrgyD6LIDoJxNjkDUOQF4yAXgoC4FMXgqhKCiE4KACQow9D5CoJgLQiA9CwEMLUYwOxmh" & _ "AFaEAdoSwdBBF0CEPQEWWDrGOBoEgGhTAaDyBsPoNgXA4CmHIWw+guCDCSJsNIjxsgADcNQPg2hxC2FKLACo2hNDFEMMcKw/BeCcE6LYXoGRvDJGCN8GIxgUjYAyOUbg" & _ "6BpDrB0OYWw5AgjtGSOoEofAgjRG2NgY4+RRCfBeKUN4qQvi7H+HAYAchwCOCWAcQQZBBFiG4EIUYww3CFFuEQSgRAlBdDMIwCQiRrCMGCMcIwxhuiKDeE0PAlxCC8GF" & _ "ZQS4YhIgaEkJYS43hLAxE8EkTodQUBbBWMcHoNxy0lHqOETYyAeDeD4I0AQlRhD0G2E0O4PgKCjHeEoSgmBKCGEsBUS4vxUA8C6M0K4ox7irD+O0VouhfD7FUA33I+gm" & _ "iXE0IsLY1gtipG0CQbQLQPjFDuDQHw2RtjFGsK0bw4x9j0CcO8N4/RtBnhSgvAcBehmAOh0ANgiAhAnhih8gwh1gbhugRhSBRhDhjh2Bvgyhfh3gPhThOBIBOA6B9gsA" & _ "YAah+BdhlBWBtAuBoBThtB8gnhFheAlhcByh6BKhvAahNBnh5B1gJB1g+hCAsgAAbB1gOguAJhIAoAmhFBvqzACABh0BlgFggA6CaBvBQA7BDEHAaA0AABoAcgGBEACg" & _ "5AAgYgZgLAIBKgFBBhWh9AggCAIBoBNgAANA9AJhwABBxBwAKAYAAALCJu9ADAYAFBLExBEAiBEgmBEgxBEANBENbhmgJh5gJBNgJgzgJBfgRAvAhpKhnAQg5AIpkARA" & _ "SA/ASKGAPBJhZBIAdBJAbARh7n4BIhshkAnAZDVgkBZAUg5AWh5AVB5AEgFAbBFA4BFACglA5hlAfAVAChVAtBVAig1AQh1ABBNB+gaAcgUA7AqAbAWgTg2gfB2gSB9A" & _ "IBdA1BDh2BHAnBdAZg6Apgdh+h0g7lCBoAXh3BJBugahkBwBihkBkAsBYgtg/h7gNATBNgkhIgUhBg0gzI6BZgJRJglhvAvARgrAtBrALBbBFh2BxB2BZh9hFAcgOAcA" & _ "dAcgCgcBzhcAVB7h9g5BlgxhohsArgDh5A8heA8BKh8hMB8gzB8APgPBmAdByAShQAVgUAWMMAaAThuATgpAWhNASgLARB3ASAwg+AsEwhiAoimBTBxhUAJhEAJhVhJB" & _ "PhSBTBSBjgyhvBPlWAbgUgfhRhYBUAkAoBTAoBQgrgygfyhgTBShXBSgwhUh0hWgKhTguhQBphRAdhWAjhoBvg1gQA0g0A1AKACAehLgegzgrgmhcAmBahmB+A4AihzA" & _ "hhLA6ArAFBrAfAbAyhbAPh2hYB7BzB8AOBDgwhTg+hnALAXB8hXBph3AxAPA/BPA2gLg7A8hxg+AlAXANB9ARB+A6B+h5gBgEBAg9BLhFBBAUghAWAhANhhhsgRgBARB" & _ "vgjAUgiALhjBpBig8hjhHgSA1ASBqgvA4gkhzAmgkglhRgnB7hlh8BKA0hNgxhMBtg7guh5gjAzhPAtB/BJgBBmhhBvAdhDAighg7g2glAzBlg+AVhUAVAphVAHhqURA" & _ "Ghvh7g0AgAahvA2FigMg2BhhaBrg6AMAegTA6AVi5B6BlgehNgMgoA9gigMAZA/hBgMgGg+hfgbAvAegSgbApgegXhZhqBagzBYgogfgwB/Cwg7hgh/hDA/gTg5B+gNh" & _ "/gXh6B8hbh8B/hEhfASg2h/BHh6BfhZBbhuAjB/g9h7BbBth0h/gbh2Ayh/hAh+h/gnh/Ajh3AwgnA/gigPBzBPBVBegigfA1h8BPhshr1HgNhvAxB/hoBdgGgBhZh3s" & _ "UhMh0gmh1hLg9hIgchQB7BthugQh5hbgugth6BTgLi/ALBkocoPgCA/BQBfhmh+hXhzA/hzh+g7B1hbgch/heh4gvhEg3hsBfBOgbA2B9ArhrANhPTSKXAMg7A+Bhh4A" & _ "fgZh/AVhdg/hzB7BTBsgfh5B+gdhZh/g7oQBogSh/BMrPhUhYBshvheBfA9AThph7ANhvhNgog/hZBNg/hdhvgIAxhjB2hHBhhOBtg1gPBCg3hZBDAmhDg0gfhNhAg8x" & _ "MhgBiBvkig7BGgKBHBDBfBJhDBWhPg6BPxKAvBOBUhPB5hMhLhAh0mXBXAFhhB/A3hXBIhwB9AAgUBKg4AHA8AMgdgDhuB8hGghhcACgUAAgOA4AAA8AQABh2BQAegHA" & _ "2BOB9BYhxhrBAA/hfg7hah4BCBrAxgABkAdAcK4BtgsAshdhZCSAVglgFgbASgeB3AQAPhNhIFJ2TBnhahchDBBh9gQBogABSAlhhBUgbBLANBvA+hbh+gAgWBzB5BXB" & _ "WhFh/knAAADgLAkgiAggqAsAEhigrA1g2AKAqgKBfAZgdh9g2BbhugjhUgCgtgBALAtAYy+AWhEgmgAhFgSAaT4gAASgaATAahIgxACB9ghhGgfgmBoAEB4gIg/ANBag" & _ "xAkhGBRA0gs3yBaBjTNAFBCBFBghCACAJAlhFh+AAAEgCAQgQg+h2g7Bbhdgdgdhdhxh7gGvUhbBHhah/B5ATAzh3BOtAWchuh3hOA9h3XvAfgbh0hfh8Brg6hegDB9B" & _ "tnWDQByA4gkAGJIAZAEgcgFh8gvBJBSAdh0BLhqBLACAABHBtgwB2x8yngsg+gAByA2gAB8hxhvh6Byg+AFBp4nBShMgmBzANgAB8ACBZADARBLPVhQh7uKBOg/B7hqB" & _ "UgphbA+AfALAygQYohXBZi2AThYhcAeBPhAuwhdgIBEgiB7B9YzhDA0AvAthIBAg8AeBfApAohKA/B2BRA+BYm/gGBCguAG5JhAhjZLAgAvgvhPg1gYgehmAbgLZQhDA" & _ "jAjgjgOh5heAxzgABhx5Wgig0AfgQA/B13iBgBchVgrhXgVXFhbh9gKBdgugUAbXDgygsg+A/B+B8AqA6g6hahbBsANBmA/hCgmhegeSVgeADBwB+BKg+BnA0hwBxBih" & _ "Fh7BxBxAxAIgGACAiAYAMAKA/BPgnguAMgPBbBngak8B+hsgqAVBag2hnBOAoBWAJhYgsA2AchvAHhIEMAmgmAmAkAjhHgPB6hUBkhSAqApgpjehsBcgZhAhuAYBOBdA" & _ "uAXAwgpgPBMBwAOB5AjB+AeAYBwANACghgnBTgph3h0B0BMB4h91BgMAJhxAmgSByhshbajBaWPgTgCAYA4ACWGg3g/AyBfgzhnhPBxA1hrhXBshehChChRBQBQAgAeA" & _ "FBNAtg7h3hHB7h7B7A9BOgHBDgggfhrBEBHA+h9gRB+68hPAfg3huAoAzbAAiAGBZA7B2htAqB7hYgxgwhVgehOVIFFBRgchLhhgAA7BfBthdB9hkhkgkg0hyBlAKhBg" & _ "3ABAgAZBEg4AcBWAGYIhzgXAEgDA6gmhphwAtgRBYBmBwBwBQAThBA3gvBXn3hrBDBuBcA/BugnANgEBLhKhCgzhwYzhAAiARAohGgHgggJgMg9gMBrA4g+A6BoAUhch" & _ "ug3BBgAhZAIBPBNApAFAFAFh6hZBZAZAWhMgkAkBEgyApb1BOAqBGBIBmATAShAhsgOgHBuhxh4gsBOhph2ArAfBmBLCWgigxgOhZhshtAMBrghhDgHgjgfrIB5ABBCB" & _ "QAcAgV4gPhcgIBWhVhXgnhBApA4hVBXhngFhTLMgcgOhRgtAMh+hFh2h2gohnAsgshCg+rTAGgNhcgjgvwhAsA0BOA8gV4dBN8qBJh68rgUgoB2BdA6h5hTABhMgWAxh" & _ "Tg9A2guguhJBDB0g4B5hzBmsvhwgwgzgog4g4gDAmAygPBUhWAqANgbg3AmBAI2AOBzhDA8hmBKgxBIAFgAAJhbCuhGgKl7BwhwAmgcAKAigDh2gZAJArABANgDBegx5" & _ "WgZADgwBGBEAkBegAg2AYg9gwKABtBmhPABBoBZAPgFhHBMAPhmB/B6bdhZhdhdhth1hh8lBGgIBEAUgOhEgKgVgrA0AngaAaBiBIgyB5A3gLgXBcAEhlJjAJgEAsAJA" & _ "kgqqlhththThrhrhrBVBTAWhZhDhPhThIBWARg+Bn7Sg7A3gDhZAvAphEgegGgehuhpAJAyAJBZQ9gBggAAgAgwBDg3BCAAhkgTh0hkAAhLhthWhTgqAqhJBIAhhmAEg" & _ "qgqgCgbBiB6h9BD8zhxhmABrOhfAqhMg7ghwiA4BSJNhMgqg4BEhkY8AjBphNATBaA6AtAwBYgEACBBiEBABIAggbg7gmh1AlglAlgahXBmhmB1BgBPBEAmAnwZgogyh" & _ "VgmgABcgxsNBUAWAAB2B4AHBvA5h3B3ggAQBIAwg+hPhSgqBQCEA/gQBQA2htKUgfAJhFgkhkAYBtAIAMHpgbAasHg0gVAsBhhIgbBVAxAi/MgFBnAZBDBpB2ABgwADB" & _ "Wh3gchuBwBxhrhkB1BbhWAFAP5mBCghgTgnA8AgBV+OgqhSg2g1g3AnBOAcg+hNAYgbhHBRg8g6BjhjhjA2ADgdAdhTg/Aeg/hvA6h1h7A2gChLhKfjAdAxhahigYgMA" & _ "GAshzg5AAaYh/AGAjh2AChABwBOgwXnBFh/ApAzgT2GBZBGvTBHAjBGhAF0wAgsDi1w4Nza2UkyBUYiA+maxm6g1K32ad3s2Qg8AKlRaBlKD1wKE+rCCjSObAK8iGsFO" & _ "rC0vR0lTeDV8IUatHu6GO2jkAHgAwgfgC5TYrVsKk2Y3MBRcpBQkgmOUuznY2FqKy0WSymXeX0ASwel0olHI5AwJ1mx0gL1mTXU6XS8Vpdj4hyg8BemDYZHqMFOUyYZT" & _ "WP1WJ1CN1MTR6gH4cmysjKr2mlCqn3GuR+jDoJHGWlKkU+ajXpgg1yq2FQDFigSEBROwkCKnQwGwjliIU45x2HGyIB4dnM0UmUC+PhaLxefwOdia5zMT3+8wwYCQmEwd" & _ "i4vQKqHKvigKHoKnc9Rs7GMDUOhhGOnAYjWkzKKRGyxsDUA01QCw0QCOF0uh0OkfRUMMbyRNwTBiCYZwKMIYyZAUkSlBYkxsCYAAHG4qwCBwMQfBYlxsNgsDhLEgwHA8" & _ "PiPNg1ygP4uywIgMSwK4zSQG46BnFAATDJcL3IHM6DQBsPR3O83j/AsJyGH8w4ZJY5TsN8EAdFojTwJ0AAoA4MgATIMDqAcrQPMEwTDBgVy0LYtiuK8qyrFs6QtCocnL" & _ "Cs8wAGAChOGM+CZJ0HAaoQHQYocBiaHtJT3LEfgCLYIgQNYgw4IQiSaBcAABBEAB/DAXS4HgPAgLUSCzGkPjkIATyXPQoCeNYfR6Do7QGI8Zj+CAHiyCY2SkIQTSSCIy" & _ "DQCkpDBJQJinMMuAUPgOxGOcpA/AkoTzJwyiYFMiDwJEsShFAURFCwJRVFceQXKQIS8P8STlBgLggAcrAQCQATjIgZA0JgVSxL0OAmKI6CpEc4SuOkeBeOwMRnLQuQhO" & _ "ApDJAImYmD44BPIgAzFMYiR3LcQw4JwqhQAknAMFAxwEEwJwUO4ljCHgmxzNwNQ3EU3ScLYEAACocDePwZgCLI+yFN8jg7FEQTtKMcwrAAOhgHw6SQI4OCmJgjDmNAjj" & _ "5Gw+wbHkkTpEw7gpFgIAA2sABJEUThEK4QhgIJAQ==`)") .CellCaption(h,1) = .CellCaption(h,0) .CellCaptionFormat(h,1) = 1 .CellHAlignment(h,1) = 2 .CellImage(h,1) = .CellImage(h,0) .CellImages(h,1) = "2,1" .CellPicture(h,1) = .CellPicture(h,0) End With .EndUpdate End With |
721 |
ImageSize property on 32 (specifies the size of control' icons/images/check-boxes/radio-buttons)
' AddColumn event - Fired after a new column has been added. Private Sub Tree1_AddColumn(ByVal Column As Object) ' Column.Def(48) = 2 ' Column.Def(49) = 2 End Sub With Tree1 .BeginUpdate .ImageSize = 32 .DefaultItemHeight = 36 .HeaderHeight = .DefaultItemHeight .SortBarHeight = .DefaultItemHeight .Font.Size = 16 .FilterBarFont.Size = Tree1.Font.Size .ToolTipFont.Size = Tree1.Font.Size .Indent = 26 .Images "gBJJgBAIDAAEg4AEEKAD/hz/EMNh8TIRNGwAjEZAEXjAojKAjMLjABhkaABAk0plUrlktl0vmExmUzmk1m03nE5nU7nk9miAoE+oVDolFo1HpFJpU5h8Sf9OqFNqUOq" & _ "NUqdPq9VrFWrlbr1QpdhAFAkFis1ntFptVrtkrpszrNvmVxqk3uVtm1kmF3sdBvF/wGBmV+j9BYGHwWJulfxdax2NyFdx2JlV6l9Nw7AAGZymdz2Cy2GxErvWcz9ivlw" & _ "yV21cuxugwktzGIzmvwtl0+53U5y0a0Wazmmyu/3dCyOMyXHx/J5nIr9q3uyqnBxFN3G46ma4vb7mD2Ng4nZze00fDkHC7t7us2rOX5tguetpHRlmz4HVqnXk1PjHO+C" & _ "MPo9MBMC+j2vC8j7wS8cFNI4kBo05UIvfCT/NsnsApU+0Fqg/T+oy/kPxC0sEQfErKQK96+w28UWRI8UGvO8sTLS9r2PWmsMJTDTask3CsIbIEQRA3shOXEEAO/GclJ9" & _ "FEKrrA8FRbKMXRIlb0JxCkjS1LMswhCcvuel0cv26cSMa8Ufx+2sQwhEUoSXOCjSbLcnxjKc7sdKUVyq28NtVI71P9P7JxtQEapjQ6fzfM8zPfNE2PhIsLL63E40slk5" & _ "y7N89LcyU9SvMb3SdUc6VJLj5VLVLfO/PS9KzNFHUa/0XyBD0dxlS9cxhMlTRSoNXypPErWDPyfNS+MwprRNO0FD8wVVZ1AI08URwVRjtJ1WCn21QkkUrXVLVPQS/XIk" & _ "FgTxT9iONZ9xVTdq+L1eKg3kkF6Upe68XtfV51/MtrVjBlwYFL1ev8y1/P6/lyzzYl02wntj0RVFmS1Qa+M5as93QxEUW9e993rfmQ2+vy65M/mL1lhl/2bj2ByVduMt" & _ "NhCJT9hdz41nN14Ld12Z9UjfI/oUAaGseiw6+uFLLhcVabJOS5RqOE0BHlZ5VnEr5fOMs3st+aa/bbRzrJGV51Y0b0DbqaWXZD90hIsPbjWu52+6Wyadpe66hhO+P/Xi" & _ "oW5rD8ZbrUZuVg6n1dsE/cXmewu1m9PVwnd35/nueXho/NaJzmjc61W76esuT77eG8pTquy9TwWH8LEzG8RDfFalx3Gcfvna9rvG/cptGLd9tuI6TZOP5Fiqi99vea+X" & _ "4VRcBq/JZZtVQ9cwSs5lsXE372+a9z7PbfB3VVqHyvMctLto8uob6eV0m/cD6MN2v+T33t6sBut42vdv2bJ8a997x2maFJfK+qArbGJPEKE+1qTflMsIdW/GCJX17KcT" & _ "6/czr/X+u1g29B7j/4BQfWkkx4zIHisjhPCmE0K4SwtXM+d4BvHRwNZOoBph9IJvPek9d40FoMJxf691jj2ywQQcHEWET4XJwkTszlVqm2GokewxtBT1DpQjRxDN0rUV" & _ "DNKdC3lb6tzNOwh6upMSSYfv4YBCl/bsn9PxiFCEo7SI6Obc9HeOrnY8x4jtHtdpN4GRbaorhsbu18Pph5CiHymI0RpSXGJ/z2oUOxYxG858AyiI+bfJtuTcG5yelBJy" & _ "T8okhqFd4a5yxL0rvulYtKCsZiWxWkc1s1cRoxxwhA31DLE0mR9l9HqX8fJgTDmFMVH0MIsRzVYnwnMi1dyzmhLt2kS2pxIiU62Wj5ptQGlSYFakLonTUJNLKaM5Wzlf" & _ "fEkuFkk5wTrhVO2eE7G6lJhxFFYUZ55zmn0WuBCD4pzhirFCKkbomsOoIYmZx5p90LoYWGPdD5g0QmJRKYxbZ6zYoVQ2jVGylSak7KSkFH6RSjpHKFuU+YMyNo5SulkC" & _ "6I0vonTCitMXPoEpVS2H5FQfEqp2R1opIgAEkJISYARTCukOhmPNI5Ex/wzGHUsicMwA1LHgQ90Y/KpoQHAD+pB/R4NzIaMAB9Xaw1gqaAOsh/A/ptIkWUfhGK1kZH8R" & _ "gH5GqvgArqRmt4AAPrTroRofBGADkqr6Rmu4D7CEaHARiwpJrEEZsXXwlVjyMWRsaRqwdkLGNBABZmytmyMnaINZqyVpLR2ftKAAAdd6h2osbaskdiq4EZtgSmyNcbVW" & _ "RJNXe3AA7REar3b0stlAAXBtoRmvJGLjEYAHUWsFcwCD/rnaop9aEICMAPdK5hT6xpeuzdOtAgKuJeGfdq6ggEbkTvAP+p9UCHXrvKkcgIA==" With .VisualAppearance .Add 1,"gBFLBCJwBAEHhEJAAEhABfICg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj" & _ "6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" & _ "MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsOatVqjG5sYjcGC3La9cz3Pq/bpuDCbMxuaK1TrYXr1TTrcofBDldAxXRKDx" & _ "RDWVhLnYOw9i6XxzjuXprCaOoKB6EwbiCZZCGOdZYlcT4xHmbhMnwNxtn+G5bmqdZ7n4Pw/i+X5zm+dQ9g4CAFjsfAJheOI8HsDoWDWTB/lwSAQkmA5PEgRYoDyDwYFY" & _ "FoFmGCBmBqBphDgRJ0gOTIYBGRB/lyRh0iSCZbjYWJzgWDwIjYLoLmMCJGDKDJjBgWgqG6YhyhGHRzA2aJ1mCABOAiOJvhCZBJBYRoRmSCQmEqEQimkAZgg8TZnDCV4U" & _ "kmCUmBKZYJGYWoWCUUhiFMNZckNUh2GENoaGaGZmgmJhqhqZpGGIEx2GYIxSGGGJdggWJth2Z4JmYeoemeSZ2H6H4hGmQhihyTRHGYLg7CiCgmgqIpokoNoOiOaJ4jqA" & _ "ochqaZGgaCxpAoZoaiaaJqEmWIcGgShcnCJwqEqFoR3YOoFlgchflqNouiuawHmWSYqGkWZQhcatzmaOoumuSp2j6L5bBaKo0GQKRnGGCxqiyCwmkqMpsksNpOGUGI7A" & _ "0ew1G0Rxlg0PptgsZuDG2Sx2l6N5tnYNZZjUDRXDCVo5l2FoymqOpukuNpujubwLjmWY5k0ZwxkaFxYlWdp6j6b5Lnafo/nABQdg2FxcUsY5BkmXAkmeQpckwNRrkKTh" & _ "8CSHZBk4NwyC4KxxgMDwakOMZDn8GgwnGAo2C4cwthMcwmCcMoHBMHRehwTIghySYNksZwcH4HBMEsHx5hyPItiweYxnwSZEH4Mozn0fR+DMAo7EYJ50gkdZelKdNql2" & _ "UgJn0GIukwH4HicQRai2GI4mSVpNl0dZGledgNgcYpYDWUx3FsOQi5YV5anaTY3G6W53A2RxylydxFjiaxEFCCgBBAQ==" .Add 2,"gBFLBCJwBAEHhEJAAEhABcoFg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj" & _ "6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" & _ "MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4" & _ "nGKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEokiEN5NCKfJ9DyTRjnS" & _ "cg1CEYxOBmBpPCgagdgcIZoHoGIFA4AxQkCAxKAgKBwgGSpIBCZhjF2E5UnQPQMiMCJBCIBwxkSQgsgo+JtDKT4ziiQw+k6EwAnsOgLnkHI+yCQ4iEuE4klkPhShEJBp" & _ "AoPgymOMoaDgHBjFMBgyD0HYTiCZSZhIIIGC4ChiHSew5kwM5omILZPiOBI0hwZw5kodIdA+M4Uj4PxOmMSJ9DuTQzmyZgviceZagaHVfj4awwmaAh2GUIYmCOEZZDaD" & _ "RDFGdwcg4EwyHMN4LBOaJbCoaZqgKH8qkMfIyD8DozDyfA7A0Coui0OpMmOZJdCsahKg6NooioChwmEMxLEoXJbDUTRXGSUgykyMgQG0GpPHMdI3D4TRCgSeQ0kmaw+l" & _ "GNAtCOZJVCiT5DhyRQwAqMg0EoDBBGEGAsASC5yiSCw+k4Mp6lWNQuksTpRjMTxDGzJwGmGMpDDKXYTECSAxl6Q5olkK4PgMMIVkASRMBMBgzEkaZEjsNALhIZA6AeQB" & _ "gk0ZJEgAAJ0CIAgODMNIsD6DRih9uYwFyAwfCUb5ijmbI+gwdxkk8MZMGeMpPCkDxzBiC5MHMPJLDSSROFMLIoBEQogEMFJPnENYQGgE4DCOaJfC7tYkhGTQ0kyWwyku" & _ "XpMiyRpKjKR4wngM4JmOWJACCdYtHMWw+Eych4nINYLAEYA8AgdAEEsQZajaQoog4GxPiMVIolcdxNG8XZVkmNoRwWRVBlFeFEeAZQJgnFiHgHwcAhjhHgGMSI5xki2C" & _ "yA4EQsA3i0HkBsLwKRFgAHcPkHopBJBcBeDUYI7xyDOHqKkWo2hLCsDIBIY4qQ5A8DoMMYwOAqCSBGKgU4yB2iDBwIgB4hxQgAAWNgBoAgsBdEcBUQ4sQ9A/HqD0JI8R" & _ "pBzH2OYVgahLBHFiJQJweQiDhDUE4SAARQAzFsG0EQwA6AOWSBkFgVAIBCHeGERQFQiCQHeFkC4vkiB8DyB4F4QxVDvGMNEOQexMjlBeOAKQiQLgfDA7QEAaRiBdEkH8" & _ "TI7AZiFBAGYBIABWjYBiGACioQ4C1A+AMMgWhfgxHgPsT4URIB0COKgPgjRwiAB8AYUArxBgCF6J4GY5hrAOCAPAAoGRRCsCIMEXATXfgAF8BMJwURuEQDgD4Q4OBoAe" & _ "HGFgLIwQrC2D0JoSQ+QvhrHoSgQI8AbDFGID8C4Ah6BQAQAASACwgCYCMAUMARAvCKAiAMCAokeCKBEOAKgCBoDaHuMsEAqwJDiACDURg8R6gPCyDofYWAhgoDIJ4ZAu" & _ "hoiGAYGgRoQw/A0GMMga4GwxiEDeIYYInATCDBQAoBAwAoDlA0KMBoVRGiDGwDQUYIRsgaGGDgM4LAwDWB8EcIA1APhjEgGQVwgRIgjFIIQHokgZA+CSEkLIKQSjHAwM" & _ "sCwDAsAEB2ABTIwRwD6A8CMToSxkAxE4HYIw+BsgbBEDAHYBwojCBoIYFgXSjABE4MsHIbQWhlGILQS4UhvBdAUKEEwHgxDAAABQQQUAhgKHiDwE4JS4A7BGLQZwCR4g" & _ "aBEMUYAqgKApHgGwVAIRNgvBMMQXImwZDtE4I8UIyAZCDCAE8AwrhgAdEEBACQLRCg4FEB4AYtA7CdEiPQMoJAMDNCkOMCAXAFDhH0D0Q4EgfAaGSK4NYzRUj9BuCgAg" & _ "swOBjB4Fqpw8B2ADAwE4A4Qx2DAE6JIaQPQGhAGKBcIQ5B5gHByKIFARwADbAyKUfgdBKBBGyEcVIAB/ijHoIoSA0gdBNl+OATYERZgBGSDYWIWAUCEGKA4FAhR7CIBt" & _ "YQGYZg4CMAiKEcAOwkBjHWE8Z4lQgA+DkBoTohwwCeAaMEEgBQCCABgHMRwQRhhMEWFQd4HwZgwDqFESItAbAGEANCpINAzANCCJkK4ah+heFYBURwsQrS2CsMYMoWGB" & _ "hYDWI0EInQgiApXaOVI1QFDsC8MUNoMBMA1HMJga4eh+BeAWOgNNowGjYzCGAAwax+iJBeBVT4gxoBIAGFsJFBxgBiGKFkKQ7g5DFFQEcAo4AzDDACKEQQLgCiJDYB0M" & _ "gRBCCQAgQEA==" .Add 3,"gBFLBCJwBAEHhEJAAEhABQ4Fg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj" & _ "6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" & _ "MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4" & _ "nGKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEosiYN5NHMOJ+D4TpTnS" & _ "eQ7CEY4uBmBpPhgagdgcIZoHibIEyUBJZDQIJShoCgcCAcoyAQOYYlcZJ1D0DxDCiQgwEiAZMHEMJLFKPJ9D2DoDnidQ4k+Y5QmKEROBkIhKD0JIZDIS4TGUCQuEeEJj" & _ "nOIg8CuY4RkYNgwGMM5RllGpThDRYIGKZIpCkJFUH0PINyWcQ3CaaZCG+HBnEOTJhD8Tx4GoeQ/GcaZSHOH5nCmQhshoZhihYYwhiYA4RlkNoNEMUZ3ByDjwEsPxOnMa" & _ "J9DuDR6F6GYmCmKh0nANtMioP4Gg8aoSiIO5NhodociqaY6GaFYkEyOg8lsNRNTaUgykyMgQG0GpPiONJbD8DpDEyfA6k0KwOkWMQsGsAJU0SagwkoJQJDIPISCQCJTG" & _ "SUwyGaM4KkmMgtksHpFjAZ4TGCBAbgaSpcksdhNAMIJHHsD5TjSWWMAMOpwjyLwbk6cAz0KRJiDkDYzESCwiggcgcgYIQwCIEINCMCITj6TVxkMXp2j0cQLlCTo7E2F4" & _ "ymkMZdhMPJHDGHpLAyVg+k4UwrCCSIyByDJ8DuDY8CiWY0kiXAXC6QJwFKGIjCeJpjgyezjlyDw6klHx5myRoMGwZwbkcToTEiew4kwbQfEmUgPkOKJUD4DpTHSHQmgk" & _ "XI/ASTA1g0XIEDMTBimyfI7jSLYHEiUoPk0Fw/kadAsHGao8A0A5smEMJ2mNyg5gzJZwDgCpChyIZVyIZwFCMJEPASRkBqE+IcHInRcDxA2H4bIsx0AtDsIBpwZwYicD" & _ "6BscwDwUBgHCIYaIfgtiVH2O4WgUwJjEFeAEQA7y4hMCiBMS4aRdB9A4CYE4LxljyBMHcDItBxinDCLcTYmgejBFQ9UTg9gFBOEmAQTI7A4iZGMGkQAWQ7jYA2HIL8BR" & _ "AjDG4HcCwARbjZHiNoDw1nLDnGyNINQ+wjCpBMEgcovQUgICQJEcgWRuBvAyJ4d4ugpCUAINcHogxIgnDiM4N4axzD3F2JMTY/hRqYF6FsWIxhYAGGoAALQYgYirBwBE" & _ "BwpAjBEAAIEIYsA2gOHCMAGgXAACIDmMITAUgFABH0D0I4WwvhNFGMAOIvxRD2GKNcMA8gjAPDCPwBogRPAxA8PgRwZRICYDED8RAXQEghEAN8DIgwIBdB4JYWwMgtiQ" & _ "HoFQKAiRFguFKGwGQhglDsEOVwEQQRkCKBwOIHgSREDRBYHEXQcQdD7GIGARQHRxipBrMobgewDCUCADsEYWAzgMHKHQDQxxsDzA6EMfAeQHB4GQDkUYPA0iECiKoGgR" & _ "hcDdA2GMQA8AOCjDSPgHI4QnApAKBICwHg1A+BcAwcYsgbjGGQNkCIgRsA6EcBEWANADjsB0B8YYzQQDIGSBcEYZBCCPEkFIHQSgkgZAwG4IwBAbAYGGAgL4Ch4g8BOC" & _ "QAA2KKC0GcAke4AAXAFCoHkDw4xbBFEcJkE4JRSiEFeJYKQVRMgJHODwX4xAgC/AsIIZAeAHDRG0HYI40RKCLEGDUI4jAghwBWIceA+whCpHMFYZYOQxglDMHMBQGxYj" & _ "VHiAoBIPgfgHGwPsHYJRSB6A0IERQLhCjJHMA4OQoAoCOACLYGYSx8DpBQIMWQdRnDRH+DsE4fB3CeAmM67kAAXBFEIDYDI7wLBtEoEIfYNwjiUGGJQYQMAjCHEAO0C4" & _ "zxW29CoCgfIxR9AKA6J8BgUAIhDGMIoJ40hqgwCgKETgnBhhqCGI0AIqgZhGDANQDIlBDCRGkCoJISR0g1BSKQOgfAzBRG0DYHARh4DeDAOwANuw8ApCKKkYg/RPhjBs" & _ "H0J4yg5hPGWN0GwFBHQBFaDoQIURljFAoB4GgzRVzbBECQFQRQoguHGHANwDRdCKy8CgSIGwhhoDYJYYI1giBICSAEgI=" .Add 4,"gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH" & _ "LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKB" & _ "UrGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo" & _ "3NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDs" & _ "YYDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoV" & _ "mWCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoV" & _ "oWiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZi" & _ "Se41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbh" & _ "FCcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==" End With .BackColorHeader = &H4c6c6c6 .SelBackColor = &H4000000 .SelForeColor = RGB(0,0,1) .CheckImage(0) = 16777216 .CheckImage(1) = 33554432 .CheckImage(2) = 50331648 .Background(20) = .SelBackColor .Background(21) = .SelForeColor .Background(26) = .BackColor .Background(27) = .ForeColor .Background(32) = -1 .Background(0) = &H4000000 .Background(41) = &H4010101 .Background(1) = &H40000ff .HeaderAppearance = 4 .ShowFocusRect = False .SortBarVisible = True .BackColorSortBar = .BackColor .BackColorLevelHeader = .BackColor .FilterBarDropDownHeight = 1 With .Columns.Add("Check") .Def(0) = True .PartialCheck = True .Width = 128 .DisplayFilterButton = True .FilterList = 256 End With With .Columns.Add("Pos") .FormatColumn = "1 pos ``" .AllowSort = False .Width = 48 .AllowSizing = False .Alignment = 1 .HeaderAlignment = 1 End With With .Columns.Add("Image") .DisplayFilterButton = True .FilterList = 8480 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc .FilterType = 10 .DisplayExpandButton = True .ExpandColumns = "1,2,3" .Width = 128 .HeaderImage = 1 End With With .Columns.Add("Images") .Def(0) = True .Width = 196 .HTMLCaption = "<img>1</img><img>2</img><img>3</img> Images" End With .Columns.Item("Pos").Position = 3 With .Items hR = .AddItem("Root") .ItemDivider(hR) = 0 .ItemDividerLine(hR) = 0 h = .InsertItem(hR,,"Child A") .CellImage(h,2) = 1 .CellImages(h,3) = "1,2,3" .CellCaption(h,3) = "123" h = .InsertItem(hR,,"Child B") .CellState(h,0) = 1 .CellImage(h,2) = 3 .CellImages(h,3) = "2,3,1" .CellCaption(h,3) = "231" .SelectItem(h) = True h = .InsertItem(hR,,"Child C") .CellImage(h,2) = 2 .CellState(h,3) = 1 .CellCaption(h,3) = "312" .CellImages(h,3) = "3,1,2" .ExpandItem(hR) = True End With .EndUpdate End With |
720 |
ImageSize property on 16 (default) (specifies the size of control' icons/images/check-boxes/radio-buttons)
' AddColumn event - Fired after a new column has been added. Private Sub Tree1_AddColumn(ByVal Column As Object) ' Column.Def(48) = 2 ' Column.Def(49) = 2 End Sub With Tree1 .BeginUpdate .ImageSize = 16 .Images "gBJJgBAIDAAEg4ACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjMLjABAAgjUYkUnlUrlktl0vmExmUzmk1m03nE5nU7nkrQCAntBoVDolFo1HoM/ADAplLptImdMYFOq" & _ "dSqlXq1QrVbrlGpVWsFNrNdnNjsk7pQAtNroFnt0sh8Yr9iulTuNxs1Eu8OiT/vsnsNVutXlk/oGGtVKxGLxWNtsZtN8iUYuNvy0Zvd+xNYwdwvl4p870GCqc8vOeuVt" & _ "tmp1knyOayWVy+WzN/ze1wOElenm+12WUz/Bv2/3UyyWrzeutux2GSyGP2dQ33C1ur3GD3M4zUNzHdlWjq/E3nGzVpjWv4HA7fRy/Tv2IrN8rPW6nZ3ve7mUlfu20Z8a" & _ "cvQyb+vY9jasYoDwMm+LytVBDqKG3z8O3Cb8P+mkAuY9cCQ2uL4KaxDKvkp8RNLEjqugnrwQo/UWPzFyeQw5sNLZFENrI4kOqU66pw8uzmOKvTqNqjULJvGL1JO48GtT" & _ "GsbLdEL3scxLlyiw8dQeoUVxdLTtyKmUjwGlslRPJsnK1HbAKbKCrsQo8uQk/CeP44iaR/ATnTNPLvyxPU+z9P9AUDQVBowiofJXQ6Oo+kKMpIkjztE4TKn4P6JowfgP" & _ "nwD5/nAjB8AOeAPo0eAA1IAFH07UhAIMpYAVIYFHqBUhwVjV1S1EtQAHxW65V0AZwAeuQAnwB5gAPYViEDVhwAHTQBkCjB4gOhwDmCyhH0sACAg==" With .VisualAppearance .Add 4,"gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH" & _ "LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKB" & _ "UrGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo" & _ "3NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDs" & _ "YYDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoV" & _ "mWCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoV" & _ "oWiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZi" & _ "Se41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbh" & _ "FCcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==" End With .BackColorHeader = &H4c6c6c6 .SelBackColor = &H4000000 .SelForeColor = RGB(0,0,1) .Background(20) = .SelBackColor .Background(21) = .SelForeColor .Background(26) = .BackColor .Background(27) = .ForeColor .Background(32) = -1 .Background(0) = &H4000000 .Background(41) = &H4010101 .Background(1) = &H40000ff .HeaderAppearance = 4 .ShowFocusRect = False .SortBarVisible = True .BackColorSortBar = .BackColor .BackColorLevelHeader = .BackColor .FilterBarDropDownHeight = 1 With .Columns.Add("Check") .Def(0) = True .PartialCheck = True .Width = 128 .DisplayFilterButton = True .FilterList = 256 End With With .Columns.Add("Pos") .FormatColumn = "1 pos ``" .AllowSort = False .Width = 48 .AllowSizing = False .Alignment = 1 .HeaderAlignment = 1 End With With .Columns.Add("Image") .DisplayFilterButton = True .FilterList = 8480 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc .FilterType = 10 .DisplayExpandButton = True .ExpandColumns = "1,2,3" .Width = 128 .HeaderImage = 1 End With With .Columns.Add("Images") .Def(0) = True .Width = 196 .HTMLCaption = "<img>1</img><img>2</img><img>3</img> Images" End With .Columns.Item("Pos").Position = 3 With .Items hR = .AddItem("Root") .ItemDivider(hR) = 0 .ItemDividerLine(hR) = 0 h = .InsertItem(hR,,"Child A") .CellImage(h,2) = 1 .CellImages(h,3) = "1,2,3" .CellCaption(h,3) = "123" h = .InsertItem(hR,,"Child B") .CellState(h,0) = 1 .CellImage(h,2) = 3 .CellImages(h,3) = "2,3,1" .CellCaption(h,3) = "231" .SelectItem(h) = True h = .InsertItem(hR,,"Child C") .CellImage(h,2) = 2 .CellState(h,3) = 1 .CellCaption(h,3) = "312" .CellImages(h,3) = "3,1,2" .ExpandItem(hR) = True End With .EndUpdate End With |
719 |
The user clicks the drop-down filter, select a value and the control's list filters for the selected item(s). Is there a way for when the user then goes to the next column to add another filter and the drop down arrow is clicked for the list of values they can filter by to be limited to what is being displayed in the list due to the first filter they set
' AddColumn event - Fired after a new column has been added. Private Sub Tree1_AddColumn(ByVal Column As Object) With Tree1 With Column End With End With End Sub With Tree1 .BeginUpdate .ColumnAutoResize = False Set rs = CreateObject("ADOR.Recordset") With rs .Open "Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExTree\Sample\Access\sample.accdb",3,3 End With .DataSource = rs .Columns.Item("ShipVia").Position = 2 .EndUpdate End With |
718 |
Is it possible to set from code, a column sort without being inserted in the sortbar
With Tree1 .BeginUpdate .ColumnAutoResize = False Set rs = CreateObject("ADOR.Recordset") With rs .Open "Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExTree\Sample\Access\sample.accdb",1,3 End With .DataSource = rs .SortBarVisible = True .Layout = "singlesort=""C1:1""" .EndUpdate End With |
717 |
Is it possible to view all events the control fires
' Event event - Notifies the application once the control fires an event. Private Sub Tree1_Event(ByVal EventID As Long) With Tree1 Debug.Print( .EventParam(-2) ) End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 With .Columns.Add("Tasks") .Def(0) = True .PartialCheck = True .Def(17) = 1 .FormatColumn = "value + (%CS0 = 1 ? `<r><fgcolor=808080>(checked)` : ``)" End With .HeaderVisible = 1 With .Items h = .AddItem("Project") hChild = .InsertItem(h,,"Task 1") .SelectItem(hChild) = True hChild = .InsertItem(h,,"Task 2") .CellState(hChild,0) = 1 hChild = .InsertItem(h,,"Task 3") .CellState(hChild,0) = 1 .ExpandItem(h) = True End With .EndUpdate End With |
716 |
How can I prevent expanding/collapsing the child items
' BeforeExpandItem event - Fired before an item is about to be expanded (collapsed). Private Sub Tree1_BeforeExpandItem(ByVal Item As Long,Cancel As Variant) With Tree1 Cancel = Tree1.Items.ItemParent(Item) End With End Sub With Tree1 .BeginUpdate .SingleSel = False .Columns.Add "Default" .LinesAtRoot = -1 With .Items h = .AddItem("Root 1") .InsertItem .InsertItem(h,,"Child 1.1"),,"Child" .InsertItem h,,"Child 1.2" .ExpandItem(h) = True h = .AddItem("Root 2") .InsertItem .InsertItem(h,,"Child 2.1"),,"Child" .InsertItem h,,"Child 2.2" .ExpandItem(h) = True End With .EndUpdate End With |
715 |
How can I display an item of picture type
With Tree1 .BeginUpdate .LinesAtRoot = -1 .ScrollBySingleLine = False .HeaderAppearance = 4 .HeaderHeight = 24 .Columns.Add("Artikel").HTMLCaption = "<u>Artikel" .Columns.Add("Waarde").HTMLCaption = "<u>Waarde" .HTMLPicture("T22128") = "c:\exontrol\images\zipdisk.gif" With .Items h = .AddItem("T22128-28)2D") h1 = .InsertItem(h,,"<img>T22128:128</img>") .CellCaptionFormat(h1,0) = 1 .ItemHeight(h1) = 128 h1 = .InsertItem(h,,"werkvoorbereiding") .CellCaption(h1,1) = "5.80" .CellBold(h1,1) = True .CellCaption(.InsertItem(h1,,"Type"),1) = "Eenvoudig" .CellCaption(.InsertItem(h1,,"Prijs p/uur"),1) = "60,00" .CellCaption(.InsertItem(h1,,"Marhe"),1) = "15,00%" .CellCaption(.InsertItem(h1,,"Insteltijd min."),1) = "5,00" .CellCaption(.InsertItem(h1,,"Aantal"),1) = 1 .CellCaption(.InsertItem(h1,,"Kostprije"),1) = "5,00" .ExpandItem(h1) = True h1 = .InsertItem(h,,"materiall") .CellCaption(h1,1) = "14.82" .CellBold(h1,1) = True .ItemHasChildren(h1) = True h1 = .InsertItem(h,,"snijden") .CellCaption(h1,1) = "3.13" .CellBold(h1,1) = True .ItemHasChildren(h1) = True .ExpandItem(h) = True End With .EndUpdate End With |
714 |
Dark mode
With Tree1 .BeginUpdate back = 65536 fore = 16777215 .VisualAppearance.Add 1,"gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQ" & _ "gmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYTh" & _ "dr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA" .VisualAppearance.Add 2,"gBFLBCJwBAEHhEJAAEhABPMIQAAYAQGKIcBiAKBQAGaAoDDcMgwQwAAxjIKUEwsACEIrjKCYVgOHYYQjGMZwHCMIhiGwcAChEZYHgkMYmDAMUhSE78axHG6PY7kKZ4b" & _ "iaKIqQLLEhSfJ0YyBECBZpfebIbjmIZMSLEIxDKItJSpCIaRgqWS6ahGO4JUbUFLQHT9IR4daIYRgEEBA" .VisualAppearance.Add 3,"gBFLBCJwBAEHhEJAAEhABUUIQAAYAQGKIcBiAKBQAGaAoDDcMgwQwAAxjIKUEwsACEIrjKCYVgOHYYQjGMZwGAsEwjAoYAChEaILgkMw2DBIQwgJIMEr/G6RZxjeL5C" & _ "jmG4nDhKMpybAcXxjBIYZJgOQpXb+PobTrNNLzfRFAxVAaWJikcZ4HpIAJNVLFdQ0XYMNSBISsBqrKiKcpeIIDWBZMbRZT1ZABCIZBpEW6LahENQwXrCN74DYkNTdKax" & _ "bbuaaXLhGCYBgIA==" .HeaderAppearance = 5 .BackColor = back .BackColorHeader = back .BackColorLevelHeader = back .BackColorSortBar = back .BackColorSortBarCaption = back .FilterBarBackColor = back .FilterBarForeColor = fore .ForeColor = fore .ForeColorHeader = fore .ForeColorSortBar = fore .SelBackColor = fore .SelForeColor = back .Background(0) = &H1000000 .Background(18) = &H2000000 ' &H10 Or BackgroundPartEnum.exCellButtonUp .Background(32) = -1 .Background(64) = &H3000000 .Background(65) = back .Background(66) = fore .Background(20) = fore .Background(21) = back .Background(26) = back .Background(27) = fore .Background(28) = back .Background(142) = &H2000000 ' &H80 Or BackgroundPartEnum.exDateSelect .Background(141) = &H2000000 ' &H80 Or BackgroundPartEnum.exDateSeparatorBar .Background(186) = fore .Description(25) = "<bgcolor 0><fgcolor ffffff> Exclude </fgcolor></bgcolor>" .EndUpdate End With |
713 |
How can I specify the cell's outline, border or lines around, when the cell gets selected
With Tree1 .BeginUpdate .AttachTemplate "handle AddColumn(Column){Column{Def(48)=4;Def(49)=4;}}" With .VisualAppearance .Add 1,"gBFLBCJwBAEHhEJAAEhABPEGACAADACAxRDgMQBQKAAzQFAYbBuGCGAAGIYBTgmFgAQhFcZQSpEEg7BKMYwjOJgFgmEQxDANIBQSKoaQiGQYYLhEZAEiONoaDJCM4wH" & _ "IMQxHCKTZRkGcfaRCGSfIzpGKpVgOTYiTbPcIyQKtBxDIydJTmeQQQhsFIJU7SdVUPDUJZlWbLAwWTAYazXCKRZBpeJqdo6Y5RUDKUqSdLUYyvEq7ZqnOIpw5vICpaCq" & _ "Op6HqKFpiXSAFL1fLmAwvPKrJjoeqpWpyCaRZQAGg4dbEdTNNCIbatQANKrCSpgZ7sMB6Di2L4TPS2awoWgRYyTFZMbBAeQ7LC1c45Fqrd4zS4dSxKCahcLxFiaNpYZY" & _ "njUap1jGPJlkuAgAkidB3nceZsCQEQJCgGhMGcQ4pkiSxEAAOYpiQIhvkYNA2gSCg5n+LIoGILowFyXQoAYAoAmASAWAaAZgggJgKF2T54DYDoDmECBGBKBJgGgTgWgW" & _ "YRoFYGIGmGOBqByB5hCgegggiYJYgoJIICIaIeByChixULILGGGAWDCCgjCiTgrg0YxojoC4OmOSJ2D6D5kAgJLFgABAEICA=" .Add 2,"CP:1 -4 0 0 0" End With .SelBackColor = &H2000000 .SelForeColor = RGB(0,0,1) .FullRowSelect = 0 .ShowFocusRect = False .DefaultItemHeight = 24 .HeaderHeight = 24 .DrawGridLines = 2 .Columns.Add "C1" .Columns.Add "C2" With .Items .CellCaption(.AddItem("Cell 1"),1) = "Cell 2" .CellCaption(.AddItem("Cell 3"),1) = "Cell 4" End With .Items.SelectPos = 1 .SelectColumnIndex = 1 .EndUpdate End With |
712 |
How can I specify the cell's outline, border or lines around, when the item gets selected
With Tree1 .BeginUpdate .AttachTemplate "handle AddColumn(Column){Column{Def(48)=4;Def(49)=4;}}" .VisualAppearance.Add 1,"gBFLBCJwBAEHhEJAAEhABPEGACAADACAxRDgMQBQKAAzQFAYbBuGCGAAGIYBTgmFgAQhFcZQSpEEg7BKMYwjOJgFgmEQxDANIBQSKoaQiGQYYLhEZAEiONoaDJCM4wH" & _ "IMQxHCKTZRkGcfaRCGSfIzpGKpVgOTYiTbPcIyQKtBxDIydJTmeQQQhsFIJU7SdVUPDUJZlWbLAwWTAYazXCKRZBpeJqdo6Y5RUDKUqSdLUYyvEq7ZqnOIpw5vICpaCq" & _ "Op6HqKFpiXSAFL1fLmAwvPKrJjoeqpWpyCaRZQAGg4dbEdTNNCIbatQANKrCSpgZ7sMB6Di2L4TPS2awoWgRYyTFZMbBAeQ7LC1c45Fqrd4zS4dSxKCahcLxFiaNpYZY" & _ "njUap1jGPJlkuAgAkidB3nceZsCQEQJCgGhMGcQ4pkiSxEAAOYpiQIhvkYNA2gSCg5n+LIoGILowFyXQoAYAoAmASAWAaAZgggJgKF2T54DYDoDmECBGBKBJgGgTgWgW" & _ "YRoFYGIGmGOBqByB5hCgegggiYJYgoJIICIaIeByChixULILGGGAWDCCgjCiTgrg0YxojoC4OmOSJ2D6D5kAgJLFgABAEICA=" .SelBackColor = &H1000000 .SelForeColor = RGB(0,0,1) .ShowFocusRect = False .DefaultItemHeight = 24 .HeaderHeight = 24 .DrawGridLines = 2 .Columns.Add "C1" .Columns.Add "C2" With .Items .CellCaption(.AddItem("Cell 1"),1) = "Cell 2" .CellCaption(.AddItem("Cell 3"),1) = "Cell 4" .SelectPos = 1 End With .EndUpdate End With |
711 |
How can I specify the cell's outline, border or lines around
With Tree1 .BeginUpdate .AttachTemplate "handle AddColumn(Column){Column{Def(48)=4;Def(49)=4;}}" .VisualAppearance.Add 1,"gBFLBCJwBAEHhEJAAEhABPEGACAADACAxRDgMQBQKAAzQFAYbBuGCGAAGIYBTgmFgAQhFcZQSpEEg7BKMYwjOJgFgmEQxDANIBQSKoaQiGQYYLhEZAEiONoaDJCM4wH" & _ "IMQxHCKTZRkGcfaRCGSfIzpGKpVgOTYiTbPcIyQKtBxDIydJTmeQQQhsFIJU7SdVUPDUJZlWbLAwWTAYazXCKRZBpeJqdo6Y5RUDKUqSdLUYyvEq7ZqnOIpw5vICpaCq" & _ "Op6HqKFpiXSAFL1fLmAwvPKrJjoeqpWpyCaRZQAGg4dbEdTNNCIbatQANKrCSpgZ7sMB6Di2L4TPS2awoWgRYyTFZMbBAeQ7LC1c45Fqrd4zS4dSxKCahcLxFiaNpYZY" & _ "njUap1jGPJlkuAgAkidB3nceZsCQEQJCgGhMGcQ4pkiSxEAAOYpiQIhvkYNA2gSCg5n+LIoGILowFyXQoAYAoAmASAWAaAZgggJgKF2T54DYDoDmECBGBKBJgGgTgWgW" & _ "YRoFYGIGmGOBqByB5hCgegggiYJYgoJIICIaIeByChixULILGGGAWDCCgjCiTgrg0YxojoC4OmOSJ2D6D5kAgJLFgABAEICA=" .SelBackMode = 1 .ShowFocusRect = False .DefaultItemHeight = 24 .HeaderHeight = 24 .DrawGridLines = 2 .Columns.Add "C1" .Columns.Add "C2" With .Items .CellCaption(.AddItem("Cell 1"),1) = "Cell 2" h = .AddItem("Cell 2") .CellCaption(h,1) = "Cell 3" .CellBackColor(h,1) = &H1000000 End With .EndUpdate End With |
710 |
Is it possible to highligth the match while a filter is applied
' AddColumn event - Fired after a new column has been added. Private Sub Tree1_AddColumn(ByVal Column As Object) ' Column.Def(17) = 1 End Sub ' FilterChange event - Notifies your application that the filter is changed. Private Sub Tree1_FilterChange() With Tree1 format = .FormatABC("`value replace '` + value + `' with '<bgcolor 000000><fgcolor FFFFFF>` + value + `</fgcolor></bgcolor>'`",.FilterBarPromptPattern) .Columns.Item(0).FormatColumn = format .Columns.Item(1).FormatColumn = format End With End Sub With Tree1 .BeginUpdate .DrawGridLines = 2 .HeaderAppearance = 4 .Columns.Add "Col 1" .Columns.Add "Col 2" With .Items .CellCaption(.AddItem("219 Smith"),1) = "Ignacio 1234" .CellCaption(.AddItem("1666 County Road 309A"),1) = "897 Manassa" .CellCaption(.AddItem("38 Lone Pine"),1) = "Durango 11" .CellCaption(.AddItem("612 Jachim Street"),1) = "Lamar 222" End With .FilterBarPromptPattern = "1" .FilterBarPromptVisible = 2067 ' FilterBarVisibleEnum.exFilterBarCompact Or FilterBarVisibleEnum.exFilterBarSingleLine Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible .FilterBarPromptType = 257 ' FilterPromptEnum.exFilterPromptCaseSensitive Or FilterPromptEnum.exFilterPromptContainsAll .EndUpdate End With |
709 |
Is it possible to highlight the column's header once a filter is applied (sample 2)
With Tree1 .BeginUpdate With .VisualAppearance .Add 1,"gBFLBCJwBAEHhEJAAEhABO8GACAADACAxRDgMQBQKAAzQFAYbBuGCGAAGIYBTgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwQgmNYDSBMcbwS" & _ "AsXRYFocJ5gOT6AjKBA2UclEZpajiTY3ABUEgUS5oOBIACqariaQJAAiCRQGiYZyHKaRSwPBKFYDIIjbJheTIDChNVxUcDENQjJqLBIDRzbarye59YBfeBXdgmA4LQbD" & _ "MRwNgMMQTDqKYbkOQZHbeGKAWTMEZzJj8cxTEqIaBhGTLfojSZMS7UGK1LLtMyHI6kP7sOiLfi2W4/W7XV72F79TzXIa2ZBuO57bhnAZ/VzGNj4PRNezfRqicjsGxcZw" & _ "Xg+TpQj0ew6gSOw7wSbozjsfYXi8PwMnSc52leHotl+MxjmoXh2nybxOH+SQtnYXx+D2P4vGMB56hQf5PCgBYeDwYBCEo1xggebgKH6IIDBYBgkiAQ5FgYPAhEIRgWGq" & _ "DBoC4GoCiGCBYhGBQPAWdIQp0eIUiWCZigiJgqgqYpIioJQhmIMhBH0NxjEMag2g2Y4ImYOoOmOSJeDQNxXlOLR3ECUAQICA=" .Add 2,"gBFLBCJwBAEHhEJAAEhABgsHQAAYAQGKIcBiAKBQAGaAoDDYNwwQwAAxDAKcEwsACEIrjKCRShyCYZRrGUgRCKQahLEiTIhGUYJHgmK4tRoAUgxWCEExrAaQJjjeCQF" & _ "i6LAtDhPMByfQEZQIGyjkgjNLUcSbG4AKgkCiXfpUAJVP7FcgSABEEigNIxToOU4jFgeCYLQKQRK2RC9GQGFCbLhpYKIahGTYWVheN5XXblez9P7ABQwKCcAwXBp7YIK" & _ "AT4XBIdYdQ7IL4xGA0AJPFoJC7mOQ5XiYAIBAZ/RL0LCcbxHHafVboQj6JouD5PUDVNY1XBdPynI6CbLhWy6Dq4UZzPwzeBifSHfDjRoJcCZe71KY3GwSEboNA6Kp+QB" & _ "HAmZoZjSPYIEiF47lOLJVnuYofBwJJHmaQoYj0MIRHeM4/m6cJ8B+fpBHQJ5SGKPYYH8OYMk+P5Bn4fxaAYZAvEIX4RgUWBGgCCAmAqApgkgNgOgMEYlGASoEkQeBWBa" & _ "BZhggZgagaYRoEwShWA6NZZAMQBAICA==" End With .Background(0) = &H1000000 .Background(41) = &H2000000 .Background(32) = -1 .HeaderHeight = 28 .BackColorHeader = RGB(255,255,255) .DrawGridLines = -2 .HeaderVisible = 1 With .Columns .Add("C1").DisplayFilterButton = True With .Add("C2") .DisplayFilterButton = True .Filter = "Item 2" .FilterType = 240 End With .Add("C3").DisplayFilterButton = True End With With .Items h = .AddItem("Item 1") .CellCaption(h,1) = "Item 2" .CellCaption(h,2) = "Item 3" h = .AddItem("Item 4") .CellCaption(h,1) = "Item 5" .CellCaption(h,2) = "Item 6" End With .ApplyFilter .EndUpdate End With |
708 |
How can I make the expand/collapse glyphs DPI aware
With Tree1 size = 2 .BeginUpdate With .VisualAppearance .Add 3,"gBFLBCJwBAEHhEJAAEhEGAUHQAAYAQGKIcBiAKBQAGaAoDDYOA4QwAAxDAKcEwsACEIrjKCRShyCYZRhGcTSBCIZBqEqSZLiEZRQiiCYsS5GQBRfIUEghGyNZjgNzQc" & _ "CQAI8T5IUgARBJIDSMY6DpOIxYHgmC4DEITNLxOK0EhRHCBZrgOCAYhqEY1Ro+dhPFYjVTMdK0LRtKy7Mq2aJmOpZDxWE7dZKpO5fbxXS67cr2fp/YBed4rfa7KTlOBK" & _ "cRQRBEFQPDqPZBkORZHh2FoLRJKbgtHJmHYNQWhVyYBbNCyTI6lahpeuHBx1QaWWxjbCMEr6bpoWLbFi3Ha1UzrPa8b5vSw7Gr+HzYQTHGPXGqaYJdZrnea6B7+U5XUJ" & _ "rnSOZciYHwhAeR5HDK+JVGqKRRmScx5HyfRei+H5bmmcp4Fi8o/CGGJKGQKZUGoFQigUPIiCeSZXnyHB6l0SAJn8JxfkIeZ5CgXxjCCAhyB8QgIlAM4MlKAIcCaIBIGY" & _ "GoGGEYhqBMMxgnICgRDUDQjESGwmAkWBuCqBoiHIVgkDQYgYESWg2E0YhohcJQigITg3CQSRyEyEYGGOWJwhQJD4FiFIMk0aJFGsIBkkOBJeDc+AchYJwJgIWhSgYZQp" & _ "FIVoVGOGQ4l2EwIBWMhgDmDhThCEwkAiaJchKDhjhgZhsCUY4iFCEoZkiaYQmSGAWhWQhgDuDpTjCDQiEgchAg0IpJBoDoFiEKBqCaCAimgIguH8IZnkPUhcBcJg+hGJ" & _ "ZnloYJsiaKZKGa24YnWSR0CkKhCA2CxlCqColhAYpqEKER0DqVZ0A0ASAgA==" .Add 4,"gBFLBCJwBAEHhEJAAEhABAQCg6AADACAxRDgMQBQKAAzQFAYbBwHCGAAGIYBTgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACjeQYJBCNYbTJAbqhY" & _ "IgAR3HqQZABCCSQKkYx0HScRiwPBMFwGIQmaaicZoJCiN4DTZAcIBRDUIxpDR9bBeKw3KqVaZnWhaNpWXZlTzKdSxXisF67RZSdi/XgvF5XXblez9P69LwXe5mUrGbyV" & _ "YghCCIKgeG4dR7IMhyLDcKQXCCVW7aGSsOwbAqAXpdGAXTQdDyLJKnaZqOi6BjjA4rNbHGIYJb1XTRMa1LJuG5LJrOeZ3Xre4BLfh1VoFRpjWIYNY1QS7TLOczzfRdDx" & _ "TiGVpkjCeJoD4Ng1hSRxiisVRKg8D4PkWZJznmPQ+F8Xx5guWpjHGWYMiYQodEaIRSCgU5KCSeh3naHB/iAAh9n8fwfgIeZ1CgXwjCCAhxl8AgIlAM4MlKAIcCaD54FY" & _ "FoFmGCBmBaBIJigPJNgKSAoDSVC+BIbIYCUYYoiYKoJgkWIMlGCAglMaJZDWCYiFyFIJkkOJYhEJc7G4PYPCOaJshQJBjgiVIUgyDRokEaggGSQ4El4N1CBiFgnAmAha" & _ "FKFZlFkShUhWJRYmITg3GSQgFGuGBOGOFJkCSSQCDoNgkiOCY0hUJJmmmQhvhqZtYmUOQmBWIRvhgTpjjSbAjEiEgchBZgyEaBIhigWgegqIhIjoDILiACB5nTL5WnWR" & _ "YOiSKYJnqGQ7CmOh2hqJ5OkYORxFyShKhSAxihkOomioY5YiqFIkFyTo1HkAxAEAgIA==" .Add 1,Tree1.FormatABC("`CP:3 -` + int(value*dpi) + ` -` + int(value*dpi) + ` ` + int(value*dpi) + ` ` + int(value*dpi)",size) .Add 2,Tree1.FormatABC("`CP:4 -` + int(value*dpi) + ` -` + int(value*dpi) + ` ` + int(value*dpi) + ` ` + int(value*dpi)",size) End With .LinesAtRoot = 1 .HasButtons = 4 .HasButtonsCustom(0) = 16777216 .HasButtonsCustom(1) = 33554432 .Columns.Add "Column" With .Items h = .AddItem("Root 1") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True h = .AddItem("Root 2") .InsertItem h,,"Child" End With .EndUpdate End With |
707 |
Is it possible to highlight the column's header once a filter is applied (sample 1)
With Tree1 .BeginUpdate With .VisualAppearance .Add 2,"gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgAN" & _ "J0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8Y" & _ "NYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4" & _ "hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mg" & _ "bhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhW" & _ "BMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=" .Add 1,"CP:2 -8 -4 2 4" End With .Background(0) = &H1fefefe .Background(41) = &H1010101 .Background(32) = -1 .HeaderHeight = 28 .BackColorHeader = RGB(255,255,255) .DrawGridLines = -2 .HeaderVisible = 1 With .Columns .Add("C1").DisplayFilterButton = True With .Add("C2") .DisplayFilterButton = True .Filter = "Item 2" .FilterType = 240 End With .Add("C3").DisplayFilterButton = True End With With .Items h = .AddItem("Item 1") .CellCaption(h,1) = "Item 2" .CellCaption(h,2) = "Item 3" h = .AddItem("Item 4") .CellCaption(h,1) = "Item 5" .CellCaption(h,2) = "Item 6" End With .ApplyFilter .EndUpdate End With |
706 |
Is it possible to show the filterbar on top of the rows
With Tree1 .BeginUpdate .FilterBarPromptVisible = 8192 .HeaderHeight = 24 .FilterBarHeight = .HeaderHeight .HeaderAppearance = 1 .DrawGridLines = -1 .GridLineStyle = 512 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = 3 .Filter = "B*" End With With .Columns.Add("Index") .FormatColumn = "1 index ``" .Position = 0 .Width = 48 .AllowSizing = False .SortType = 1 .Def(0) = True End With With .Items .AddItem "A.1" .AddItem "A.2" .AddItem "B.1" .AddItem "B.2" .AddItem "B.3" .AddItem "C" End With .ApplyFilter .EndUpdate End With |
705 |
DragDrop (with visual effect)
' OLEDragDrop event - Occurs when a source component is dropped onto a target component when the source component determines that a drop can occur. Private Sub Tree1_OLEDragDrop(ByVal Data As Object,Effect As Long,ByVal Button As Integer,ByVal Shift As Integer,ByVal X As Long,ByVal Y As Long) ' SelectItem(InsertItem(i,, Data.GetData(1))) = True With Tree1 i = .ItemFromPoint(-1,-1,c,hit) With .Items .ExpandItem(i) = True End With End With End Sub ' OLEStartDrag event - Occurs when the OLEDrag method is called. Private Sub Tree1_OLEStartDrag(ByVal Data As Object,AllowedEffects As Long) ' Data.SetData(Me.Items.CellCaption(FocusItem, 0), 1) With Tree1 AllowedEffects = 1 End With End Sub With Tree1 .VisualAppearance.Add 1,"gBFLBCJwBAEHhEJAAEhABPUIQAAYAQGKIcBiAKBQAGaAoDgYN4MAANAwjJBMKgBBCLIxhEYobgmGIaRjEEQDCKYcxHCaIBiGcaIfDEBIeSBHcgRbAcOQHGSZZBhGRJG" & _ "juKIbSrLICzBDUcRnGwAKQoaaaEomHwyAZOYwDAIoWhpKKCKjqWJKNb+XgAAJTES0RRVRTNAZ1YghGAQgIA==" .Background(96) = &H1000000 .Background(33) = RGB(0,0,0) .Background(34) = RGB(255,255,255) .OLEDropMode = 1 .AutoDrag = 196608 .LinesAtRoot = -1 .Indent = 16 .SelBackMode = 1 .Columns.Add "Default" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True End With Debug.Print( "You can:" ) Debug.Print( "A) left-click to drag and drop items between controls (open a new exhelper and run the same sample)" ) Debug.Print( "B) right-click to re-arrange the item position inside the same control" ) Debug.Print( "This sample shows how you can insert the data being dropped as a child of the item being hovered." ) End With |
704 |
DragDrop (with no visual effect, hide item while drag and drop)
' OLEDragDrop event - Occurs when a source component is dropped onto a target component when the source component determines that a drop can occur. Private Sub Tree1_OLEDragDrop(ByVal Data As Object,Effect As Long,ByVal Button As Integer,ByVal Shift As Integer,ByVal X As Long,ByVal Y As Long) ' SelectItem(InsertItem(i,, Data.GetData(1))) = True With Tree1 i = .ItemFromPoint(-1,-1,c,hit) With .Items .ExpandItem(i) = True End With End With End Sub ' OLEStartDrag event - Occurs when the OLEDrag method is called. Private Sub Tree1_OLEStartDrag(ByVal Data As Object,AllowedEffects As Long) ' Data.SetData(Me.Items.CellCaption(FocusItem, 0), 1) With Tree1 AllowedEffects = 1 End With End Sub With Tree1 .Background(33) = RGB(0,0,0) .Background(34) = RGB(255,255,255) .OLEDropMode = 1 .AutoDrag = 196608 .LinesAtRoot = -1 .Indent = 16 .SelBackMode = 1 .Columns.Add "Default" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True End With Debug.Print( "You can:" ) Debug.Print( "A) left-click to drag and drop items between controls (open a new exhelper and run the same sample)" ) Debug.Print( "B) right-click to re-arrange the item position inside the same control" ) Debug.Print( "This sample shows how you can insert the data being dropped as a child of the item being hovered." ) End With |
703 |
DragDrop
' OLEDragDrop event - Occurs when a source component is dropped onto a target component when the source component determines that a drop can occur. Private Sub Tree1_OLEDragDrop(ByVal Data As Object,Effect As Long,ByVal Button As Integer,ByVal Shift As Integer,ByVal X As Long,ByVal Y As Long) ' SelectItem(InsertItem(i,, Data.GetData(1))) = True With Tree1 i = .ItemFromPoint(-1,-1,c,hit) With .Items .ExpandItem(i) = True End With End With End Sub ' OLEStartDrag event - Occurs when the OLEDrag method is called. Private Sub Tree1_OLEStartDrag(ByVal Data As Object,AllowedEffects As Long) ' Data.SetData(Me.Items.CellCaption(FocusItem, 0), 1) With Tree1 AllowedEffects = 1 End With End Sub With Tree1 .OLEDropMode = 1 .AutoDrag = 196608 .LinesAtRoot = -1 .Indent = 16 .SelBackMode = 1 .Columns.Add "Default" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True End With Debug.Print( "You can:" ) Debug.Print( "A) left-click to drag and drop items between controls (open a new exhelper and run the same sample)" ) Debug.Print( "B) right-click to re-arrange the item position inside the same control" ) Debug.Print( "This sample shows how you can insert the data being dropped as a child of the item being hovered." ) End With |
702 |
Is there anyway to stop the header changing colour when the mouse hovers/moves across the column header (non-clickable)
With Tree1 .BeginUpdate .HeaderAppearance = 4 With .Columns .Add "Item" With .Add("Pos") .Position = 0 .Width = 32 .AllowSizing = False .FormatColumn = "1 index ``" .AllowSort = False .AllowDragging = False End With End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .EndUpdate End With |
701 |
Is there anyway to stop the header changing colour when the mouse hovers/moves across the column header
With Tree1 .BeginUpdate .HeaderAppearance = 4 .Background(32) = -1 With .Columns .Add "Item" With .Add("Pos") .Position = 0 .Width = 32 .AllowSizing = False .FormatColumn = "1 index ``" .AllowSort = False .AllowDragging = False End With End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .EndUpdate End With |
700 |
Is it possible to display the header using multiple lines(sample 1)
' AddColumn event - Fired after a new column has been added. Private Sub Tree1_AddColumn(ByVal Column As Object) ' Column.Def(52) = 4 ' Column.Def(53) = 4 End Sub With Tree1 .BeginUpdate .HeaderHeight = 36 .HeaderAppearance = 1 .HeaderSingleLine = False With .Columns .Add "Column" .Add("This is a bit of text that should break the header").Width = 128 .Add("This is a bit of text that should break the header").Width = 96 End With .EndUpdate End With |
699 |
Is it possible to display the header using multiple lines(sample 2)
' AddColumn event - Fired after a new column has been added. Private Sub Tree1_AddColumn(ByVal Column As Object) ' Column.Def(52) = 4 ' Column.Def(53) = 4 End Sub With Tree1 .BeginUpdate .HeaderHeight = 36 .HeaderAppearance = 1 With .Columns .Add "Column" .Add("C1").HTMLCaption = "<b>C<off 4>1</b><br>left" .Add("C2").HTMLCaption = "<c><b>C<off 4>2</b><br><c>center" .Add("C3").HTMLCaption = "<r><b>C<off 4>3</b><br><r>right" End With .EndUpdate End With |
698 |
Is it possible to exclude the parent/child items when do the filtering, so to include only items that match the filter without any indentation
' FilterChange event - Notifies your application that the filter is changed. Private Sub Tree1_FilterChange() With Tree1 .Indent = Tree1.FormatABC("value > 0 ? 18 : 0",.Items.MatchItemCount) End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 .Indent = 18 .FilterInclude = 4 .DrawGridLines = 2 .HeaderAppearance = 1 With .Columns With .Add("Column") .DisplayFilterButton = True .FilterType = 240 .FilterList = 256 .Filter = "C1" End With With .Add("Pos") .FormatColumn = "1 rindex ``" .Position = 0 .AllowSizing = False .AllowDragging = False End With End With With .Items h = .AddItem("R1") h2 = .InsertItem(h,,"S") .InsertItem h2,,"C1" .InsertItem h2,,"C2" .InsertItem h,,"C1" .InsertItem h,,"C2" .ExpandItem(h) = True h = .AddItem("R2") .InsertItem h,,"C1" .InsertItem h,,"C2" End With .ApplyFilter .EndUpdate End With |
697 |
I would like to display a solid line between "root" items, and dotted lines (default) between child items. How can I do that
With Tree1 .BeginUpdate .LinesAtRoot = -1 .DrawGridLines = 1 .GridLineStyle = 512 .VisualAppearance.Add 1,"gBFLBCJwBAEHhEJAAEhABMsIQAAYAQGKIcBiAKBQAGaAoDgYN4MAANAwjJBMKgBBCLIxhEYobgmGIXRpFMbxAKQahLEiTIgGUYJHgmK4tQLHb7zGAABRDDSOIDnGQJX" & _ "haI4JQSMMQDGLAZxVFiPRhAWLpBh+PQATrOdLUfSjVwhBKAQEBA==" With .Columns.Add("Default") .Def(0) = True .PartialCheck = True End With With .Columns.Add("Position") .FormatColumn = "((1 rindex ``) contains `.`) = 0" .Visible = False End With With .ConditionalFormats.Add("%C1") .BackColor = &H1e0e0e0 End With With .Items h = .AddItem("Root 1") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .InsertItem h,,"Child 3" .ExpandItem(h) = True h = .AddItem("Root 2") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" h = .AddItem("Root 3") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" End With .EndUpdate End With |
696 |
I can not center or align the cell's caption and icon, when it displays the hierarchy
With Tree1 .BeginUpdate .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" With .Columns.Add("Tasks") .Def(17) = 1 End With .HeaderVisible = 1 With .Items h = .AddItem("Project") hChild = .InsertItem(h,,"<img>1</img> Task (left)") hChild = .InsertItem(h,,"<c><img>2</img> Task (center)") hChild = .InsertItem(h,,"<r>Task (right) <img>3</img>") .ExpandItem(h) = True End With .EndUpdate End With |
695 |
How do I set an extra data for each item
' MouseMove event - Occurs when the user moves the mouse. Private Sub Tree1_MouseMove(ByVal Button As Integer,ByVal Shift As Integer,ByVal X As Long,ByVal Y As Long) With Tree1 i = .ItemFromPoint(-1,-1,c,hit) Debug.Print( i ) Debug.Print( .Items.ItemData(i) ) End With End Sub With Tree1 .BeginUpdate .ColumnAutoResize = True .Columns.Add "Default" With .Items .ItemData(.AddItem("method 1")) = "your extra data of method 1" .InsertItem 0,"your extra data of method 2","method 2" End With With .Items .DefaultItem = .AddItem("method 3") .ItemData(0) = "your extra data of method 3" End With .EndUpdate End With |
694 |
I do not like to specify the item padding for every column I add. The question is how can I do it automatically
With Tree1 .BeginUpdate .AttachTemplate "handle AddColumn(Column){Column{Def(48)=8;Def(49)=8;AllowDragging=False;AllowSizing = True}}" .HeaderAppearance = 4 .DrawGridLines = -1 .GridLineStyle = 32 With .Columns .Add "Item" With .Add("Pos") .Position = 0 .Width = 32 .AllowSizing = False .FormatColumn = "1 index ``" End With End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .EndUpdate End With |
693 |
Can I sort the column by check-state
With Tree1 .BeginUpdate With .Columns.Add("Check") .Def(0) = True .SortType = 32 End With With .Items .AddItem .CellState(.AddItem(),0) = 1 .CellState(.AddItem(),0) = 1 .AddItem End With .Columns.Item(0).SortOrder = 1 .EndUpdate End With |
692 |
Can I sort the column by image
With Tree1 .BeginUpdate .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" With .Columns.Add("Image") .SortType = 48 End With With .Items .CellImage(.AddItem(),0) = 3 .AddItem .CellImage(.AddItem(),0) = 1 .CellImage(.AddItem(),0) = 2 End With .Columns.Item(0).SortOrder = 1 .EndUpdate End With |
691 |
How can I display UNICODE characters
With Tree1 .BeginUpdate With .Font .Name = "Arial Unicode" .Size = 22 End With .HeaderVisible = False .DefaultItemHeight = 48 .Columns.Add("").Def(17) = 1 With .Items .AddItem "Ӓӓ" .AddItem "ᦜᦝ;ᦞ" .AddItem "ɮɭ;ɯ" .AddItem "勳勴勵勶" .FormatCell(.AddItem(Tree1.Version),0) = "(value lfind `UNICODE`) < 0 ? `<fgcolor=FF0000><b>!UNICODE!</b> version</fgcolor> required: ` + value : `` " End With .EndUpdate End With |
690 |
How do I display the position of the item with 0-padding
With Tree1 .BeginUpdate .Columns.Add("Items").FormatColumn = "((1 apos ``) lpad `00`) + `. ` + value" With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" .AddItem "Item D" End With .EndUpdate End With |
689 |
Can't get the +/- to be displayed on a divider item. What else can I do
With Tree1 .BeginUpdate .LinesAtRoot = -1 .DrawGridLines = -1 .TreeColumnIndex = 0 .MarkSearchColumn = False .FullRowSelect = 0 .HeaderAppearance = -1 ' &Hfffffff8 Or AppearanceEnum.Bump Or AppearanceEnum.Sunken With .Columns .Add("C1").Width = 32 .Add("C2").FormatColumn = "1 index ``" End With With .Items h = .AddItem("Cell 1") .CellSingleLine(h,1) = False h = .AddItem("This is bit of text merges all cells in the item (divider shows no +/-)") .ItemDivider(h) = 0 .ItemBackColor(h) = RGB(240,240,240) .ItemDividerLine(h) = 0 .CellHAlignment(h,0) = 1 .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True h = .AddItem("Cell 3") h = .AddItem("This is bit of text merges all cells in the item (merge shows +/-)") .ItemBackColor(h) = RGB(240,240,240) .CellMerge(h,0) = 1 .InsertItem h,,"Child 3" .InsertItem h,,"Child 4" .ExpandItem(h) = True End With .EndUpdate End With |
688 |
ADODB Requery sample
' CellButtonClick event - Fired after the user clicks on the cell of button type. Private Sub Tree1_CellButtonClick(ByVal Item As Long,ByVal ColIndex As Long) With Tree1 Set cmd = CreateObject("ADODB.Command") With cmd .ActiveConnection = Tree1.DataSource.ActiveConnection .CommandText = "INSERT INTO Orders (EmployeeID) VALUES(12345)" .CommandType = 1 .Execute End With .DataSource.Requery End With End Sub With Tree1 .BeginUpdate .HeaderAppearance = 4 .ColumnAutoResize = False Set rs = CreateObject("ADODB.Recordset") With rs .Open "Select * From Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExTree\Sample\Access\sample.accdb",1,3 End With .DataSource = rs .ConditionalFormats.Add("%1=12345").BackColor = RGB(240,240,240) With .Items .LockedItemCount(0) = 1 h = .LockedItem(0,0) .ItemDivider(h) = 0 .CellHasButton(h,0) = True .CellCaption(h,0) = "Requery (add a new record, using ADODB.Command)" .CellHAlignment(h,0) = 1 End With .EndUpdate End With |
687 |
How do I use the ColumnsFloatBarVisible on exColumnsFloatBarVisibleIncludeCheckColumns
With Tree1 .BeginUpdate .ColumnAutoResize = False .HeaderAppearance = 4 With .Columns .Add "City" .Add("Start").Visible = False .Add("End").Visible = False End With .Description(26) = "Show/Hide" .ColumnsFloatBarSortOrder = 1 .ColumnsFloatBarVisible = 2 .EndUpdate End With |
686 |
How do I use the ColumnsFloatBarVisible on exColumnsFloatBarVisibleIncludeHiddenColumn
With Tree1 .BeginUpdate .ColumnAutoResize = False .HeaderAppearance = 4 With .Columns .Add "City" .Add("Start").Visible = False .Add("End").Visible = False End With .Description(26) = "Show" .ColumnsFloatBarVisible = -1 .ColumnsFloatBarSortOrder = 1 .EndUpdate End With |
685 |
Type of wraps the cell's caption support (Sample 2)
With Tree1 .BeginUpdate .HeaderSingleLine = False .HeaderHeight = 36 .DrawGridLines = -2 .ColumnAutoResize = False .ScrollBySingleLine = True With .Columns With .Add("Single-Line (exCaptionSingleLine)") .Width = 96 .Def(17) = 1 .Def(16) = -1 End With With .Add("Word-Wrap (exCaptionWordWrap)") .Width = 96 .Def(17) = 1 .Def(16) = 0 .FormatColumn = "%0" End With With .Add("Break-Wrap (exCaptionBreakWrap)") .Width = 96 .Def(17) = 1 .Def(16) = 1 .FormatColumn = "%0" End With End With With .Items .AddItem "This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line." .AddItem "This is the <b>first</b> line.\r\nThis is the <b>second</b> line.\r\nThis is the <b>third</b> line." End With .EndUpdate End With |
684 |
Type of wraps the cell's caption support (Sample 1)
With Tree1 .BeginUpdate .HeaderSingleLine = False .HeaderHeight = 36 .DrawGridLines = -2 .ColumnAutoResize = False .ScrollBySingleLine = True .Columns.Add("Default").Width = 128 With .Items h = .AddItem("This is the first line.\r\nThis is the second line.\r\nThis is the third line.") h = .AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.") .CellCaptionFormat(h,0) = 1 h = .AddItem("This is the first line.\r\nThis is the second line.\r\nThis is the third line.") .CellSingleLine(h,0) = 0 h = .AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.") .CellCaptionFormat(h,0) = 1 .CellSingleLine(h,0) = 0 h = .AddItem("This is the first line.\r\nThis is the second line.\r\nThis is the third line.") .CellSingleLine(h,0) = 1 h = .AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.") .CellCaptionFormat(h,0) = 1 .CellSingleLine(h,0) = 1 End With .EndUpdate End With |
683 |
Can I break the cell's caption using the line break <br> or \r\n (Sample 2)
With Tree1 .BeginUpdate .DrawGridLines = -2 .ColumnAutoResize = False .ScrollBySingleLine = True .Columns.Add("Default").Width = 128 With .Items .CellSingleLine(.AddItem("This is the first line.\r\nThis is the second line.\r\nThis is the third line."),0) = 1 .AddItem "This is the first line.\r\nThis is the second line.\r\nThis is the third line." End With .EndUpdate End With |
682 |
Can I break the cell's caption using the line break <br> or \r\n (Sample 1)
With Tree1 .BeginUpdate .DrawGridLines = -2 .ColumnAutoResize = False .ScrollBySingleLine = True With .Columns.Add("Default") .Width = 128 .Def(16) = 1 End With With .Items .AddItem "This is the first line.\r\nThis is the second line.\r\nThis is the third line." .AddItem "This is the first line.\r\nThis is the second line.\r\nThis is the third line." End With .EndUpdate End With |
681 |
How can I change the visual appearance/color of the Filter For ... field
With Tree1 .BeginUpdate .LinesAtRoot = -1 .BackColorHeader = RGB(1,0,0) .ForeColorHeader = RGB(255,255,255) .Background(26) = .BackColorHeader .Background(27) = .ForeColorHeader .Background(0) = RGB(240,240,240) .Background(32) = -1 .HeaderAppearance = 5 With .Columns.Add("Items") .FilterOnType = True .DisplayFilterButton = True .FilterList = 2 End With With .Items h = .AddItem("Root 1") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True h = .AddItem("Root 2") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" End With .EndUpdate End With |
680 |
How can I display the cell's caption without spaces on both sides
With Tree1 .BeginUpdate .ColumnAutoResize = True With .Columns.Add("Default") .Def(17) = 1 .FormatColumn = "((trim(value) replace ` ` with ` `) replace ` ` with ` `) replace ` ` with `<bgcolor=FF0000> </bgcolor>`" End With With .Items .AddItem "" .AddItem "Item A" .AddItem " Item B" .AddItem " Item C " End With .EndUpdate End With |
679 |
How can I highlight the spaces within the column (sample 2)
With Tree1 .BeginUpdate .ColumnAutoResize = True With .Columns.Add("Default") .Def(17) = 1 .FormatColumn = "`'` + ( value replace ` ` with `_` ) + `'`" End With With .Items .AddItem "" .AddItem "Item A" .AddItem " Item B" .AddItem " Item C " End With .EndUpdate End With |
678 |
How can I highlight the spaces within the column (sample 1)
With Tree1 .BeginUpdate .ColumnAutoResize = True With .Columns.Add("Default") .Def(17) = 1 .FormatColumn = "len(value) = 0 ? `<bgcolor=FF0000> </bgcolor>` : ( value replace ` ` with `<bgcolor=FF0000> </bgcolor>` )" End With With .Items .AddItem "" .AddItem "Item A" .AddItem " Item B" .AddItem " Item C " End With .EndUpdate End With |
677 |
How can I change the visual aspect of the drop down filter-calendar
With Tree1 .BeginUpdate .Background(26) = RGB(0,0,1) .Background(27) = RGB(255,255,255) .Background(12) = RGB(255,255,255) .Background(8) = .Background(26) .Background(11) = RGB(128,128,128) With .Columns.Add("Date") .FilterType = 4 .DisplayFilterButton = True .DisplayFilterDate = True .DisplayFilterPattern = False End With .EndUpdate End With |
676 |
Export Data in HTML format
With Tree1 .BeginUpdate .LinesAtRoot = -1 .BackColorAlternate = RGB(240,240,240) .DrawGridLines = -1 .HeaderAppearance = 4 .Description(11) = .FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",.Description(11)) .FilterBarCaption = "(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " & _ "`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" & _ "hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" & _ "nt + ` item(s)`) )))" .FilterBarPromptVisible = 2579 ' FilterBarVisibleEnum.exFilterBarCompact Or FilterBarVisibleEnum.exFilterBarShowCloseIfRequired Or FilterBarVisibleEnum.exFilterBarSingleLine Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible .FilterBarPromptType = 2 With .ConditionalFormats .Add("%0 like `*parent*`","parent").BackColor = RGB(192,192,192) With .Add("%0 like `*child*`","child") .ForeColor = RGB(255,128,128) .ApplyTo = 0 End With With .Add("%0 like `*B*`","b") .ForeColor = RGB(0,0,255) .Bold = True .Italic = True .ApplyTo = 0 End With End With With .Columns With .Add("Value") .Width = 128 .HTMLCaption = "<b>VA</b><r>sko" End With With .Add("APos") .FormatColumn = "0 apos ``" .AllowSort = False .Def(4) = 15790320 .Def(5) = 8421504 .Def(8) = .Def(5) .Position = 0 End With With .Add("RPos") .FormatColumn = "0 rpos ``" .AllowSort = False .Position = 1 End With With .Add("Index") .FormatColumn = "0 index ``" .DisplayFilterButton = True .FilterList = 256 .Position = 2 End With With .Add("Data 1") .FormatColumn = "0 index `A-Z`" .Def(0) = True End With With .Add("Data 2") .FormatColumn = "0 index `AB` replace `A` with `<off -4>A</off>`" .Def(16) = False .Def(17) = 1 .Def(1) = True End With With .Add("Data 3") .FormatColumn = "0 index `CDC` replace `D` with `<b>D</b>`" .Def(17) = 1 End With End With With .Items h = .AddItem("ParentA") .InsertItem h,,"Child A" .InsertItem h,,"Child B" .CellState(h,4) = 1 .CellBackColor(.InsertItem(h,,"Child C"),5) = RGB(0,255,0) .ExpandItem(h) = True .AddItem "Item A" h = .AddItem("ParentB") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .CellBackColor(.InsertItem(h,,"Child 3"),5) = RGB(0,255,0) .CellState(h,5) = 1 .AddItem "Item B" .AddItem "Item C" .AddItem "Item D" .ExpandItem(h) = True End With .EndUpdate sFile = "c:/temp/export.html" .Export sFile,"vis" With CreateObject("InternetExplorer.Application") .Navigate2 sFile End With End With |
675 |
Export Data in CSV format
With Tree1 .BeginUpdate .LinesAtRoot = -1 .BackColorAlternate = RGB(240,240,240) .DrawGridLines = -1 .HeaderAppearance = 4 .Description(11) = .FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",.Description(11)) .FilterBarCaption = "(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " & _ "`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" & _ "hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" & _ "nt + ` item(s)`) )))" .FilterBarPromptVisible = 2579 ' FilterBarVisibleEnum.exFilterBarCompact Or FilterBarVisibleEnum.exFilterBarShowCloseIfRequired Or FilterBarVisibleEnum.exFilterBarSingleLine Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible .FilterBarPromptType = 2 With .ConditionalFormats .Add("%0 like `*parent*`","parent").BackColor = RGB(192,192,192) With .Add("%0 like `*child*`","child") .ForeColor = RGB(255,128,128) .ApplyTo = 0 End With With .Add("%0 like `*B*`","b") .ForeColor = RGB(0,0,255) .Bold = True .Italic = True .ApplyTo = 0 End With End With With .Columns With .Add("Value") .Width = 128 .HTMLCaption = "<b>VA</b><r>sko" End With With .Add("APos") .FormatColumn = "0 apos ``" .AllowSort = False .Def(4) = 15790320 .Def(5) = 8421504 .Def(8) = .Def(5) .Position = 0 End With With .Add("RPos") .FormatColumn = "0 rpos ``" .AllowSort = False .Position = 1 End With With .Add("Index") .FormatColumn = "0 index ``" .DisplayFilterButton = True .FilterList = 256 .Position = 2 End With With .Add("Data 1") .FormatColumn = "0 index `A-Z`" .Def(0) = True End With With .Add("Data 2") .FormatColumn = "0 index `AB` replace `A` with `<off -4>A</off>`" .Def(16) = False .Def(17) = 1 .Def(1) = True End With With .Add("Data 3") .FormatColumn = "0 index `CDC` replace `D` with `<b>D</b>`" .Def(17) = 1 End With End With With .Items h = .AddItem("ParentA") .InsertItem h,,"Child A" .InsertItem h,,"Child B" .CellState(h,4) = 1 .CellBackColor(.InsertItem(h,,"Child C"),5) = RGB(0,255,0) .ExpandItem(h) = True .AddItem "Item A" h = .AddItem("ParentB") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .CellBackColor(.InsertItem(h,,"Child 3"),5) = RGB(0,255,0) .CellState(h,5) = 1 .AddItem "Item B" .AddItem "Item C" .AddItem "Item D" .ExpandItem(h) = True End With .EndUpdate Debug.Print( .Export("","vis") ) End With |
674 |
Is it possible to check multiple-items at once
' AddItem event - Occurs after a new Item has been inserted to Items collection. Private Sub Tree1_AddItem(ByVal Item As Long) With Tree1 bHasParent = .FormatABC("value != 0",.Items.ItemParent(Item)) With .Items .CellHasCheckBox(Item,0) = bHasParent End With End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 With .Columns.Add("Tasks") .Def(17) = 1 .FormatColumn = "value + (%CS0 = 1 ? `<r><fgcolor=808080>(checked)` : ``)" End With .HeaderVisible = 1 .SingleSel = False With .Items h = .AddItem("Project") hChild = .InsertItem(h,,"Task 1") hChild = .InsertItem(h,,"Task 2") hChild = .InsertItem(h,,"Task 3") .ExpandItem(h) = True .LockedItemCount(0) = 1 .CellCaption(.LockedItem(0,0),0) = "<c>Select multiple items and press the <b>SPACE</b> key" End With .EndUpdate End With |
673 |
How can I get the icon from the cell when using the Items.CellImages property (icon index)
' MouseMove event - Occurs when the user moves the mouse. Private Sub Tree1_MouseMove(ByVal Button As Integer,ByVal Shift As Integer,ByVal X As Long,ByVal Y As Long) With Tree1 i = .ItemFromPoint(-1,-1,c,hit) Debug.Print( .FormatABC("( 0x44 = ( value bitand 0x44 ) ) ? ( ( (value bitand 0xFFFF0000) bitshift 16 ) array B split `,` ) : `no image`",hit,.Items.CellImages(i,c)) ) End With End Sub With Tree1 .BeginUpdate .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" .Columns.Add "Default" With .Items .CellImages(.AddItem("Item 1"),0) = "3,2,1" .CellImages(.AddItem("Item 2"),0) = "2,3" .CellImages(.AddItem("Item 3"),0) = "2," End With .EndUpdate End With |
672 |
How can I get the icon from the cell when using the Items.CellImages property (icon position within the cell)
' MouseMove event - Occurs when the user moves the mouse. Private Sub Tree1_MouseMove(ByVal Button As Integer,ByVal Shift As Integer,ByVal X As Long,ByVal Y As Long) With Tree1 i = .ItemFromPoint(-1,-1,c,hit) Debug.Print( .FormatABC("( 0x44 = ( value bitand 0x44 ) ) ? 1 + ( (value bitand 0xFFFF0000) bitshift 16 ) : `no image`",hit) ) End With End Sub With Tree1 .BeginUpdate .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" .Columns.Add "Default" With .Items .CellImages(.AddItem("Item 1"),0) = "3,2,1" .CellImages(.AddItem("Item 2"),0) = "2,3" .CellImages(.AddItem("Item 3"),0) = "2" End With .EndUpdate End With |
671 |
Is it possible to change the visual appearance of the position signs when user changes the column's position by drag and drop
With Tree1 .BeginUpdate .HeaderAppearance = 4 With .Columns .Add "Column 1" .Add "Column 2" .Add "Column 3" End With With .VisualAppearance .Add 1,"gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzV" & _ "IUcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4" & _ "aDhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DB" & _ "eEMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDI" & _ "BICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAok" & _ "GKHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhulRGHKGoImefh0BUZ4JmYeoemeSZ2H6HQmgoBgXDqXwUAQgI=" .Add 2,"CP:1 0 -36 0 0" End With .Background(182) = &H2000000 .EndUpdate End With |
670 |
A black portion is shown while I am using the BackColorAlternate with EBN colors. What can I do
With Tree1 .BeginUpdate .ColumnAutoResize = True .DefaultItemHeight = 20 .VisualAppearance.Add 1,"gBFLBCJwBAEHhEJAAEhIDhAxHAxg0HG0Mg4xGI3HMOig3GcJiYAf8jAEhhUnAAyhEqg8hk0oAsIjgAiAwmYxGA4mYzGwwkI0i0ooUnB0IBMIl1Dg8zmYyGolptPkI1m" & _ "Y1GAll9KoUslNIrVCqNQldShFUstXAVfrVcrlZtVhuFnsUHq1zoczoQGhFBkNpg6zbDykUkhsPHE2h85nc9n8xtVDtlex9Msd2p1YstVq9ux8HyMtzuFz1PsNTzQlv2h" & _ "hWfkuqpeVuN0q+nvEooN5veSAGpkb/ACcZrvhU3w83nM/poxGuchGpoVBvWgg+8knA4WimnFxI45Er5XOlHMg/Q3XU33W4ew9Wyu11mchDagcO7zus8VDoNBBEIKBpMY" & _ "6DqOQyokhA/IQIQmwMk4bIQFDcoO6LWgwhQkNcABwEyAB5GwWbet6cRQg3DENQ5D8QxADZvEkAB8nabsURGeBpFM3pwE2AEZRpDx/neZpOR3Dz9oO/r/wCMoZNTBQAQR" & _ "JSEwYg8HPGhEIoNCaEwq10gQ2WcRt7LcRxRFpuxUAEURQ3sczBEMgTTG8gN7HpOSEAEiQBAQZpmQ0DibPUFwbKcHwkhQoQtNQNzNEMbABOKDy/DMYQzHLeoPL0OTJSUd" & _ "0pHcxTewk5zrIygIRPslz4lEngBKIAQivgASs/kLSBTlO00f8t0vGcgUbDlDRjXLCUNRERRvRgAHW2oAICA==" With .Columns.Add("Default") .Def(0) = True .PartialCheck = True End With With .Columns.Add("Position") .FormatColumn = "1 rindex ``" .Visible = False End With With .ConditionalFormats.Add("%C1 mod 2") .BackColor = &H1000000 End With With .Items .AddItem "Item 1" .AddItem "Item 2" .AddItem "Item 3" .AddItem "Item 4" End With .EndUpdate End With |
669 |
How can I specify alternate background colors for each root item, similar with BackColorAlternate
With Tree1 .BeginUpdate .LinesAtRoot = -1 With .Columns.Add("Default") .Def(0) = True .PartialCheck = True End With With .Columns.Add("Position") .FormatColumn = "( ( 1:=( ( 0:=(1 rpos '') ) lfind `.`) ) < 0 ? =:0 : (=:0 left =:1) )" .Visible = False End With With .ConditionalFormats.Add("%C1 mod 2") .BackColor = RGB(240,240,240) End With With .Items h = .AddItem("Root 1") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True h = .AddItem("Root 2") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" h = .AddItem("Root 3") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" End With .EndUpdate End With |
668 |
Is it possible to change the caption from a column without to remove the column and add it with the new caption
With Tree1 .Columns.Add("ColumnName").Caption = "NewName" .Columns.Add("ColumnName").HTMLCaption = "<b>New</b>Name" End With |
667 |
FilterBarCaption ALL Keyword ( sample 2, result )
' AddItem event - Occurs after a new Item has been inserted to Items collection. Private Sub Tree1_AddItem(ByVal Item As Long) With Tree1 i = .FormatABC("value + 1",.Items.ItemToIndex(Item)) .Items.CellImage(Item,3) = i End With End Sub With Tree1 .BeginUpdate .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" With .Columns.Add("Col-1") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Col-2") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Check") .Def(0) = True .DisplayFilterButton = True .DisplayFilterPattern = False .FilterType = 6 End With With .Columns.Add("Image") .DisplayFilterButton = True .FilterType = 10 .FilterList = 9472 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .CellCaption(.AddItem("Item A"),1) = "Sub-Item A" h = .AddItem("Item B") .CellCaption(h,1) = "Sub-Item B" .CellState(h,2) = 1 .CellCaption(.AddItem("Item C"),1) = "Sub-Item C" End With .FilterBarFont = .Font .Description(11) = .FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",.Description(11)) .FilterBarCaption = "(( ( all replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `[" & _ "<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matchi" & _ "temcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount" & _ " + ` item(s)`) )))" .FilterBarPromptVisible = 3 ' FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .Columns.Item(2).Filter = 1 .ApplyFilter .EndUpdate End With |
666 |
FilterBarCaption ALL Keyword ( sample 1 )
' AddItem event - Occurs after a new Item has been inserted to Items collection. Private Sub Tree1_AddItem(ByVal Item As Long) With Tree1 i = .FormatABC("value + 1",.Items.ItemToIndex(Item)) .Items.CellImage(Item,3) = i End With End Sub With Tree1 .BeginUpdate .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" With .Columns.Add("Col-1") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Col-2") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Check") .Def(0) = True .DisplayFilterButton = True .DisplayFilterPattern = False .FilterType = 6 End With With .Columns.Add("Image") .DisplayFilterButton = True .FilterType = 10 .FilterList = 9472 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .CellCaption(.AddItem("Item A"),1) = "Sub-Item A" h = .AddItem("Item B") .CellCaption(h,1) = "Sub-Item B" .CellState(h,2) = 1 .CellCaption(.AddItem("Item C"),1) = "Sub-Item C" End With .FilterBarFont = .Font .Description(11) = .FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",.Description(11)) .FilterBarCaption = "all" .FilterBarPromptVisible = 3 ' FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .Columns.Item(2).Filter = 1 .ApplyFilter .EndUpdate End With |
665 |
FilterBarCaption ALLUI Keyword ( sample 2, result )
' AddItem event - Occurs after a new Item has been inserted to Items collection. Private Sub Tree1_AddItem(ByVal Item As Long) With Tree1 i = .FormatABC("value + 1",.Items.ItemToIndex(Item)) .Items.CellImage(Item,3) = i End With End Sub With Tree1 .BeginUpdate .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" With .Columns.Add("Col-1") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Col-2") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Check") .Def(0) = True .DisplayFilterButton = True .DisplayFilterPattern = False .FilterType = 6 End With With .Columns.Add("Image") .DisplayFilterButton = True .FilterType = 10 .FilterList = 9472 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .CellCaption(.AddItem("Item A"),1) = "Sub-Item A" h = .AddItem("Item B") .CellCaption(h,1) = "Sub-Item B" .CellState(h,2) = 1 .CellCaption(.AddItem("Item C"),1) = "Sub-Item C" End With .FilterBarFont = .Font .Description(11) = .FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",.Description(11)) .FilterBarCaption = "(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " & _ "`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" & _ "hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" & _ "nt + ` item(s)`) )))" .FilterBarPromptVisible = 3 ' FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .Columns.Item(2).Filter = 1 .ApplyFilter .EndUpdate End With |
664 |
FilterBarCaption ALLUI Keyword ( sample 1 )
' AddItem event - Occurs after a new Item has been inserted to Items collection. Private Sub Tree1_AddItem(ByVal Item As Long) With Tree1 i = .FormatABC("value + 1",.Items.ItemToIndex(Item)) .Items.CellImage(Item,3) = i End With End Sub With Tree1 .BeginUpdate .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" With .Columns.Add("Col-1") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Col-2") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Check") .Def(0) = True .DisplayFilterButton = True .DisplayFilterPattern = False .FilterType = 6 End With With .Columns.Add("Image") .DisplayFilterButton = True .FilterType = 10 .FilterList = 9472 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .CellCaption(.AddItem("Item A"),1) = "Sub-Item A" h = .AddItem("Item B") .CellCaption(h,1) = "Sub-Item B" .CellState(h,2) = 1 .CellCaption(.AddItem("Item C"),1) = "Sub-Item C" End With .FilterBarFont = .Font .Description(11) = .FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",.Description(11)) .FilterBarCaption = "allui" .FilterBarPromptVisible = 3 ' FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .Columns.Item(2).Filter = 1 .ApplyFilter .EndUpdate End With |
663 |
FilterBarCaption AVAILABLE Keyword ( sample 2, result )
' AddItem event - Occurs after a new Item has been inserted to Items collection. Private Sub Tree1_AddItem(ByVal Item As Long) With Tree1 i = .FormatABC("value + 1",.Items.ItemToIndex(Item)) .Items.CellImage(Item,3) = i End With End Sub With Tree1 .BeginUpdate .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" With .Columns.Add("Col-1") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Col-2") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Check") .Def(0) = True .DisplayFilterButton = True .DisplayFilterPattern = False .FilterType = 6 End With With .Columns.Add("Image") .DisplayFilterButton = True .FilterType = 10 .FilterList = 9472 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .CellCaption(.AddItem("Item A"),1) = "Sub-Item A" h = .AddItem("Item B") .CellCaption(h,1) = "Sub-Item B" .CellState(h,2) = 1 .CellCaption(.AddItem("Item C"),1) = "Sub-Item C" End With .FilterBarFont = .Font .Description(11) = .FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",.Description(11)) .FilterBarCaption = "(( ( value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` ) + ` ` + ( ava" & _ "ilable replace `[` with `<bgcolor=C0C0C0><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` replace `<s>` with `" & _ "` replace `</s>` with `` ) + `<fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount" & _ " + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount + ` item(s)`) )))" .FilterBarPromptVisible = 3 ' FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .Columns.Item(2).Filter = 1 .ApplyFilter .EndUpdate End With |
662 |
FilterBarCaption AVAILABLE Keyword ( sample 1 )
' AddItem event - Occurs after a new Item has been inserted to Items collection. Private Sub Tree1_AddItem(ByVal Item As Long) With Tree1 i = .FormatABC("value + 1",.Items.ItemToIndex(Item)) .Items.CellImage(Item,3) = i End With End Sub With Tree1 .BeginUpdate .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" With .Columns.Add("Col-1") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Col-2") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Check") .Def(0) = True .DisplayFilterButton = True .DisplayFilterPattern = False .FilterType = 6 End With With .Columns.Add("Image") .DisplayFilterButton = True .FilterType = 10 .FilterList = 9472 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .CellCaption(.AddItem("Item A"),1) = "Sub-Item A" h = .AddItem("Item B") .CellCaption(h,1) = "Sub-Item B" .CellState(h,2) = 1 .CellCaption(.AddItem("Item C"),1) = "Sub-Item C" End With .FilterBarFont = .Font .Description(11) = .FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",.Description(11)) .FilterBarCaption = "value + ` ` + available" .FilterBarPromptVisible = 3 ' FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .Columns.Item(2).Filter = 1 .ApplyFilter .EndUpdate End With |
661 |
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 3, results )
With Tree1 .BeginUpdate With .Columns.Add("Col-1") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Col-2") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .CellCaption(.AddItem("Item A"),1) = "Sub-Item A" .CellCaption(.AddItem("Item B"),1) = "Sub-Item B" .CellCaption(.AddItem("Item C"),1) = "Sub-Item C" End With .FilterBarFont = .Font .Description(11) = .FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",.Description(11)) .FilterBarCaption = "(`<b>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) +" & _ " ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )) replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replac" & _ "e `]` with ` </b></bgcolor></fgcolor>`" .FilterBarPromptVisible = 256 With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With With .Columns.Item(1) .FilterType = 3 .Filter = "*B" End With .ApplyFilter .EndUpdate End With |
660 |
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 2 )
With Tree1 .BeginUpdate With .Columns.Add("Col-1") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Col-2") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .CellCaption(.AddItem("Item A"),1) = "Sub-Item A" .CellCaption(.AddItem("Item B"),1) = "Sub-Item B" .CellCaption(.AddItem("Item C"),1) = "Sub-Item C" End With .FilterBarFont = .Font .Description(11) = .FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",.Description(11)) .FilterBarCaption = "value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>`" .FilterBarPromptVisible = 256 With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With With .Columns.Item(1) .FilterType = 3 .Filter = "*B" End With .ApplyFilter .EndUpdate End With |
659 |
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 1 )
With Tree1 .BeginUpdate With .Columns.Add("Col-1") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Col-2") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .CellCaption(.AddItem("Item A"),1) = "Sub-Item A" .CellCaption(.AddItem("Item B"),1) = "Sub-Item B" .CellCaption(.AddItem("Item C"),1) = "Sub-Item C" End With .Description(11) = .FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",.Description(11)) .FilterBarCaption = "value replace `[` with `<fgcolor=808080>[` replace `]` with `]</fgcolor>`" .FilterBarPromptVisible = 256 With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With With .Columns.Item(1) .FilterType = 3 .Filter = "*B" End With .ApplyFilter .EndUpdate End With |
658 |
Is it possible to automatically displays the control's filter label to the right
With Tree1 .BeginUpdate With .Columns.Add("Item") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarCaption = "`<r>` + value" .FilterBarPromptVisible = 1280 ' FilterBarVisibleEnum.exFilterBarShowCloseOnRight Or FilterBarVisibleEnum.exFilterBarToggle With .Columns.Item(0) .FilterType = 240 .Filter = "Item B" End With .ApplyFilter .EndUpdate End With |
657 |
How can I get the number of results/items being shown in the control's filter bar (sample 4)
With Tree1 .BeginUpdate With .Columns.Add("Item") .DisplayFilterButton = True .FilterList = 9504 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsAsc End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarFont = .Font .FilterBarPrompt = .FormatABC("`<b>` + value",.FilterBarPrompt) .FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount " & _ "+ 1) + ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )" .FilterBarPromptVisible = 3591 ' FilterBarVisibleEnum.exFilterBarCompact Or FilterBarVisibleEnum.exFilterBarShowCloseOnRight Or FilterBarVisibleEnum.exFilterBarShowCloseIfRequired Or FilterBarVisibleEnum.exFilterBarCaptionVisible Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible .EndUpdate End With |
656 |
How can I get the number of results being shown in the control's filter bar (sample 3)
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarFont = .Font .FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount " & _ "+ 1) + ` result(s)` ) : ``)" .FilterBarPromptVisible = 2055 ' FilterBarVisibleEnum.exFilterBarCompact Or FilterBarVisibleEnum.exFilterBarCaptionVisible Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .ApplyFilter .EndUpdate End With |
655 |
How can I get the number of results being shown in the control's filter bar (sample 2, compact)
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarFont = .Font .FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? `<off -4> ` + abs(matchitemcount + 1) + ` result(s)` : ``)" .FilterBarPromptVisible = 2071 ' FilterBarVisibleEnum.exFilterBarCompact Or FilterBarVisibleEnum.exFilterBarSingleLine Or FilterBarVisibleEnum.exFilterBarCaptionVisible Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .ApplyFilter .EndUpdate End With |
654 |
How can I get the number of results being shown in the control's filter bar (sample 1)
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarFont = .Font .FilterBarCaption = "`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)" .FilterBarPromptVisible = 7 ' FilterBarVisibleEnum.exFilterBarCaptionVisible Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .ApplyFilter .EndUpdate End With |
653 |
FilterBarCaption Predefined Keywords
' AfterExpandItem event - Fired after an item is expanded (collapsed). Private Sub Tree1_AfterExpandItem(ByVal Item As Long) With Tree1 .Refresh End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Check") .Def(0) = True .DisplayFilterButton = True .DisplayFilterPattern = False .FilterType = 6 End With With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" h = .AddItem("Item B") .CellState(.InsertItem(h,,"Sub-Item B1"),1) = 1 .InsertItem h,,"Sub-Item B2" .ExpandItem(h) = True .AddItem "Item C" End With .FilterInclude = 1 .FilterBarFont = .Font .FilterBarCaption = "`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</" & _ "i></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>" & _ ": ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF>" & _ "<i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</" & _ "i></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=8" & _ "08080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount +" & _ " `</fgcolor>`" .FilterBarPromptPattern = "B" .FilterBarPromptVisible = 7 ' FilterBarVisibleEnum.exFilterBarCaptionVisible Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .ApplyFilter .EndUpdate End With |
652 |
I am using filter prompt feature, and also column's filter, just wondering if possible to compact displaying the filter bar so it won't show on multiple lines
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarFont = .Font .FilterBarCaption = "`<r><i><fgcolor=808080><upline><solidline><sha ;;0>` + value" .FilterBarPromptPattern = "B" .FilterBarPromptVisible = 2067 ' FilterBarVisibleEnum.exFilterBarCompact Or FilterBarVisibleEnum.exFilterBarSingleLine Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .ApplyFilter .EndUpdate End With |
651 |
Just wondering if it is possible to show the filter bar's close button on the right ( sample 2 )
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarPromptVisible = 1281 ' FilterBarVisibleEnum.exFilterBarShowCloseOnRight Or FilterBarVisibleEnum.exFilterBarToggle Or FilterBarVisibleEnum.exFilterBarPromptVisible .FilterBarPrompt = .FormatABC("`<r>` + value",.FilterBarPrompt) .EndUpdate End With |
650 |
Just wondering if it is possible to show the filter bar's close button on the right ( sample 1 )
With Tree1 .BeginUpdate .RightToLeft = True .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarPromptVisible = 257 ' FilterBarVisibleEnum.exFilterBarToggle Or FilterBarVisibleEnum.exFilterBarPromptVisible .EndUpdate End With |
649 |
How can I change the visual appearance of the filter bar's close button (EBN)
With Tree1 .BeginUpdate With .VisualAppearance .Add 1,"gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJ" & _ "jyI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKm" & _ "SZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8OR" & _ "OicbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2" & _ "DYxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJX" & _ "AiAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaK" & _ "JDCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G" & _ "0TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEA" & _ "kjIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRS" & _ "MRsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhA" & _ "QHkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ" End With .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarPromptVisible = 257 ' FilterBarVisibleEnum.exFilterBarToggle Or FilterBarVisibleEnum.exFilterBarPromptVisible .Background(1) = &H1000000 .EndUpdate End With |
648 |
How can I change the visual appearance of the filter bar's close button (solid)
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarPromptVisible = 1 .Background(1) = RGB(255,0,0) .EndUpdate End With |
647 |
Is it possible to prevent definitely showing the filter bar's close button
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarPromptVisible = 1 .Background(1) = -1 .EndUpdate End With |
646 |
Is it possible to show the close button only if there is a filter applied
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarPromptVisible = 513 ' FilterBarVisibleEnum.exFilterBarShowCloseIfRequired Or FilterBarVisibleEnum.exFilterBarPromptVisible .EndUpdate End With |
645 |
The control's filter bar is not closed once I click the close button (toggle)
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" .LockedItemCount(2) = 1 h = .LockedItem(2,0) .ItemDivider(h) = 0 .CellCaption(h,0) = "<c><fgcolor=808080>Press the CTRL + F to turn on/off the control's filter bar. ALT + Up/Down moves the focus." .CellCaptionFormat(h,0) = 1 End With .FilterBarCaption = "`<r><fgcolor=808080>` + value" .FilterBarPromptPattern = "B" .FilterBarPromptVisible = 2323 ' FilterBarVisibleEnum.exFilterBarCompact Or FilterBarVisibleEnum.exFilterBarToggle Or FilterBarVisibleEnum.exFilterBarSingleLine Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item B" End With .ApplyFilter .EndUpdate End With |
644 |
How can I display the control's filter on a single line
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarCaption = "len(value) ? `filter for: <fgcolor 808080>` + value : `<fgcolor 808080>no filter`" .FilterBarPromptVisible = 18 ' FilterBarVisibleEnum.exFilterBarSingleLine Or FilterBarVisibleEnum.exFilterBarVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .ApplyFilter .EndUpdate End With |
643 |
How can I display the control's filter on a single line (prompt-combined)
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarCaption = "`<r>` + value" .FilterBarPromptVisible = 2067 ' FilterBarVisibleEnum.exFilterBarCompact Or FilterBarVisibleEnum.exFilterBarSingleLine Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item A|Item B" End With .ApplyFilter .EndUpdate End With |
642 |
How can I get the number of results after a filter is applied
' Click event - Occurs when the user presses and then releases the left mouse button over the tree control. Private Sub Tree1_Click() With Tree1 .ClearFilter End With End Sub ' FilterChange event - Notifies your application that the filter is changed. Private Sub Tree1_FilterChange() With Tree1 Debug.Print( "Items.MatchItemCount" ) Debug.Print( .Items.MatchItemCount ) Debug.Print( .FormatABC("value < 0 ? `filter applied: ` + abs(value + 1) + ` result(s)` : `no filter`",.Items.MatchItemCount) ) End With End Sub With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarPromptVisible = 1 .FilterBarPromptPattern = "Item" .EndUpdate End With |
641 |
How can I programmatically clear the control's filter
' Click event - Occurs when the user presses and then releases the left mouse button over the tree control. Private Sub Tree1_Click() With Tree1 .ClearFilter End With End Sub With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarPromptVisible = 1 .FilterBarPromptPattern = "B" .EndUpdate End With |
640 |
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt-combined)
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarPromptPattern = "B" .FilterBarPromptVisible = 3 ' FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible With .Columns.Item(0) .FilterType = 240 .Filter = "Item B" End With .ApplyFilter .EndUpdate End With |
639 |
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt)
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarPromptVisible = 1 .FilterBarPromptPattern = "B" .EndUpdate End With |
638 |
Is it possible to prevent closing the control's filter bar, so it is always shown
With Tree1 .BeginUpdate .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem "Item A" .AddItem "Item B" .AddItem "Item C" End With .FilterBarCaption = "len(value) = 0 ? `<fgcolor=808080>no filter` : value" .FilterBarPromptVisible = 2 With .Columns.Item(0) .FilterType = 240 .Filter = "Item B" End With .ApplyFilter .EndUpdate End With |
637 |
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 4)
With Tree1 .BeginUpdate .LinesAtRoot = -1 .VisualDesign = "gBFLBWIgBAEHhEJAEGg6VAkHeLpgwChAOhULB8XAUUg8MAAREEHGMcgRCJ0ei8dhABDEcQAAYAQGKIYBkAKBQAGaAoDDMOQwQwAAxjGKEEwsACEIrjKCRShyCYZRhGc" & _ "TSBCIZBqEqSZLiEZRQiiCYsS5GQBRWAkEwiBiEQTjea5CgOIAFS7LIqjRQEBxhIaZYIGaiQADENo9TxIMZAfBIHShK6NJABCCSQKkYx0HScRijDIEFwGIQmbKiej4DCi" & _ "CQQW7OYYRVCNMQSfa8HivJyrcamfp/YBgOBYHb1eLVPR5LwfPCGUw1P6PLxkORZHimK4tSLHV7xVpMIwZFafIQhCCoHomS5NU7UNR0TQUFx9FaGX7rDDsGwLAJ6XRgF4" & _ "bg2VpnHePpenAN4bH2GwHFmApSjEGBLnWOpRGOTBZHOegrE6BxPiWVJqCweQrn0LgJAWJBjwgaw1gKO5HmWch5h+fovF+G5bmich4BgfZkB8dynRUVYqiUR5rnmex/F6" & _ "N4tn2AJfnebZ3DEXw3HWXgzAyIwgicKJKBKEIhCeCgiHyHYFEmSAFmqBghFIdgSCeIJygYDAyAgJx6AoIINAMOJNCgCZCGoGoLmMCI+CwJoihMNglCCIhzFCUg0EmMhg" & _ "hWDBkAiQg9CUY4jEYN4Jk2IxklYJoJHIUg+CSZJSESFwkkkGI+FOFIJEIRhPhMCRJCSVoRrSBhiDgTZjHYT4PEkYhwhgJYm0SaIaiaSYuE+GQNlmCIBGCJxjhiZQ5AkM" & _ "hAg6ExJCkPhPguaAiFYUAlAkKZ0g6HoOEmWR/GHcA4m0OwIlIJIHCRgQshGJhpjoaocieaZiC6GAimkUgehIOwnGYGYIGkah6jaE4rg6SpCjKK5rEOMYlGIGIihKOggl" & _ "oFoqj6L5aGaBo6CkGIkAQjiPpCAAaJILCTJQlKPACDaXJgmSaJsnCdJ4nygKEoijKQpSmKcqCpKoqysK0rivLAsSyLMtC1LYty4Lkui7LwvS+L8wDBMIwzEMUxjHMgyT" & _ "KMszDNM4zzQNE0jTNQ1TWNc2DZNo2zcN03jfOA4TiOM5DlOY5zoOk6jrOw7TuO88DxPI8z0PU9j3Pg+T6Ps/D9P4/0AQFAkDQRBUGQdCEJQpC0MQ1DkPRBEUSRNFEVBh" & _ "FkXRhGQ9D6Dxfh+W5gGGd4QH2XQjCmDpFFaKoVB+D5Xmed5+H8YAHnIAh9EwV5Fl0d4MkMKJICmSgygSJAoEmMUCIPgnDCCIOQFYCxJjwFoCcA4kxoF+AIJkAgExegDE" & _ "gEYQInAzCUAIOEGgfxiiRDYF1Q4EQ2BSCaEQYwbAiKREMpRSymFNDIAkAxT6oVRgSA2qdVKq1WqvVirMZQUhSCnBUMoIgoQRgnGSIQUgkg1hIHYAkAYMROAmHiLsE4xx" & _ "SCxBwEwCQ0wmDdBsE0GYXBtg2CSPMFIuwYiQBYBQeAcwOCnBCCZgw0g0glBONAQgqQThCGgPQGoBQfiRGmOEZIPAXjsBoPAO4HRThhA0EQSA5BAgaCKJIGg3QdhOCmNU" & _ "BoQAijTCIF0FwQxpCHDIPAYYMQGgtCmFcaQtRAjZCyFYSojQ2B2BoKwIYFApBXEIBsIQ1QsAWAWEwaA1xCgjAoIAQBAQ=" .Columns.Add "Column" With .Items h = .AddItem("Root 1") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True h = .AddItem("Root 2") .InsertItem h,,"Child" End With .EndUpdate End With |
636 |
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 3)
With Tree1 .BeginUpdate With .VisualAppearance .Add 3,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _ "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _ "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _ "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" & _ "XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" & _ "gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" & _ "INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=" .Add 1,"CP:3 -2 -2 2 2" .Add 4,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _ "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _ "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _ "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" & _ "eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" & _ "FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" & _ "JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI=" .Add 2,"CP:4 -2 -2 2 2" End With .LinesAtRoot = 1 .HasButtons = 4 .HasButtonsCustom(0) = 16777216 .HasButtonsCustom(1) = 33554432 .Columns.Add "Column" With .Items h = .AddItem("Root 1") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True h = .AddItem("Root 2") .InsertItem h,,"Child" End With .EndUpdate End With |
635 |
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 2)
With Tree1 .BeginUpdate With .VisualAppearance .Add 1,"XP:TREEVIEW 2 1" .Add 2,"XP:TREEVIEW 2 2" End With .Background(180) = &H1000000 .Background(181) = &H2000000 .LinesAtRoot = -1 .Columns.Add "Column" With .Items h = .AddItem("Root 1") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True h = .AddItem("Root 2") .InsertItem h,,"Child" End With .EndUpdate End With |
634 |
How can I find if the control is running in DPI mode
With Tree1 Debug.Print( .FormatABC("dpi = 1 ? `normal/stretch mode` : `dpi mode`") ) End With |
633 |
How can I change the visual appearance of the +/- buttons (method 1)
With Tree1 .BeginUpdate With .VisualAppearance .Add 1,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _ "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _ "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _ "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" & _ "XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" & _ "gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" & _ "INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=" .Add 2,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _ "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _ "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _ "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" & _ "eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" & _ "FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" & _ "JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI=" End With .LinesAtRoot = -1 .Background(180) = &H1000000 .Background(181) = &H2000000 .Columns.Add "Column" With .Items h = .AddItem("Root 1") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True h = .AddItem("Root 2") .InsertItem h,,"Child" End With .EndUpdate End With |
632 |
I am using single selection, the question is if possible to select an item only when the user releases the mouse, as currently it selects the item as soon as the user clicks it
' SelectionChanged event - Fired after a new item has been selected. Private Sub Tree1_SelectionChanged() With Tree1 Debug.Print( "SelectionChanged" ) End With End Sub With Tree1 .BeginUpdate .FreezeEvents True .SingleSel = True .SelectOnRelease = True .Columns.Add("Column").FormatColumn = "1 apos `A-Z`" With .Items .AddItem "" .SelectItem(.AddItem("")) = True .AddItem "" End With .FreezeEvents False .EndUpdate End With |
631 |
Is it possible to select nothing
' SelectionChanged event - Fired after a new item has been selected. Private Sub Tree1_SelectionChanged() With Tree1 Debug.Print( "SelectionChanged" ) End With End Sub With Tree1 .BeginUpdate .FreezeEvents True .AllowSelectNothing = True .Columns.Add("Column").FormatColumn = "1 apos `A-Z`" With .Items .AddItem "" .SelectItem(.AddItem("")) = True .AddItem "" End With .FreezeEvents False .EndUpdate End With |
630 |
How can I specify the color for control's selection when it loses the focus
With Tree1 .BeginUpdate With .Columns.Add("") .AllowSizing = False .AllowDragging = False .AllowSort = False .Width = 24 .Def(2) = True End With .Columns.Add("Column").FormatColumn = "1 apos `A-Z`" With .Items .AddItem "" .SelectItem(.AddItem("")) = True .AddItem "" End With .Background(166) = RGB(196,196,196) .Background(167) = RGB(0,0,1) .EndUpdate End With |
629 |
How can I change the background color for checked items (EBN color, frame)
' CellStateChanged event - Fired after cell's state has been changed. Private Sub Tree1_CellStateChanged(ByVal Item As Long,ByVal ColIndex As Long) With Tree1 .Refresh End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 .SelBackMode = 1 .DefaultItemHeight = 22 With .Columns.Add("Tasks") .Def(0) = True .PartialCheck = True End With With .VisualAppearance .Add 2,"gBFLBCJwBAEHhEJAAEhABUkIQAAYAQGKIcBiAKBQAGYBIJDEMQ3DjAUBjMK4ZwTC4AIQjCK4JDKHYJRpHEZgLBMJAAGIZYhhUYRUiYMkiJBGGDIDiGGI2SJAcbTVIEc" & _ "x9EyUJSgSTJOjCMokTTIU4TTLYASbJafJJhWSaAiyMouDIOMg1BDNIw/Hika6jOgKUisNJXRzWIBTbDlOQ3JqnbCjOQRSrQBoNDAMAiiaKlbwJPK9RoieQXfwUAJrXJc" & _ "FqXFSLVxNBKAQEBA=" .Add 1,"CP:2 1 1 -1 -1" End With With .ConditionalFormats.Add("%CS0 = 1") .BackColor = &H1000000 End With .HeaderVisible = 1 With .Items h = .AddItem("Project") hChild = .InsertItem(h,,"Task 1") .SelectItem(hChild) = True hChild = .InsertItem(h,,"Task 2") .CellState(hChild,0) = 1 hChild = .InsertItem(h,,"Task 3") .CellState(hChild,0) = 1 .ExpandItem(h) = True End With .EndUpdate End With |
628 |
How can I change the caption of the checked items (sample 2)
With Tree1 .BeginUpdate .LinesAtRoot = -1 With .Columns.Add("Tasks") .Def(0) = True .PartialCheck = True .Def(17) = 1 .FormatColumn = "%CS0 = 1 ? `<bgcolor=000000><fgcolor=FFFFFF> ` + value + ` </fgcolor></bgcolor>` : value" End With .HeaderVisible = 1 With .Items h = .AddItem("Project") hChild = .InsertItem(h,,"Task 1") .SelectItem(hChild) = True hChild = .InsertItem(h,,"Task 2") .CellState(hChild,0) = 1 hChild = .InsertItem(h,,"Task 3") .CellState(hChild,0) = 1 .ExpandItem(h) = True End With .EndUpdate End With |
627 |
How can I change the caption of the checked items (sample 1)
With Tree1 .BeginUpdate .LinesAtRoot = -1 With .Columns.Add("Tasks") .Def(0) = True .PartialCheck = True .Def(17) = 1 .FormatColumn = "value + (%CS0 = 1 ? `<r><fgcolor=808080>(checked)` : ``)" End With .HeaderVisible = 1 With .Items h = .AddItem("Project") hChild = .InsertItem(h,,"Task 1") .SelectItem(hChild) = True hChild = .InsertItem(h,,"Task 2") .CellState(hChild,0) = 1 hChild = .InsertItem(h,,"Task 3") .CellState(hChild,0) = 1 .ExpandItem(h) = True End With .EndUpdate End With |
626 |
How can I change the font for the checked items
' CellStateChanged event - Fired after cell's state has been changed. Private Sub Tree1_CellStateChanged(ByVal Item As Long,ByVal ColIndex As Long) With Tree1 .Refresh End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 .DefaultItemHeight = 22 With .Columns.Add("Tasks") .Def(0) = True .PartialCheck = True End With With .ConditionalFormats.Add("%CS0 = 1") Set f = CreateObject("StdFont") With f .Name = Tree1.Font.Name .Size = 12 End With .Font = f End With .HeaderVisible = 1 With .Items h = .AddItem("Project") hChild = .InsertItem(h,,"Task 1") .SelectItem(hChild) = True hChild = .InsertItem(h,,"Task 2") .CellState(hChild,0) = 1 hChild = .InsertItem(h,,"Task 3") .CellState(hChild,0) = 1 .ExpandItem(h) = True End With .EndUpdate End With |
625 |
How can I bold the checked items
' CellStateChanged event - Fired after cell's state has been changed. Private Sub Tree1_CellStateChanged(ByVal Item As Long,ByVal ColIndex As Long) With Tree1 .Refresh End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 With .Columns.Add("Tasks") .Def(0) = True .PartialCheck = True End With With .ConditionalFormats.Add("%CS0 = 1") .Bold = True End With .HeaderVisible = 1 With .Items h = .AddItem("Project") hChild = .InsertItem(h,,"Task 1") .SelectItem(hChild) = True hChild = .InsertItem(h,,"Task 2") .CellState(hChild,0) = 1 hChild = .InsertItem(h,,"Task 3") .CellState(hChild,0) = 1 .ExpandItem(h) = True End With .EndUpdate End With |
624 |
How can I change the foreground color for checked items
' CellStateChanged event - Fired after cell's state has been changed. Private Sub Tree1_CellStateChanged(ByVal Item As Long,ByVal ColIndex As Long) With Tree1 .Refresh End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 .SelBackMode = 1 With .Columns.Add("Tasks") .Def(0) = True .PartialCheck = True End With With .ConditionalFormats.Add("%CS0 = 1") .ForeColor = RGB(255,128,128) End With .HeaderVisible = 1 With .Items h = .AddItem("Project") hChild = .InsertItem(h,,"Task 1") .SelectItem(hChild) = True hChild = .InsertItem(h,,"Task 2") .CellState(hChild,0) = 1 hChild = .InsertItem(h,,"Task 3") .CellState(hChild,0) = 1 .ExpandItem(h) = True End With .EndUpdate End With |
623 |
How can I change the background color for checked items (solid color)
' CellStateChanged event - Fired after cell's state has been changed. Private Sub Tree1_CellStateChanged(ByVal Item As Long,ByVal ColIndex As Long) With Tree1 .Refresh End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 .SelBackMode = 1 With .Columns.Add("Tasks") .Def(0) = True .PartialCheck = True End With With .ConditionalFormats.Add("%CS0 = 1") .BackColor = RGB(255,128,128) End With .HeaderVisible = 1 With .Items h = .AddItem("Project") hChild = .InsertItem(h,,"Task 1") .SelectItem(hChild) = True hChild = .InsertItem(h,,"Task 2") .CellState(hChild,0) = 1 hChild = .InsertItem(h,,"Task 3") .CellState(hChild,0) = 1 .ExpandItem(h) = True End With .EndUpdate End With |
622 |
How can I export the cell's state as well
With Tree1 .BeginUpdate With .Columns .Add("C1").Def(0) = True .Add("C2").FormatColumn = "1 index `A-Z`" .Add("C3").FormatColumn = "100 index ``" End With With .Items .AddItem "Item 1" .CellState(.AddItem("Item 2")) = 1 .CellState(.AddItem("Item 3")) = 1 End With .EndUpdate Debug.Print( "Export CSV Items including Check-State:" ) .BeginUpdate With .Columns.Add("Check") .Position = 0 .FormatColumn = "%CS0" End With Debug.Print( .Export("") ) .Columns.Remove "Check" .EndUpdate End With |
621 |
The BeforeExpandItem event is fired when clicking the drop down filter button. What we can do to prevent that (method 2)
' BeforeExpandItem event - Fired before an item is about to be expanded (collapsed). Private Sub Tree1_BeforeExpandItem(ByVal Item As Long,Cancel As Variant) With Tree1 Debug.Print( "BeforeExpandItem" ) Debug.Print( Item ) Debug.Print( "ColumnFromPoint" ) Debug.Print( .ColumnFromPoint(-1,-1) ) Debug.Print( "ColumnFromPoint return -1, if the user clicks the +/- glitch, else it returns the index of the column where the click occurs." ) .Items.InsertItem Item,,"new child" End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 With .Columns .Add("Items").DisplayFilterButton = True End With With .Items .ItemHasChildren(.InsertItem(,,"Group 1")) = True .ItemHasChildren(.InsertItem(,,"Group 2")) = True End With .EndUpdate End With |
620 |
The BeforeExpandItem event is fired when clicking the drop down filter button. What we can do to prevent that (method 1)
' BeforeExpandItem event - Fired before an item is about to be expanded (collapsed). Private Sub Tree1_BeforeExpandItem(ByVal Item As Long,Cancel As Variant) With Tree1 Debug.Print( "BeforeExpandItem" ) Debug.Print( Item ) .Items.InsertItem Item,,"new child" End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 With .Columns With .Add("Items") .DisplayFilterButton = True .FilterList = 4 End With End With With .Items .ItemHasChildren(.InsertItem(,,"Group 1")) = True .ItemHasChildren(.InsertItem(,,"Group 2")) = True End With .EndUpdate End With |
619 |
How do I change the drop down filter icon/button (black)
With Tree1 .BeginUpdate With .VisualAppearance .Add 1,"gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQ" & _ "gmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYTh" & _ "dr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA" End With .Background(32) = -1 .Background(0) = &H1000000 .Background(26) = RGB(0,0,1) .Background(27) = RGB(255,255,255) .Description(25) = "<bgcolor 0><fgcolor ffffff> Exclude </fgcolor></bgcolor>" .HeaderAppearance = 0 .BackColorHeader = RGB(0,0,0) .ForeColorHeader = RGB(255,255,255) .HeaderVisible = True .BackColorLevelHeader = .BackColor With .Columns.Add("Filter") .FilterList = 8448 ' FilterListEnum.exShowExclude Or FilterListEnum.exShowCheckBox .DisplayFilterButton = True .AllowSort = False .AllowDragging = False End With With .Items .AddItem "One" .AddItem "Two" .AddItem "Three" End With .EndUpdate End With |
618 |
How do I change the drop down filter icon/button (white)
With Tree1 .BeginUpdate With .VisualAppearance .Add 2,"gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgAN" & _ "J0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8Y" & _ "NYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4" & _ "hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mg" & _ "bhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhW" & _ "BMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=" .Add 1,"CP:2 -14 -4 -2 4" End With .Background(0) = &H1000000 .Background(32) = .BackColor .HeaderAppearance = 0 .BackColorHeader = RGB(255,255,255) .HeaderVisible = True .HeaderHeight = 24 .BackColorLevelHeader = .BackColor With .Columns.Add("Filter") .DisplayFilterButton = True .AllowSort = False .AllowDragging = False End With .EndUpdate End With |
617 |
Do you have any Fit-To-Page options when printing the control (W x T, Fit-To )
With Tree1 .BeginUpdate .ColumnAutoResize = False .ContinueColumnScroll = False Set rs = CreateObject("ADOR.Recordset") With rs .Open "Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExTree\Sample\Access\sample.accdb",3,3 End With .DataSource = rs .EndUpdate With CreateObject("Exontrol.Print") .Options = "FitToPage =2 x 1" .PrintExt = Tree1.Object .Preview End With End With |
616 |
Do you have any Fit-To-Page options when printing the control ( x T, Fit-To Tall )
With Tree1 .BeginUpdate .ColumnAutoResize = False .ContinueColumnScroll = False Set rs = CreateObject("ADOR.Recordset") With rs .Open "Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExTree\Sample\Access\sample.accdb",3,3 End With .DataSource = rs .EndUpdate With CreateObject("Exontrol.Print") .Options = "FitToPage = x 2" .PrintExt = Tree1.Object .Preview End With End With |
615 |
Do you have any Fit-To-Page options when printing the control ( W x, Fit-To Wide )
With Tree1 .BeginUpdate .ColumnAutoResize = False .ContinueColumnScroll = False Set rs = CreateObject("ADOR.Recordset") With rs .Open "Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExTree\Sample\Access\sample.accdb",3,3 End With .DataSource = rs .EndUpdate With CreateObject("Exontrol.Print") .Options = "FitToPage = 2 x" .PrintExt = Tree1.Object .Preview End With End With |
614 |
Do you have any Fit-To-Page options when printing the control ( percent view, Adjust-To )
With Tree1 .BeginUpdate .ColumnAutoResize = False .ContinueColumnScroll = False Set rs = CreateObject("ADOR.Recordset") With rs .Open "Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExTree\Sample\Access\sample.accdb",3,3 End With .DataSource = rs .EndUpdate With CreateObject("Exontrol.Print") .Options = "FitToPage = 50%" .PrintExt = Tree1.Object .Preview End With End With |
613 |
How do I prevent changing the cell's state ( check-box state )
' CellStateChanging event - Fired before cell's state is about to be changed. Private Sub Tree1_CellStateChanging(ByVal Item As Long,ByVal ColIndex As Long,NewState As Long) With Tree1 With .Items NewState = .CellState(Item,ColIndex) End With End With End Sub With Tree1 .BeginUpdate .LinesAtRoot = -1 With .Columns.Add("P1") .Def(0) = True .PartialCheck = True End With With .Columns.Add("P2") .Def(0) = True .PartialCheck = True End With With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True End With .EndUpdate End With |
612 |
How can I use the CellState with ConditionalFormat/ComputedField/FormatColumn
' CellStateChanged event - Fired after cell's state has been changed. Private Sub Tree1_CellStateChanged(ByVal Item As Long,ByVal ColIndex As Long) End Sub With Tree1 .BeginUpdate .LinesAtRoot = 4 .SelBackMode = 1 With .Columns.Add("Items") .Def(0) = True .PartialCheck = True End With With .Columns.Add("Format") .FormatColumn = "%CS0" .Caption = .FormatColumn .Def(5) = 8421504 .Def(8) = .Def(5) End With With .Items h = .AddItem("Root") .InsertItem h,,"Item 1" .CellState(.InsertItem(h,,"Item 2"),0) = 1 .CellState(.InsertItem(h,,"Item 3"),0) = 1 .ExpandItem(h) = True End With .EndUpdate End With |
611 |
How can I use the CellData with ConditionalFormat/ComputedField/FormatColumn
With Tree1 .BeginUpdate .Columns.Add "Items" With .Columns.Add("Format") .FormatColumn = "%CD0" .Caption = .FormatColumn .Def(5) = 8421504 .Def(8) = .Def(5) End With With .Items .CellData(.AddItem("Item 1"),0) = 1234 .CellData(.AddItem("Item 2"),0) = "this is just an user data" .CellData(.AddItem("Item 3"),0) = #1/1/2001# End With .EndUpdate End With |
610 |
How can I use the CellCaption with ConditionalFormat/ComputedField/FormatColumn
With Tree1 .BeginUpdate .Columns.Add "Items" With .Columns.Add("Format") .FormatColumn = "%0" .Caption = .FormatColumn .Def(5) = 8421504 .Def(8) = .Def(5) .Width = 96 .AllowSizing = False End With With .Columns.Add("Format") .FormatColumn = "%C0" .Caption = .FormatColumn .Def(5) = 8421504 .Def(8) = .Def(5) .Width = 96 .AllowSizing = False End With With .Items .AddItem 1 h = .AddItem(0) .CellCaption(h,0) = "<b>HTML</b> Text" .CellCaptionFormat(h,0) = 1 .AddItem 2 End With .EndUpdate End With |
609 |
Can I display the radio-button with a solid color
With Tree1 .BeginUpdate .RadioImage(0) = 32699122 .RadioImage(1) = 16777216 .Columns.Add("Check").Def(1) = True With .Items .AddItem "Radio 1" .CellState(.AddItem("Radio 2"),0) = 1 .AddItem "Radio 1" End With .EndUpdate End With |
608 |
Can I display the check-box with a solid color
With Tree1 .BeginUpdate .CheckImage(0) = 32699122 .CheckImage(1) = 16777216 .Columns.Add("Check").Def(0) = True With .Items .AddItem "Check 1" .CellState(.AddItem("Check 2"),0) = 1 .AddItem "Check 3" End With .EndUpdate End With |
607 |
Can I display the column's multiple-lines caption vertically oriented (method 2)
With Tree1 .BeginUpdate .HeaderHeight = 48 .ColumnAutoResize = True With .Columns .Add "And others ..." With .Add("") .HTMLCaption = "First Column" .HeaderVertical = True .Width = 36 .AllowSizing = False .Def(0) = True .Def(48) = 8 .Position = 0 End With With .Add("") .HTMLCaption = "<c><b>Second Column" .HeaderVertical = True .Width = 36 .AllowSizing = False .Def(0) = True .Def(48) = 8 .Position = 1 End With With .Add("") .HTMLCaption = "<r>Third Column" .HeaderVertical = True .Width = 36 .AllowSizing = False .Def(0) = True .Def(48) = 8 .Position = 2 End With End With With .Items .CellState(.AddItem("Item 1"),3) = 1 .CellState(.AddItem("Item 2"),2) = 1 .CellState(.AddItem("Item 3"),1) = 1 End With .EndUpdate End With |
606 |
Can I display the column's multiple-lines caption vertically oriented (method 1)
With Tree1 .BeginUpdate .HeaderHeight = 48 .HeaderSingleLine = False .ColumnAutoResize = True With .Columns .Add "And others ..." With .Add("First Column") .HeaderVertical = True .Width = 36 .AllowSizing = False .Def(0) = True .Def(48) = 8 .Position = 0 End With With .Add("Second Column") .HeaderBold = True .HeaderVertical = True .Width = 36 .AllowSizing = False .Def(0) = True .Def(48) = 8 .Position = 1 End With With .Add("Third Column") .HeaderVertical = True .Width = 36 .AllowSizing = False .Def(0) = True .Def(48) = 8 .Position = 2 End With End With With .Items .CellState(.AddItem("Item 1"),3) = 1 .CellState(.AddItem("Item 2"),2) = 1 .CellState(.AddItem("Item 3"),1) = 1 End With .EndUpdate End With |
605 |
Can I display the column's caption vertically oriented (method 2)
With Tree1 .BeginUpdate .HeaderHeight = 48 .ColumnAutoResize = True With .Columns .Add "And others ..." With .Add("") .HTMLCaption = "First" .HeaderVertical = True .Width = 20 .AllowSizing = False .Def(0) = True .Position = 0 End With With .Add("") .HTMLCaption = "<c><b>Second" .HeaderVertical = True .Width = 20 .AllowSizing = False .Def(0) = True .Position = 1 End With With .Add("") .HTMLCaption = "<r>Third" .HeaderVertical = True .Width = 20 .AllowSizing = False .Def(0) = True .Position = 2 End With End With With .Items .CellState(.AddItem("Item 1"),3) = 1 .CellState(.AddItem("Item 2"),2) = 1 .CellState(.AddItem("Item 3"),1) = 1 End With .EndUpdate End With |
604 |
Can I display the column's caption vertically oriented (method 1)
With Tree1 .BeginUpdate .HeaderHeight = 48 .ColumnAutoResize = True With .Columns .Add "And others ..." With .Add("First") .HeaderVertical = True .Width = 20 .AllowSizing = False .Def(0) = True .Position = 0 End With With .Add("Second") .HeaderBold = True .HeaderVertical = True .Width = 20 .AllowSizing = False .Def(0) = True .Position = 1 End With With .Add("Third") .HeaderVertical = True .Width = 20 .AllowSizing = False .Def(0) = True .Position = 2 End With End With With .Items .CellState(.AddItem("Item 1"),3) = 1 .CellState(.AddItem("Item 2"),2) = 1 .CellState(.AddItem("Item 3"),1) = 1 End With .EndUpdate End With |
603 |
How do I automatically bold items being checked
' CellStateChanged event - Fired after cell's state has been changed. Private Sub Tree1_CellStateChanged(ByVal Item As Long,ByVal ColIndex As Long) End Sub With Tree1 .BeginUpdate .SelBackMode = 1 With .ConditionalFormats.Add("%CS0","check") .Bold = True End With .Columns.Add("Items").Def(0) = True .Columns.Add(Tree1.ConditionalFormats.Item("check").Expression).FormatColumn = Tree1.ConditionalFormats.Item("check").Expression With .Items .AddItem "Item 1" .CellState(.AddItem("Item 2"),0) = 1 .AddItem "Item 3" End With .EndUpdate End With |
602 |
How can I include the child items, when a filter is applied
With Tree1 .BeginUpdate .ColumnAutoResize = True .ContinueColumnScroll = 0 .MarkSearchColumn = False .SearchColumnIndex = 1 .Indent = 16 .LinesAtRoot = -1 .FilterBarPromptVisible = True ' True .FilterBarPromptPattern = "Nancy" .FilterInclude = 1 With .Columns .Add("Name").Width = 96 .Add("Title").Width = 96 .Add "City" End With With .Items h0 = .AddItem("Nancy Davolio") .CellCaption(h0,1) = "Sales Representative" .CellCaption(h0,2) = "Seattle" h0 = .InsertItem(h0,,"Andrew Fuller") .CellCaption(h0,1) = "Vice President, Sales" .CellCaption(h0,2) = "Tacoma" h0 = .InsertItem(h0,,"Michael Suyama") .CellCaption(h0,1) = "Sales Representative" .CellCaption(h0,2) = "London" h0 = .AddItem("Janet Leverling") .CellCaption(h0,1) = "Sales Representative" .CellCaption(h0,2) = "Kirkland" h0 = .InsertItem(h0,,"Margaret Peacock") .CellCaption(h0,1) = "Sales Representative" .CellCaption(h0,2) = "Redmond" End With .ApplyFilter .EndUpdate End With |
601 |
How do I get sorted the column as string, numeric, date, date and time. Also how can it be applied to drop down filter panel
With Tree1 .BeginUpdate With .Columns.Add("Date") .SortType = 2 .DisplayFilterButton = True .DisplayFilterPattern = False .DisplayFilterDate = True .FilterList = 1296 ' FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsDesc End With With .Columns.Add("DateTime") .SortType = 3 .DisplayFilterButton = True .DisplayFilterPattern = False .FilterList = 1296 ' FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsDesc End With With .Columns.Add("Time") .SortType = 4 .DisplayFilterButton = True .DisplayFilterPattern = False .FilterList = 1296 ' FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsDesc .FormatColumn = "time(value)" End With With .Columns.Add("Numeric") .SortType = 1 .DisplayFilterButton = True .FilterList = 1296 ' FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsDesc End With With .Columns.Add("String") .DisplayFilterButton = True .FilterList = 1296 ' FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox Or FilterListEnum.exSortItemsDesc End With With .Items h = .AddItem(#1/27/2010#) .CellCaption(h,1) = #1/27/2010 10:00:00 AM# .CellCaption(h,2) = .CellCaption(h,1) .CellCaption(h,3) = 1 .CellCaption(h,4) = .CellCaption(h,3) h = .AddItem(#1/27/2011#) .CellCaption(h,1) = #1/27/2011 9:00:00 AM# .CellCaption(h,2) = .CellCaption(h,1) .CellCaption(h,3) = 11 .CellCaption(h,4) = .CellCaption(h,3) h = .AddItem(#11/2/2010#) .CellCaption(h,1) = #11/2/2010 9:00:00 AM# .CellCaption(h,2) = .CellCaption(h,1) .CellCaption(h,3) = 2 .CellCaption(h,4) = .CellCaption(h,3) End With .Columns.Item("DateTime").DisplayFilterDate = False .EndUpdate End With |