Transfer values from lisbox to different shee
Solved/Closed
Related:
- Transfer values from lisbox to different shee
- Free fire transfer - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Ssh secure file transfer client download - Download - Remote access
- How to transfer contacts from sim to phone - Guide
- How to transfer google authenticator from phone to pc - Guide
5 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 28, 2010 at 05:57 PM
Jun 28, 2010 at 05:57 PM
First you dont have to ask for help from any specific person. There are many equally and even more competent people around here who might be able to help you.
About your issue, I am not sure what you want. If you are talking listbox on a form, then I did not see any form in your sample. if you are talking dropdrown on a cell, then I dont see how you would be able to do it as cell can only select one value.
You need to go into more detail
About your issue, I am not sure what you want. If you are talking listbox on a form, then I did not see any form in your sample. if you are talking dropdrown on a cell, then I dont see how you would be able to do it as cell can only select one value.
You need to go into more detail
Oh! Good to know for the next time. I will leave my questions open to everybody.
1. the listbox is in a form
2. I want the user to choose diferent values from the listbox at the same time, like when you do " Control" and select different cells, the only difference is thistime it would be a listbox or other tool.
3. As I said the user needs to choose different values at the same time from the listbox and then choose a Lane from a combo box.
4. All this changes would be save through the receive button. The receive button will transfer that info into that lane ( those lanes are spreadsheets).
I don't know if thistome I did it better :)
PS: In my example if you press the color button it will pop up the form and I know it would be more simple to understand
https://authentification.site/files/23169969/LANES.xlsx
Thanks
1. the listbox is in a form
2. I want the user to choose diferent values from the listbox at the same time, like when you do " Control" and select different cells, the only difference is thistime it would be a listbox or other tool.
3. As I said the user needs to choose different values at the same time from the listbox and then choose a Lane from a combo box.
4. All this changes would be save through the receive button. The receive button will transfer that info into that lane ( those lanes are spreadsheets).
I don't know if thistome I did it better :)
PS: In my example if you press the color button it will pop up the form and I know it would be more simple to understand
https://authentification.site/files/23169969/LANES.xlsx
Thanks
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 29, 2010 at 03:10 AM
Jun 29, 2010 at 03:10 AM
same as before. nothing is there other than data
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Hi again,
Here is the link:chttps://authentification.site/files/23169969/LANES.xlsx
In my example if you press the color button it will pop up the form and I know it would be more simple to understand
First. The listbox is in a form. I also know the listboxes has an option called selection typed, in my case I would like to select multiples lines at the lstbox not only want
2. I want the user to choose diferent values from the listbox at the same time, like when you do " Control" and select different cells, the only difference is thistime it would be a listbox or other tool.
3. As I said the user needs to choose different values at the same time from the listbox and then choose a Lane from a combo box.
4. All this changes would be save through the receive button. The receive button will transfer that info into that lane ( those lanes are spreadsheets).
Thanks, MOlie
Here is the link:chttps://authentification.site/files/23169969/LANES.xlsx
In my example if you press the color button it will pop up the form and I know it would be more simple to understand
First. The listbox is in a form. I also know the listboxes has an option called selection typed, in my case I would like to select multiples lines at the lstbox not only want
2. I want the user to choose diferent values from the listbox at the same time, like when you do " Control" and select different cells, the only difference is thistime it would be a listbox or other tool.
3. As I said the user needs to choose different values at the same time from the listbox and then choose a Lane from a combo box.
4. All this changes would be save through the receive button. The receive button will transfer that info into that lane ( those lanes are spreadsheets).
Thanks, MOlie
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 29, 2010 at 12:18 PM
Jun 29, 2010 at 12:18 PM
Try to download the file and press the button. You would get a message there there is no such macro. If you go to the VBE, you will see there is no form, there is no macro. Please upload a proper file.
Please help :(
Hi, really sorry this file has the macro working good.
https://authentification.site/files/23198021/Lanes.xls
Press the button 1 and it will pop up the userform1.
My first problem is, I don't know how to populate in a list box at the same time the columns A and B located on the tickets tab.
second, How can I do to make this list box so I can multiselect items at the same, like highlighting the items and with the transfer button, transfer it to the sheet that i select with a combo box
Please help me, I don;t know what to do
Hi, really sorry this file has the macro working good.
https://authentification.site/files/23198021/Lanes.xls
Press the button 1 and it will pop up the userform1.
My first problem is, I don't know how to populate in a list box at the same time the columns A and B located on the tickets tab.
second, How can I do to make this list box so I can multiselect items at the same, like highlighting the items and with the transfer button, transfer it to the sheet that i select with a combo box
Please help me, I don;t know what to do
Didn't find the answer you are looking for?
Ask a question
Hi this is an update of my file:
https://authentification.site/files/23199556/Lanes.xls
1 Question: In combobox 2 I have invoices repeated, How can I do so every time I press the combo box 2 only to show up the invoices one time not three times and so on. example: if the invoice repeats three times only show up one time and when the user choose that invoice it will sort the list box1.
2 Question: if you see the listbox 1 you can select multiple values, so when the user select the combobox1 the sheet he or she wants all the containers it would put all the selected containers in that sheet
https://authentification.site/files/23199556/Lanes.xls
1 Question: In combobox 2 I have invoices repeated, How can I do so every time I press the combo box 2 only to show up the invoices one time not three times and so on. example: if the invoice repeats three times only show up one time and when the user choose that invoice it will sort the list box1.
2 Question: if you see the listbox 1 you can select multiple values, so when the user select the combobox1 the sheet he or she wants all the containers it would put all the selected containers in that sheet
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 30, 2010 at 08:27 PM
Jun 30, 2010 at 08:27 PM
First you cannot select multiple values in a combo box in excel.
Your combo box 2 is not bound to any thing and does not show any data
Your combo box 2 is not bound to any thing and does not show any data
Hi,
Actually i do not want to select multiples values in a combo box, i only want to sort the listbox1 with values in combo box2. example:
Listobox1
A 123456
B 123456
C 393022
A 394023
B 303022
D 29202
The combobox2
A
B
B
A
B
D
i want to sort the listbox1 to show up only the records in combobox2, but I also want the combobox 2 to show up only values without repeating them like this
combobox2
A
B
D
I think I made myself more clear this time. thank you
Actually i do not want to select multiples values in a combo box, i only want to sort the listbox1 with values in combo box2. example:
Listobox1
A 123456
B 123456
C 393022
A 394023
B 303022
D 29202
The combobox2
A
B
B
A
B
D
i want to sort the listbox1 to show up only the records in combobox2, but I also want the combobox 2 to show up only values without repeating them like this
combobox2
A
B
D
I think I made myself more clear this time. thank you
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 2, 2010 at 12:25 PM
Jul 2, 2010 at 12:25 PM
close ?
