I´m looking for a way to transfer data from listbox1 to listbox2, with dblclik, but both listboxes, have more than 10 columns. Do you have any video teaching something like that? Tks
Hi, I the code is working on my end. Thank you so much! However, when I pull out the form using a button from another sheet or using a button from the spreadsheet the combo box is missing its item, it is just leaving a blank option. Can you help me with this, please?
👍 good things here. I need some more help: I have created a data entry userform with which I search for records using criteria search. However, when I search by any non text column such as number and date column it is not able to search. How can I modify the code to search text, number, date and even a combination of any data type? Any idea kindly help
good video sir... I have a userform containing combobox for item name, text boxes for item code, hsn, uom, qty, rate, discount1 and discount2 and labels of calculation like cgst, sgst, igst, taxable, and gross total. in totality, around 14 column. now the trouble is to populate all these data in listbox, as listbox is allowing only 10 cloumn. can u please help me... thanks in adv.
@@Nsutradhar Welcome. I know little coding. Here in your example there are 2 field as search option. One is combobox and another is Texbox. Now if both will be Texbox then how to do coding. Is there any video you have? I was searching on your blog but I didn't get anything. 2 or more search box with results in list box. I did my project in MS access as I found easy. But the same I want to do in excel. My 3 search Texbox is "name of customers", "website", "country" And result list box has minimum 6 columns. I can edit the coding but I need one example video.. Thanks
Hi great video. I'm creating a formular in which I have included a listbox and I want the headers to be shown but when I activate the option the headers are in blank. What should I do to make them appear?
Does it work without the SearchData worksheet? I followed your procedure but it doesnt show in my listbox when i select the category and type the word in textbox. There's no error. Hope you can explain to me or help. This code need for my project.
No it doesn't work without SearchData Worksheet. If your column number is less than 10 then it will work without SearchData Worksheet. After all if you need this file then contact me at nsutradhar.cob@gmail.com Thank you
This is amazing!. However, i have a problem my listbox does not filter date and other numeric criteria. For example I can only filter "Product code" but not "Week Number" even if it is numeric criteria. I have tried with multiple IF but it works only with one criteria. I have to put Elseif to be able to search Week number but then I still can not search for Date. When I change Elseif to Date, I can not search for Week number.
I can send you my file with more than 1 million rows occupied. gyazo.com/bf8645cc4f61337c7ed0b2c8e7475529 Unfortunately your code is very difficult to understand, with all due respect.
@@omprakashsharma5749 when you click on search button, you can see all searched data from database and it will automatically store in SearchData sheet. If you need help you can contact at nsutradhar.cob@gmail.com
Start Microsoft Excel On the Menu Bar select "File" > "[Excel] Options" > "Trust Center" > "Trust Center Settings..." > "Macro Settings" In the top section, select the radio button for "Disable all macros with notification" In the bottom section, check the box for "Trust access to VBA project object model" Click "OK" and "OK" to save the settings Close Excel
Listbox with Rowsource is All In One❤❤
I´m looking for a way to transfer data from listbox1 to listbox2, with dblclik, but both listboxes, have more than 10 columns. Do you have any video teaching something like that? Tks
Hi, I the code is working on my end. Thank you so much! However, when I pull out the form using a button from another sheet or using a button from the spreadsheet the combo box is missing its item, it is just leaving a blank option. Can you help me with this, please?
Could you do a video where you can select the row and update the column
Ok, I will do
sort of confusing with not defining what is the database sheet containing and what the searchdata sheet was containing
you should make videos in your voice so that it is clearly understandable and the channel will grow and people will get help from you.
Thank you
👍 good things here. I need some more help: I have created a data entry userform with which I search for records using criteria search. However, when I search by any non text column such as number and date column it is not able to search. How can I modify the code to search text, number, date and even a combination of any data type? Any idea kindly help
For Date use like this
CDate(Me.TextBox1)
For number use
Me.TextBox1.Text
I appreciate alot, I am learning so much from your content
good video sir... I have a userform containing combobox for item name, text boxes for item code, hsn, uom, qty, rate, discount1 and discount2 and labels of calculation like cgst, sgst, igst, taxable, and gross total. in totality, around 14 column. now the trouble is to populate all these data in listbox, as listbox is allowing only 10 cloumn. can u please help me... thanks in adv.
My excel sheet table has some blank cells but in listbox it is showing zero instead of blank.how do i make it blank in listbox as well?
I will say "Excellent work".
Thank you
@@Nsutradhar Welcome. I know little coding. Here in your example there are 2 field as search option. One is combobox and another is Texbox. Now if both will be Texbox then how to do coding. Is there any video you have? I was searching on your blog but I didn't get anything.
2 or more search box with results in list box. I did my project in MS access as I found easy. But the same I want to do in excel.
My 3 search Texbox is "name of customers", "website", "country"
And result list box has minimum 6 columns.
I can edit the coding but I need one example video..
Thanks
Excellent work, Thank you so much, Sir.
i need to watching u make a code in a worksheet database & searchdata. can u help me?
Yes, first you see my videos from my channel where I uploaded many more about search data from database worksheet.
@@Nsutradhar ok i'll wach all of u videos suhu. thanks
Hi great video.
I'm creating a formular in which I have included a listbox and I want the headers to be shown but when I activate the option the headers are in blank. What should I do to make them appear?
Bro is that possible to paste the value in same sheet1 after filter
Yes, you can do this. Later I will send you an another file to your email which is already recorded to me.
Nsutradhar thank you so much
Excelent this is what i am looking for
If there is any video tutorial like this please mention me
I need your help
Does it work without the SearchData worksheet? I followed your procedure but it doesnt show in my listbox when i select the category and type the word in textbox. There's no error. Hope you can explain to me or help. This code need for my project.
No it doesn't work without SearchData Worksheet. If your column number is less than 10 then it will work without SearchData Worksheet. After all if you need this file then contact me at nsutradhar.cob@gmail.com
Thank you
@@Nsutradhar my column is only 8. I will send my file to your email. Appreciated your kind and sharing knowledge sir
Ok definitely I will assist you.
Request to view the below video.
I hope, you will find your answer
th-cam.com/video/zaPpkWYnAN4/w-d-xo.html
Thank you
@@Nsutradhar hi, I am having the same problem. Could you please send me the file too? I just sent email
@@Nsutradhar email you
Fantastic Guru.. you're amazing
This is amazing!. However, i have a problem my listbox does not filter date and other numeric criteria. For example I can only filter "Product code" but not "Week Number" even if it is numeric criteria. I have tried with multiple IF but it works only with one criteria. I have to put Elseif to be able to search Week number but then I still can not search for Date. When I change Elseif to Date, I can not search for Week number.
Hello 👋, I have similar issue, did you get solution to the problem? Kindly assist me . Thanks in advance
I would like to request this file, I am getting an error at some point regarding record source if condition part.
Ok check mail
Email please
@@Nsutradhar yojiaginuz002@gmail.com
Check email now
@@Nsutradhar please send as well the file to me. thank you so much
Hi sir thank you for this video I like it so much please send me file for practice
drive.google.com/uc?export=download&id=1enVbmIOLf5Iw2tGLwJW-6efre6X-VVl9
Or visit nsutradhar.blogspot.com
It says Run-Time error '438'
Object doesn't support this property or method
For an alternative in google sheets we can do simple trick like this:
th-cam.com/video/XOzRCwyCkdA/w-d-xo.html
Hi good day. your video is very helpful for my ongoing project. can you send me the file. thanks in advance
Visit my blog and send me your email address through contact me
nsutradhar.blogspot.com
@@Nsutradhar distritoclaudine27@gmail. com thanks a lot sir
Check email
hi sir. sorry but i haven't receive any email. coming from you.. please help to resend. thank you Nsutradhar
Ok, contact me at nsutradhar.cob@gmail.com
Is there a code to filter data in a listbox from a textbox with more than 1 million rows?
give me your email id, I will send you a file with more than 1 million data
@@Nsutradhar meme_star6@hotmail.com
I can send you my file with more than 1 million rows occupied.
gyazo.com/bf8645cc4f61337c7ed0b2c8e7475529
Unfortunately your code is very difficult to understand, with all due respect.
@@Nsutradhar Hello, I didn't receive your message...
need the file
hey can you send me the file please it's helpful on my project thx
Contact me at nsutradhar.cob@gmail.com
hey i send you a email thx for helping me
@@Nsutradhar it's working fine and it's verry nice great thanks
i want for every column search by keyword can you help me thx
i mean for 10 column
hey nice work and thanks for helping me great job
thx
orelio
Amazing!
Thank you so much, Sir.
Can I get this file and I already fill the form
Yes, Please follow the link below
nsutradhar.blogspot.com/p/display-search-results-in-listbox-with.html
@@Nsutradhar can I ask you something
@@Nsutradhar so after this output can we add search data in other sheet
@@omprakashsharma5749 when you click on search button, you can see all searched data from database and it will automatically store in SearchData sheet.
If you need help you can contact at nsutradhar.cob@gmail.com
@@Nsutradhar thank you
Brother, need practice file
Contact me at nsutradhar.cob@gmail.com
@@Nsutradhar ok vai
Sir is form ko full screen kaise kare
try this code
nsutradhar.blogspot.com/p/make-userform-full-screen-excel-vba.html
Boss Continue with
Super....
what is inside search data?
it'sgiving me "Run-time error 70. Permission Denied."
forms.gle/CQc2V7HgmaaycyKd9
Plz share code
nsutradhar.blogspot.com
I facing run time error 1004
Start Microsoft Excel
On the Menu Bar select "File" > "[Excel] Options" > "Trust Center" > "Trust Center Settings..." > "Macro Settings"
In the top section, select the radio button for "Disable all macros with notification"
In the bottom section, check the box for "Trust access to VBA project object model"
Click "OK" and "OK" to save the settings
Close Excel
@@Nsutradhar I am trying disable Marco but same problem please help
Eti Bangla vision hole valo hoi ar etir full video pls updated korun
sir Pls help me
Visit my blog and send me your email through contact me
nsutradhar.blogspot.com
Sir Amr mail I'd
rajadas9651@gmail.com
Sir pls give me this file
Sir pls help me..🙏🙏🙏
I already sent you the files,
If you didn't receive till now, then contact me at nsutradhar.cob@gmail.com
Thank you
Please email the file
Please go to nsutradhar.blogspot.com and download this file
Thank you
Useless effort
Why? If you need help, you can contact me.
@@Nsutradhar useless