bensdb
02-07-2014, 03:02 PM
Hi.
PLEASE HELP ME. I have scoured the internet all day trying to do this and cannot find what I want.
I have a form with a number of listboxes > 2. Say for arguaments sake- 5 listboxes.
I then have a range of data on a worksheet with 5 columns. There is an ID Key in the first column. In the 3rd column will be a number corresponding to the total number of listboxes. So, as we have 5 listboxes, some of the entries will be labeled 1, some 2 , some labeled 3 etc....
Basically when I open the form, Listbox 1 should have all the entries with the corresponding 1 in column 3 of the worksheet, Listbox 2 should have all the entries with 2 etc.
Underneath each listbox will be a button saying 'move here'. The user should be able to select multiple entries in each listbox, and from several listboxes at once, then click a button underneath one of the listboxes and those entries will move there.
No I have tried lots of different methods today and have just ended up coming to the point of wanting to cry, after trying and failing all day. My lack of knowledge of array's is really a stumbling block.
I have got to the point of creating a form with my 5 listboxes that auto populate with the correct multi column values, corresponding to the number in column 3 of the data range.
One solution That I thought would be to copy all the selected values from the listboxes into a temporary sheet, change all the values in the 3rd column to the corresponding listbox, and then do a lookup of the ID in the original range and replace the corresponding data with the new listbox value, then update all listboxes.
Any help...please!!!!
PLEASE HELP ME. I have scoured the internet all day trying to do this and cannot find what I want.
I have a form with a number of listboxes > 2. Say for arguaments sake- 5 listboxes.
I then have a range of data on a worksheet with 5 columns. There is an ID Key in the first column. In the 3rd column will be a number corresponding to the total number of listboxes. So, as we have 5 listboxes, some of the entries will be labeled 1, some 2 , some labeled 3 etc....
Basically when I open the form, Listbox 1 should have all the entries with the corresponding 1 in column 3 of the worksheet, Listbox 2 should have all the entries with 2 etc.
Underneath each listbox will be a button saying 'move here'. The user should be able to select multiple entries in each listbox, and from several listboxes at once, then click a button underneath one of the listboxes and those entries will move there.
No I have tried lots of different methods today and have just ended up coming to the point of wanting to cry, after trying and failing all day. My lack of knowledge of array's is really a stumbling block.
I have got to the point of creating a form with my 5 listboxes that auto populate with the correct multi column values, corresponding to the number in column 3 of the data range.
One solution That I thought would be to copy all the selected values from the listboxes into a temporary sheet, change all the values in the 3rd column to the corresponding listbox, and then do a lookup of the ID in the original range and replace the corresponding data with the new listbox value, then update all listboxes.
Any help...please!!!!