Listbox Selection To Fill Other Listbox From Sheet Entries

  Рет қаралды 21,098

ExcelVbaIsFun

ExcelVbaIsFun

Күн бұрын

Пікірлер: 30
@Feelsofafangirl
@Feelsofafangirl 2 жыл бұрын
this is exactly what I’ve been looking for. I wonder if its possible to have multiple column populated in Listbox2, say column c, d, e. Thanks
@thetnaing86
@thetnaing86 6 жыл бұрын
Nice tut. Based on this, I got one idea for my work. Thanks Daniel. You are my favorite mentor.
@ExcelVbaIsFun
@ExcelVbaIsFun 5 жыл бұрын
That's wonderful, great work, THET!
@luizrocha2146
@luizrocha2146 5 жыл бұрын
Great Video! It really helped me! But I have a question.. What if I need to select two or more itens from the first listbox? Can i generate I fill the other listbox with the selected itens? Please help me with it
@diyvba9994
@diyvba9994 6 жыл бұрын
Awesome video! I learned more about listboxes and for loops
@BDSJustOrgasmic
@BDSJustOrgasmic 4 жыл бұрын
Hi, thanks very much for your videos. I wonder how you would integrate a check for unique entries in your ListBox2 ? I mean : only add this item if it was not already added previously (my item in listbox1 can refer to the same item for listbox2).
@andrewwest5344
@andrewwest5344 4 жыл бұрын
great, i have a serious issue that I have been trying to resolve for a long time without success, but I wonder if your approach, which is different from mine, might be a solution.
@JonathanExcels
@JonathanExcels 6 жыл бұрын
How would you sort the list in listbox2 and prevent duplicates?
@JCROD5
@JCROD5 4 жыл бұрын
Thanks so much! Is working beautifully for my project.
@ExcelVbaIsFun
@ExcelVbaIsFun 4 жыл бұрын
Glad it helped!
@pablolagos8902
@pablolagos8902 5 жыл бұрын
tyvm this helped me a lot!
@ExcelVbaIsFun
@ExcelVbaIsFun 5 жыл бұрын
So very welcome, pablo!
@adoniswalk
@adoniswalk 6 жыл бұрын
nice video daniel. sometimes when i add the named range i get an error message "invalid property", after trying multiple times it'll finally take. not sure what i'm doing wrong, but it's finicky.. do you think you can do this video but add listbox item to a textbox? then if that textbox has data in it, keep that data, but add the listbox value to it too.
@adoniswalk
@adoniswalk 6 жыл бұрын
i figured out my ask above... yay me.
@TalentedTeensOf1998
@TalentedTeensOf1998 3 жыл бұрын
How do you do this for exact matches while ignoring commas?
@anilkumar090
@anilkumar090 6 жыл бұрын
Hello sir can you plz tell how to save excel data in xml format with mail merge facility
@sirmacademy
@sirmacademy 6 жыл бұрын
Sir, can you give us tutorial on how to insert text in multiple cells
@yasserhome
@yasserhome 6 жыл бұрын
Dear Sir please i need some help from you in vba excel in active sheet ( not user form ) i have to 2 command button ( activex control ) i need to make command button2 flash continuously when i click on the other command button 1 but not using for i to x number and when i click the command button2 ( flashing button ) the flash stop till i click on command button 1 and then i flash again So this is what i need hope to help me soon as posible thanks
@m22rdy
@m22rdy 6 жыл бұрын
I wish you would return to youtube again, i remember your wonderful competitions.
@kartickchakraborty7948
@kartickchakraborty7948 6 жыл бұрын
Hello Sir, Hi I'm Kartick from India. I like your videos very much. Can you please upload a video on how to convert a PDF file (That contains 200 to 300 pages) into a word file using VBA without compromising the layout and formatting? I have PDF Element professional. But, it can't retain the formatting. I've tried many other softwares. But none of them are able to convert the data from PDF to Microsoft Word with 100% accuracy and formatting & layout retention. Can you please do it through VBA? I'm in urgent need of it. Thank you.
@givemeapps123
@givemeapps123 5 жыл бұрын
I feel like i have done everything you have said but it isnt populating anything in listbox2. Please help?
@ExcelVbaIsFun
@ExcelVbaIsFun 5 жыл бұрын
Hmmm. Can we see your code to try and assist? Thanks Dan
@givemeapps123
@givemeapps123 5 жыл бұрын
@@ExcelVbaIsFun Hi, thanks for getting back. Managed to fix, somehow haha. Now i am trying to do the same from listbox2 to listbox3. Is it the same code or different? Thank you
@ExcelVbaIsFun
@ExcelVbaIsFun 5 жыл бұрын
It should be the same basic concept! Great job!!
@givemeapps123
@givemeapps123 5 жыл бұрын
@@ExcelVbaIsFun Ok, does that mean the coding is a little different? Is it possible to have 2 listboxes dictate what shows in a 3rd listbox? I am basically trying to recreate an info only 'form' in order to collate and navigate many prices for items. I cannot see an option to private message you with a screen shot of what i am trying to do.
@ExcelVbaIsFun
@ExcelVbaIsFun 5 жыл бұрын
@@givemeapps123 Sure! Please email me at excelvbaisfun@gmail.com. Thanks Dan
@krn14242
@krn14242 6 жыл бұрын
Thanks Daniel. I sent ya something. :)
@adoniswalk
@adoniswalk 6 жыл бұрын
Can curVal be any made up name? Or is curVal a VBA thing?
@derkaouiabdelkader7366
@derkaouiabdelkader7366 6 жыл бұрын
good
How to Combine Lists into One Dynamic Excel List
4:36
Excel Dictionary
Рет қаралды 15 М.
The Best Band 😅 #toshleh #viralshort
00:11
Toshleh
Рет қаралды 22 МЛН
Сестра обхитрила!
00:17
Victoria Portfolio
Рет қаралды 958 М.
Леон киллер и Оля Полякова 😹
00:42
Канал Смеха
Рет қаралды 4,7 МЛН
Filter Data into Listbox using two Combo-boxes data as Criteria
14:21
Dinesh Kumar Takyar
Рет қаралды 36 М.
Selecting Values with a Form Control Listbox on an Excel Worksheet
7:00
Excel VBA - List Box
5:02
TutorialsPoint
Рет қаралды 98 М.
VBA Listbox 1 Selected Items Move to Another Listbox 2
16:27
Haritha Computers & Technology
Рет қаралды 4 М.
Multiple ListBoxes in a Userform - Excel VBA
9:24
Online Pc Learning
Рет қаралды 12 М.
Fantastic Multi Select Listbox
8:29
Online Pc Learning
Рет қаралды 81 М.
Fully Dynamic List in Combobox of VBA
13:38
PK: An Excel Expert
Рет қаралды 212 М.
Listbox in Excel VBA - Userform Listbox Example
13:51
Excel Destination
Рет қаралды 51 М.
The Best Band 😅 #toshleh #viralshort
00:11
Toshleh
Рет қаралды 22 МЛН