TheDataLabs

TheDataLabs

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.

Пікірлер

  • @pragatigoel3134
    @pragatigoel313421 сағат бұрын

    Sir please provide the dataset used for free? Dashboard is not free

  • @gokjohnny9581
    @gokjohnny95812 күн бұрын

    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

  • @robertspidey8136
    @robertspidey81363 күн бұрын

    Very helpful. Thanks brother ❤

  • @robertspidey8136
    @robertspidey81363 күн бұрын

    ❤❤

  • @sravanithudi5639
    @sravanithudi56394 күн бұрын

    Thank You very much, clear explanation

  • @thedatalabs
    @thedatalabs3 күн бұрын

    Thanks for your feedback!

  • @747imhotep
    @747imhotep6 күн бұрын

    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")

  • @747imhotep
    @747imhotep6 күн бұрын

    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

  • @thedatalabs
    @thedatalabs6 күн бұрын

    Hello, you can use the GroupNameproperty to group related option buttons. Select all option and give the same group name.

  • @priyankanamadevan2311
    @priyankanamadevan23118 күн бұрын

    Can I know the video on how to create this since I’m unable to find one

  • @thedatalabs
    @thedatalabs5 күн бұрын

    Please download the file. Link is provided in the description box.

  • @MrShon999
    @MrShon9998 күн бұрын

    It is giving me run time error 380

  • @thedatalabs
    @thedatalabs6 күн бұрын

    Please share the line of code where error is showing

  • @chantikk1085
    @chantikk10859 күн бұрын

    Can someone give me the code to protect the start date ,end date and total time columns being edited by others

  • @adisencetest
    @adisencetest10 күн бұрын

    hello sir can we submit data to table

  • @thedatalabs
    @thedatalabs8 күн бұрын

    Yes, you can watch the tutorial on how to transfer data to the table. Thanks

  • @adisencetest
    @adisencetest7 күн бұрын

    @@thedatalabs submit data code for table is requested thanks

  • @abhishekdhamanse
    @abhishekdhamanse11 күн бұрын

    Any solution for Error "Named Argument not found "

  • @thedatalabs
    @thedatalabs10 күн бұрын

    Please share the line of code here

  • @georgekiadii45
    @georgekiadii4513 күн бұрын

    I appreciate you letting me download your file, sir. You are an honest individual. My day is complete because of you!

  • @thedatalabs
    @thedatalabs13 күн бұрын

    Thanks for your appreciation!

  • @AshlyAlmogela
    @AshlyAlmogela14 күн бұрын

    getting error :( Exception: Argument cannot be null: buttons

  • @ORMINEMPLOYMENTFACILITATIONOO1
    @ORMINEMPLOYMENTFACILITATIONOO116 күн бұрын

    SEARCH function did not work

  • @teacherdanbactong675
    @teacherdanbactong67517 күн бұрын

    Having problem in COMPILE ERROR: Block If without End If.😢...help please

  • @thedatalabs
    @thedatalabs11 күн бұрын

    Seems you forgot to add 'End If' for 'IF' block you are using. Check and fix it. Thanks!

  • @raunakkatiyar1093
    @raunakkatiyar109317 күн бұрын

    Object requirements show kr rha hai sir

  • @thedatalabs
    @thedatalabs10 күн бұрын

    Please share the line of code where this error is showing. Thanks!

  • @PJParan
    @PJParan19 күн бұрын

    Not free 😢

  • @RobinMondol-ir3ml
    @RobinMondol-ir3ml20 күн бұрын

    why cant' upload new video?

  • @thedatalabs
    @thedatalabs5 күн бұрын

    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 🙏

  • @mangjas
    @mangjas21 күн бұрын

    I downloaded the latest version and I believe there is an issue as it not deducting weekly off. How to fix this issue

  • @thedatalabs
    @thedatalabs10 күн бұрын

    Will check and fix the issue. Thanks!

  • @gopikaexport4013
    @gopikaexport401323 күн бұрын

    how to inset date in this data sheet

  • @sunshineemano6679
    @sunshineemano667923 күн бұрын

    Tried to do this but got run-time error 1004, application-defined or object-defined error

  • @Salim-jp1sg
    @Salim-jp1sg23 күн бұрын

    I downloaded as a free tool in May, now I cannot find it and the link pushes me to a premium tool

  • @rvkrishnan78
    @rvkrishnan7824 күн бұрын

    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

  • @thedatalabs
    @thedatalabs24 күн бұрын

    Thanks for your feedback! Please watch the multi user data entry video.

  • @sunilfrancisp2523
    @sunilfrancisp252327 күн бұрын

    Is this substitute for Google form

  • @gemespenilla9145
    @gemespenilla914527 күн бұрын

    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 ❤.

  • @abhiachar7222
    @abhiachar722227 күн бұрын

    My calendar is available in pc😢

  • @thedatalabs
    @thedatalabs27 күн бұрын

    I didn't understand your question here. Could you please explain it?

  • @akaranaaivukal
    @akaranaaivukal27 күн бұрын

    Error "data member not found"

  • @thedatalabs
    @thedatalabs27 күн бұрын

    Can you please share the code where you are getting this error?

  • @Hmungu
    @Hmungu28 күн бұрын

    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

  • @hashimalsindee9113
    @hashimalsindee911329 күн бұрын

    gffI hathe

  • @mehdibakhtiari300
    @mehdibakhtiari300Ай бұрын

    Thank you

  • @user-cm9co3ob3g
    @user-cm9co3ob3gАй бұрын

    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

  • @pizzazonenadiad2429
    @pizzazonenadiad2429Ай бұрын

    Kindly someone tell me that From Where these two Columns Input has taken *Submitted By* and *Submitted On* ?

  • @thedatalabs
    @thedatalabs5 күн бұрын

    These columns are being updated through VBA code.

  • @dipokmodak8896
    @dipokmodak8896Ай бұрын

    Can't download

  • @thedatalabs
    @thedatalabsАй бұрын

    Sorry for the inconvenience. Will fix the link. Thanks!

  • @TGTube-ls8cm
    @TGTube-ls8cmАй бұрын

    how can I have multiple dynamic combobox

  • @PK-iu9nc
    @PK-iu9ncАй бұрын

    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.

  • @PopoyTanke
    @PopoyTankeАй бұрын

    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.

  • @Simz-dr5tb
    @Simz-dr5tbАй бұрын

    Not free

  • @nerlierosepangan584
    @nerlierosepangan584Ай бұрын

    How can we lock the sheets? It’s still editable

  • @myothiha6151
    @myothiha6151Ай бұрын

    Unfortunately, it can not be downloaded for free and asking for payment. 😅

  • @rku6449
    @rku644929 күн бұрын

    😅😅

  • @freepilot7732
    @freepilot7732Ай бұрын

    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.

  • @limoshbs
    @limoshbsАй бұрын

    Hai bro...for me while press play its showing run-time error‘424’. object required..please help to solve this issue💐

  • @FarukHossain-ux7bn
    @FarukHossain-ux7bnАй бұрын

    good , saudi riyad.

  • @thedatalabs
    @thedatalabs5 күн бұрын

    Thanks for your feedback!

  • @ashishkothari8469
    @ashishkothari8469Ай бұрын

    Brother I got error in this problem can u Plss correct it

  • @ravishankar-sg9ry
    @ravishankar-sg9ryАй бұрын

    Plzz in hindi

  • @thedatalabs
    @thedatalabs5 күн бұрын

    Thanks for your feedback!

  • @mrwatcherofmovies
    @mrwatcherofmoviesАй бұрын

    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?

  • @jaisilon
    @jaisilonАй бұрын

    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

  • @SheenaMauhay
    @SheenaMauhayАй бұрын

    This tutorial is so easy to follow and fun! Thank you!

  • @thedatalabs
    @thedatalabs8 күн бұрын

    Glad it was helpful!

  • @mstechnical1937
    @mstechnical1937Ай бұрын

    1st 5 mint are wasting Time