This channel is dedicated to support the professional community through our experience sharing in Excel, VBA, Dashboard creation, Report generation and Automation techniques. Everything we offer here is freely available, and we don’t engage in any paid training or services.
Пікірлер
Sir please provide the dataset used for free? Dashboard is not free
Hello, many thanks for sharing the tutorials to us. I have gone through your tutorials and use your teaching to construct my Data Entry Form. But I counter an error which is "Subscript out of range". I have no idea how to fix this error. This error happens when I insert the command "ThisWorkbook.Sheets("SearchData").AutoFilterMode=False" in Call Add_SearchColumn. I hope you can give me some advice
Very helpful. Thanks brother ❤
❤❤
Thank You very much, clear explanation
Thanks for your feedback!
Hello Dear, Something strange occured. As soon as this code was writen in the MODULE1, everything stoped working →→ in the RESET part we add: Call Add_SearchColumn ThisWorkbook.Sheets("Database").AutoFilterMode = False ThisWorkbook.Sheets("SearchData").AutoFilterMode = False ThisWorkbook.Sheets("SearchData").Cells.Clear Now everything are stuck. with this line: ThisWorkbook.Sheets("SearchData").AutoFilterMode = False we have a →→ Run-tme error '9'Subscript out of range with this line: ThisWorkbook.Sheets("SearchData").Cells.Clear we have a →→ Run-tme error '9'Subscript out of range with this lines: Call Add_SearchColumn ThisWorkbook.Sheets("Database").AutoFilterMode = False Everything looks good. But when lauching a Research, it shows the →→ Run-tme error '9'Subscript out of range pointing the line →→ Set shSearchData = ThisWorkbook.Sheets("SearchData")
Hello Dear, In the SUBMIT section, in the MODULE1 How do you adapted the code for optFemale, as I have more than two Radio Buttons. Actually, there are six choices. Thanks a lot
Hello, you can use the GroupNameproperty to group related option buttons. Select all option and give the same group name.
Can I know the video on how to create this since I’m unable to find one
Please download the file. Link is provided in the description box.
It is giving me run time error 380
Please share the line of code where error is showing
Can someone give me the code to protect the start date ,end date and total time columns being edited by others
hello sir can we submit data to table
Yes, you can watch the tutorial on how to transfer data to the table. Thanks
@@thedatalabs submit data code for table is requested thanks
Any solution for Error "Named Argument not found "
Please share the line of code here
I appreciate you letting me download your file, sir. You are an honest individual. My day is complete because of you!
Thanks for your appreciation!
getting error :( Exception: Argument cannot be null: buttons
SEARCH function did not work
Having problem in COMPILE ERROR: Block If without End If.😢...help please
Seems you forgot to add 'End If' for 'IF' block you are using. Check and fix it. Thanks!
Object requirements show kr rha hai sir
Please share the line of code where this error is showing. Thanks!
Not free 😢
why cant' upload new video?
There is some issue with our KZread. We are working on it and will keep publishing tutorials and premium templates. Please keep supporting us. Thanks 🙏
I downloaded the latest version and I believe there is an issue as it not deducting weekly off. How to fix this issue
Will check and fix the issue. Thanks!
how to inset date in this data sheet
Tried to do this but got run-time error 1004, application-defined or object-defined error
I downloaded as a free tool in May, now I cannot find it and the link pushes me to a premium tool
Thanks for the wonderful guidance, i developed a same Macro with different Form, it is working fine. one doubt i could not share this File , where multiple can access this at a time
Thanks for your feedback! Please watch the multi user data entry video.
Is this substitute for Google form
Hi I've tried to replicate the code but everytime I try to upload image, Run-time error 52 pops up indicating the `If Dir(strfFolder, vbDirectory) = "" Then) as the error.Kindly help, appreciate your videos btw, great help as always ❤.
My calendar is available in pc😢
I didn't understand your question here. Could you please explain it?
Error "data member not found"
Can you please share the code where you are getting this error?
Am still waiting for the Form and i see how to create it...if you can share the file it would be of much help
gffI hathe
Thank you
Hi Dilip, thanks you so much for sharing your wealth of knowledge. I'm wondering whether you might know why my PDF files don't appear in the folder until I publish another file to pdf
Kindly someone tell me that From Where these two Columns Input has taken *Submitted By* and *Submitted On* ?
These columns are being updated through VBA code.
Can't download
Sorry for the inconvenience. Will fix the link. Thanks!
how can I have multiple dynamic combobox
Why you substracted purchase values from total sales to calculate revenue. Revenue itself says overall sales of a company. That means, Summing up the sales column gives you the total revenue of the organisation.
Hi! Quick question: When I press the Search button, my database sheet is filtering the data I'm searching but I'm getting the error 1004: Unable to get the Match property of the WorksheetFunction class to the code line: iCount = Application.WorksheetFunction.Match(sColumn, shDatabase.Range("A1:I1"), 0). Can someone help me with this? Thank you.
Not free
How can we lock the sheets? It’s still editable
Unfortunately, it can not be downloaded for free and asking for payment. 😅
😅😅
Perhaps I didn't follow correctly but at the moment I, "try" the button I get an error msg, "Microsoft Visual Basic Run-time error '380': Could not set the RowSource property. Invalid property value." Any suggestions? Thank you.
Hai bro...for me while press play its showing run-time error‘424’. object required..please help to solve this issue💐
good , saudi riyad.
Thanks for your feedback!
Brother I got error in this problem can u Plss correct it
Plzz in hindi
Thanks for your feedback!
but when you delete for example the data in (Serial No.) S No. 5, the the succeeding number which is number 6 will go up but it will not update to become number 5, why is this?
Hi ... I am getting Database Error - Either BOF or EOF is True or the current record has been deleted. Requested operation requires a current record.3021 Please Note- I follow the video and the correctly but still getting this entry As I am entering data on Userform and transferring it to MS Access Database At present the database is empty Please help in resolving the code
This tutorial is so easy to follow and fun! Thank you!
Glad it was helpful!
1st 5 mint are wasting Time