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?
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
👍 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.
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?
@@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
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.
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
Ok definitely I will assist you. Request to view the below video. I hope, you will find your answer ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zaPpkWYnAN4.html Thank you
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