excel - Seach Column based on textbox value and display all results in Listbox -

-

i have 

listbox = firmlist;  textbox = firmgroupid;  worksheet = relatedfirms;  columna = gid (id numbers);  columnb = firmname

i trying populate list box based on value of firmgroupid.
have combobox populates gid number in firmgroupid depending on combobox selection.

i firmlist populate list of firmnames based on firmgroupid.

sheet relatedfirms contains assigned gid each firmname.

this seems simple try doesn't seem work.

not sure how show items in list box have value equals gid.

private sub firmgroupid_change()     dim rngname range     dim ws worksheet     dim integer      set ws = worksheets("relatedfirms")     = 1 ws.cells(ws.rows.count, 1).end(xlup).row step 1         if ws.cells(i, 1).value <> vbnullstring me.firmlist.additem         ws.cells(i, 1).value            next end sub

please change code:

if ws.cells(i, 1).value <> vbnullstring me.firmlist.additem ws.cells(i, 1).value

to

if ws.cells(i, 1).value = firmgroupid.value me.firmlist.additem ws.cells(i, 2).value

Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more