Combination button/dropdown in office -


how add combination button/dropdown in office (see below). preferably code.

alt text

update: if helps any, code isn't needed.

you can it, based on following activex controls:

  • microsoft imagelist control, version 6
  • microsoft imagecombobox control, version 6

manually, select "more controls..." [control toolbox] menu bar , double click mentioned controls them on sheet. position combobox want be, , disregard position of imagelist, visible in design mode. have 2 embedded contros named

  • imagelist1
  • imagecombo1

the insertion of 2 components creates reference ...\system32\mscomctl32.ocx.

then you

  1. manually add icons (gif, bmp, etc) image list
  2. manually set combo's imagelist property "imagelist1"
  3. manually set combo's autoload property true

by have combo error no icons.

then execute code

sub fillcombo() dim sh worksheet, oo oleobjects, idx integer      set sh = activesheet     set oo = sh.oleobjects       oo("imagecombo1").object         .comboitems.clear         idx = 1 oo("imagelist1").object.listimages.count             .comboitems.add , , , idx         next idx     end  end sub

i've tried hard create objects vba, imagecombo seems behave different when created as

set sh = activesheet set oo = sh.oleobjects oo.add "mscomctllib.imagecomboctl.2" ' .... etc ....

the combo created, dropdown arrow not displayed no matter do, allthough debugger shows listview elements neatly attached. lots of colleagues seem have problems activex, there's loads of posting on net.

further reading here


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use
Read more