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
@thetnaing866 жыл бұрын
Nice tut. Based on this, I got one idea for my work. Thanks Daniel. You are my favorite mentor.
@ExcelVbaIsFun5 жыл бұрын
That's wonderful, great work, THET!
@luizrocha21465 жыл бұрын
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
@diyvba99946 жыл бұрын
Awesome video! I learned more about listboxes and for loops
@BDSJustOrgasmic4 жыл бұрын
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).
@andrewwest53444 жыл бұрын
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.
@JonathanExcels6 жыл бұрын
How would you sort the list in listbox2 and prevent duplicates?
@JCROD54 жыл бұрын
Thanks so much! Is working beautifully for my project.
@ExcelVbaIsFun4 жыл бұрын
Glad it helped!
@pablolagos89025 жыл бұрын
tyvm this helped me a lot!
@ExcelVbaIsFun5 жыл бұрын
So very welcome, pablo!
@adoniswalk6 жыл бұрын
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.
@adoniswalk6 жыл бұрын
i figured out my ask above... yay me.
@TalentedTeensOf19983 жыл бұрын
How do you do this for exact matches while ignoring commas?
@anilkumar0906 жыл бұрын
Hello sir can you plz tell how to save excel data in xml format with mail merge facility
@sirmacademy6 жыл бұрын
Sir, can you give us tutorial on how to insert text in multiple cells
@yasserhome6 жыл бұрын
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
@m22rdy6 жыл бұрын
I wish you would return to youtube again, i remember your wonderful competitions.
@kartickchakraborty79486 жыл бұрын
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.
@givemeapps1235 жыл бұрын
I feel like i have done everything you have said but it isnt populating anything in listbox2. Please help?
@ExcelVbaIsFun5 жыл бұрын
Hmmm. Can we see your code to try and assist? Thanks Dan
@givemeapps1235 жыл бұрын
@@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
@ExcelVbaIsFun5 жыл бұрын
It should be the same basic concept! Great job!!
@givemeapps1235 жыл бұрын
@@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.
@ExcelVbaIsFun5 жыл бұрын
@@givemeapps123 Sure! Please email me at excelvbaisfun@gmail.com. Thanks Dan
@krn142426 жыл бұрын
Thanks Daniel. I sent ya something. :)
@adoniswalk6 жыл бұрын
Can curVal be any made up name? Or is curVal a VBA thing?