I am aware how to populate a Listbox from other Listboxes etc. However, can anyone help with populating a Listbox which has been split into a number of columns, with soures coming from both other Listboxes, and Comboboxes.
Many thanks,
Andy
I am aware how to populate a Listbox from other Listboxes etc. However, can anyone help with populating a Listbox which has been split into a number of columns, with soures coming from both other Listboxes, and Comboboxes.
Many thanks,
Andy
Well I'm at a loss. Everywhere i've looked on google suggests that using columns in listboxes in a pain in the rear....
I've attached a copy of the userform that i have created for user to input their data. Basically what I want is for them to select the relevant data and then click "add" which will send the info to the listbox for review pending them clicking on "ok" to submit to the document.
Obviously there will be multiple lines of data.
I was thinking of using the listbox as the best method of the user being able to review what they have included prior to submission, however the box is only as wide as shown and it doesn't look if you can add horizontal scroll bars, as each entry combined will extend beyond the viewable area of the box.
I also wanted to show each element of the data in it's own column, with the exception of "Initials and Ref" where the textbox and combobox need to be concatenated into one column and "Seal" where the combobox and textbox need to be concatenated into a single column, however i'm guessing that this is not a show stopper as providing the data is shown it can be sumitted to the document in whatever format I choose.
Basically the listbox would look like something like shown below, where "|" denotes a column divide...
Initials(txtbox)Ref(cmbox)|Card(txtbox)=Docket(txtbox)|Seal(cmbox)(txtbox)|Description(txtbox)
Any help would be appreciated,
Cheers,
Andy
Can anyone help with this...
I don't know what the best way to achieve this? I'm not sure what the best method of letting the user review the information in the userform prior to sending it to document would be (listbox, textbox, or something else...)
I've attached another file as an example.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks