excel - unique values in combobox based on another combo box -


i adding unique values in combobox2 based on selection in combobox3. when implementing same code add unique values in combobox3 based on selection on combobox2, not working. replaced combobox2.value combobox3.value , column b column c.

private sub combobox1_change()  dim ws worksheet, _     dic object, _     rcell range, _     key string    set ws = worksheets("sheet1")   set dic = createobject("scripting.dictionary")   me.combobox2.clear 'clear added elements   me.combobox2.value = vbnullstring 'set active value empty string    '------here need tests-------   each rcell in ws.range("b2", ws.cells(rows.count, "b").end(xlup))     if rcell.offset(0, -1) <> me.combobox1.value     else         if not dic.exists(lcase(rcell.value))             dic.add lcase(rcell.value), nothing         end if     end if   next rcell    each key in dic     userform1.combobox2.additem key   next end sub


Comments

Post a Comment

Popular posts from this blog

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more

c++ - What does MSC in "// appease MSC" comments mean? -

i run across // appease msc in c++ comments, e.g. here : const int& array::operator[](int offset) const { int mysize = getitssize(); if (offset >= 0 && offset < getitssize()) return ptype[offset]; throw xboundary(); return ptype[offset]; // appease msc! } what msc stand ? the author means microsoft's compiler, more formally known msvc.
Read more

javascript - Add class to another page attribute using URL id - Jquery -

i have attached id url. ex: when click link 1 , has #tab-2 id , takes me landing page. in landing page have find element has #tab-2 id have add class .active . i tried no luck. please 1 correct code. thanks js fiddle link html <div class="menu"> <ul> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-2">link 1</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-44">link 2</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-74">link 3</a></li> </ul> </div> landing page <div class="tab"> <ul> <li><a id="tab-2" class="active" >link 1 content</a></li> <li><a id="tab-44" >link 2 content</a></li> <li><a id="tab-74" >link 3 content</a></l...
Read more