excel - Userforms with a listbox in VBA -


this first post on forum. have quick question regarding vba, userforms listbox. goal select 2 options , return list of names in listbox. have attached example userform , example table choosing from. appreciated.

worksheet

current vba userform

private sub listbox1_click()  sheets("trainers1").range("i2") = listbox1   end sub  private sub listbox2_click()  sheets("trainers1").range("i2") = listbox2   end sub  private sub listbox3_click()  sheets("trainers1").range("i3") = listbox3  end sub  private sub listbox4_change()  .listbox4 = sheets("trainers1").range("k2:k10")  end sub  private sub userform_initialize()  dim cnt dim cntr integer  cntr = application.worksheetfunction.counta(sheets("shift pattern key").range("a:a")) cnt = application.worksheetfunction.counta(sheets("training ratio").range("a:a"))  = 2 cntr   listbox2.additem sheets("shift pattern key").cells(i, 1)  next  i2 = 2 cnt  listbox3.additem sheets("training ratio").cells(i2, 1)  next i2  end sub

you iterate through rows of table , compare values in each row values selected. if both values in row match values selected user can use .additem method add name of employee list.


-

Comments

Post a Comment

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

sql - MySQL - Finding Empty relations -

i trying work out how full list of team leaders , team members our tables. including team leaders have no team. we have basic data structure have table person contains our basic person object. people extend table in details table. one of extended pieces of information have team_leader status. have 2 relevant details define this: detail_isteamleader , detail_teamleader . first boolean , defines short list of team leaders. second defines persons team leader (ideally subset). _person table_ person_id person_name _detail table_ detail_id detail_person_id detail_isteamleader detail_teamleader i can team leaders have team using following query: select tl.person_id tlref, tl.person_name tlname, per.person_id perref, per.person_name pername detail left outer join person per on detail.person = per.person_id left outer join person tl on detail_teamleader = tl.person_id order tlname, psname however, fails team_leaders detail.isteamleader true not occur in detail_teamleader...
Read more

linux - gzip: stdin: not in gzip format tar: Child returned status 1 tar: Error is not recoverable: exiting now -

i have bash script creates tar.gz , encrypts sends drive. cannot open .tar.gz afterwards. here process... bash script encrypts. #!/bin/sh # tar automysqlbackup directory tar -zcf "red-backup-$(date '+%y-%m-%d').tar.gz" /var/lib/automysqlbackup/ # encrypt tar openssl aes-256-cbc -a -salt -in "red-backup-$(date '+%y-%m-%d').tar.gz" -out "red-backup-$(date '+%y-%m-%d').tar.gz.enc" -pass 'pass:mysecretpwd' # remove original tar rm -rf "red-backup-$(date '+%y-%m-%d').tar.gz" # upload google drive gdrive upload --file "red-backup-$(date '+%y-%m-%d').tar.gz.enc" -p "jofhriout849uioejfoiu09" then download file , use sudo openssl aes-256-cbc -e -in red-backup-2016-09-22.tar.gz.enc -out red-backup-2016-09-22.tar.gz i enter passphrase file twice , file called red-backup-2016-09-22.tar.gz when try sudo tar -zxvf red-backup-2016-09-22.tar.gz and gzip: stdin: not ...
Read more