Filipino Tutorials- Learning VBA using excel and programming tips

Поділитися
Вставка
  • Опубліковано 8 лют 2025
  • Basic knowledge and Tutorials on how to create a Data Entry Form using Excel + Visual Basic Programming.
    • Tips and Tricks on Exc... - 10 useful tricks on excel
    • How to Recover Faceboo... - HACKING METHOD TO RECOVER YOUR FORGET PASSWORD
    • Pinoy Tutorials - Keyb... - USEFUL RUN COMMAND SHORTCUT
    • Pinoy Tutorials - Exce... - EXCEL VBA WITH MACRO HOW TO RECORD TUTORIALS
    • Paano Gumawa ng Log in... - HOW TO CREATE LOG IN SYSTEM- VERY EASY & SIMPLE CODE
    Don't Forget to Like and Subscribe for more coming tutorials....
    how to create data entry form in excel
    how to create data entry form in excel vba
    how to create data entry form in excel 2007
    how to create data entry form in microsoft excel
    how to create data entry form in excel 2016
    how to create data entry form in excel using vba
    how to create data entry form in excel - ms office
    how to create data entry form excel 2016
    how to create a data entry form in excel 365
    how to create a data entry form in visual basic 6.0
    excel macros شرح
    excel macro tutorial
    excel macros tutorial
    excel macro examples
    excel macro button
    excel macros for dummies
    excel macros examples
    excel macro i
    excel macro i loop
    excel macro i as variable
    for i excel macro
    macro excel se déplacer dans une feuille
    excel macro se ha producido el error 1004
    excel macro se déplacer d'une cellule
    excel macro set
    excel macro se ha producido el error 9
    macro excel s.c
    excel macro se cella contiene
    macro excel se cella vuota
    excel macro se requiere un objeto
    ctrl z excel macro
    excel macro command type 0
    excel macro .commandtype = 0
    excel macro #div 0 error
    excel macro delete 0
    excel macro remove 0
    excel macro error 0
    excel macro error commandtype = 0
    excel macro add leading 0
    excel macro filter out 0
    excel macro to hide 0
    excel macro 0
    remove 0 from excel macro
    excel macro 101
    excel macro 1004
    excel macro 1004 error
    excel macro 1 cell down
    excel macro 1004 application-defined or object-defined error
    excel macro 1 cel naar beneden
    excel macro 100 cpu
    excel macro 1 sheet
    excel macro 100
    excel macro 1004 hatası
    add 1 macro excel
    rc 1 excel macro
    macro 1 excel
    excel macro 2016
    excel macro 2019
    excel macro 2010
    excel macro 2007
    excel macro 2 dimensional array
    excel macro 2d array
    excel macro 2013
    excel macro 2016 pdf
    excel macro 2016 tutorial
    excel macro 2007 tutorial
    excel 2 macros 1 button
    excel 2 macro sheets
    excel 2 macro sheets and add-in files
    2 macros excel
    merge 2 macros excel
    excel macro 2 decimal places
    excel 2 sheet comparison macro
    compare 2 excel files macro
    compare 2 excel sheets macro
    excel macro 32 bit to 64 bit
    it excel llc reviews
    it excel templates
    it xcel consulting
    it excellence sp. z o.o
    i
    i'm excellent in french
    i excel in sentence
    it excellence awards
    it excellence awards 2019
    0 in excel
    0 in excel cell
    0 in excel disappear
    0 in excel error
    hide #div/0 in excel
    excel it activity 10 quiz scores
    it 11ga excel
    it-11 uma excel
    excel it activity 10
    excel it activity 12
    excel it activity 15 best buy
    it excel form 2018-19
    it form 16 excel format
    excel it activity 15
    excel it activity 14
    move it excel 2019
    fix it excel 2016
    fix it excel 2010
    excel it 2nd edition
    it 2 excel utility
    it txartela excel 2010 basico
    prove it excel 2013 power user test answers
    it txartela excel 2010 avanzado
    prove it excel 2010 test answers
    stick it excel 3d transparent dots
    fix it 3.6 excel 2016
    excel it activity 31
    fix it 3.6 excel
    excel it activity 30
    excel it activity 30 nba standings
    excel it activity 37 stocks
    excel it activity 34
    excel it activity 33 top 10 candy bars
    excel it activity 34 expense report
    excel it activity 4
    excel it activity 47 ringtones
    excel it activity 44 search engines
    excel it activity 45 iphone games
    excel it activity 44
    excel it activity 4 la lakers
    excel it activity 47
    excel it activity 48
    excel it activity 48 raise
    excel it activity 49 nba standings 2
    excel it activity 5
    excel it activity 5 class roster
    excel it activity 50
    excel it activity 54
    excel it activity 51
    it's $5 excelsior springs missouri
    it's $5 excelsior springs
    it's $5 excelsior springs mo
    it's 5 dollars excelsior springs
    it's 5 store excelsior springs
    it 5 store excelsior springs mo
    it's 5 dollars excelsior springs mo
    excel it activity 6
    excel it activity 6 automobile research
    excel it activity 6 automobile research xls
    excel it activity 6 automobile research download
    excel it activity 6 automobile research answers
    excel it activity 6 automobile research pdf
    excel it activity 7
    excel it activity 7 the gap
    excel it activity 8
    excel it activity 8 class roster 2
    excel it activity 8 fbla club members 2
    activity 8 excel it

КОМЕНТАРІ • 50

  • @chantinefelecia568
    @chantinefelecia568 3 роки тому

    Thank you po sa free tutorial.. :) astig! Sir, tutorial din po sana parang ganito din pro masesearch ng bata ang kanilang grades.. tnx po!

    • @NielCastillo
      @NielCastillo  3 роки тому

      I will add po this tutorial in upcoming videos na uupload ko. salamat po sa panonood God bless :)

  • @xjamex8416
    @xjamex8416 2 роки тому

    thanks po

  • @eldineaiman4328
    @eldineaiman4328 4 роки тому +1

    this is very helpful po! 😇 I followed everything you do and successfully made it. Thank you po! Ask ko lang po what if yung ID Number po yung i-uupdate? paano po?

    • @NielCastillo
      @NielCastillo  4 роки тому

      Your always welcome po mam Eldine.. 😊 if ID po ang update same procedure lang po.

  • @dyanzzz
    @dyanzzz Рік тому

    More tutorials sir

  • @bosstrucker8333
    @bosstrucker8333 5 років тому

    Sir thank you sa mga videos nyo. Sir panu po ba matutunan yung mga codes? Sana may Series kayo ng tutorial ng VBA. Thank you. always checking your videos.

    • @NielCastillo
      @NielCastillo  5 років тому +1

      Boss Trucker Medyo busy Lang po Voss kaya hindi pa masyado makapag upload.. since bago bago pa Lang kasi etong channel ko. Pero later gagawa po ako ng complete tutorial with explanation para madaling naintindihan ang mga function at code.. 😊

    • @bosstrucker8333
      @bosstrucker8333 5 років тому

      @@NielCastillo Sir thank you po for your work, tagalog version :) Godbless always.

  • @MJmanalotovlog
    @MJmanalotovlog 5 років тому

    nice tutorials

  • @mulongski
    @mulongski 4 роки тому

    galing!, sir sa add new student, how can you validate Student ID ay meron na? Thanks

  • @IZONARLJOECHUA
    @IZONARLJOECHUA 3 роки тому +1

    i have question po
    i = Application.Match(VBA.CLng(Me.cmbIDnumber.Value), sh.Range("A:A"), 0)
    run-time error '13'
    type mismatch
    yan po lumalabas then ni check ko na po lahat

  • @halimdomaob1785
    @halimdomaob1785 2 роки тому

    Boss tutorial naman sa search bar

    • @NielCastillo
      @NielCastillo  Рік тому

      we will create another video po for search function. :)

  • @dyanzzz
    @dyanzzz 2 роки тому

    paano po pag gusto lagyan ng delete button like madedelte ang last entry?

  • @erwinexconde5544
    @erwinexconde5544 3 роки тому

    gud am po pwedi bang magpagawa ng data entry sayo. un pang resibo kasama n ang print at auto calculate?

    • @NielCastillo
      @NielCastillo  3 роки тому

      Yes of course po..... message me po sa whatsapp +966570102525

  • @marvsvillan5840
    @marvsvillan5840 3 роки тому

    Ask ko po kung may tutorial po kau ng attachment ng document gamit user form

    • @NielCastillo
      @NielCastillo  3 роки тому

      send message po sir WhatsApp +966570102525

  • @HermioneFleur
    @HermioneFleur Рік тому +1

    Run-time Error "13" i = Application.Match(VBA.CLng(Me.ComboBox1.Value), sh.Range("A:A"), 0)

    • @NielCastillo
      @NielCastillo  Рік тому

      please check if yung combo box na ginamit mo is same varialbles sa code.

  • @williejungaray8632
    @williejungaray8632 2 роки тому +1

    Goodday. tanong ko lang sir . pagnakatype ng letters accidentally sa Student ID Box nag eerror 13 type mismatch. ano dapat gawin para ma ignore ang mismatching?? salamat!

    • @NielCastillo
      @NielCastillo  Рік тому

      meron po dapat siya validation . pero if error maybe may mali po sa code.

  • @monicaclariztabien459
    @monicaclariztabien459 4 роки тому

    hello ask ko lang po bakit po blank po yung visual basic ko po pag ni cclick po

  • @theroyals023
    @theroyals023 4 роки тому +1

    sir paano isolve itong mismatch error ko,, error kasi ako sa code na ito
    i = Application.Match(VBA.CLng(Me.ComboBox1.Value), sh.Range("A:A"), 0)

    • @xiallou5958
      @xiallou5958 4 роки тому

      sakin nmn overflow sa side na yan

    • @NielCastillo
      @NielCastillo  4 роки тому

      Hello po.. please double check the code for sure syntax error or may maling code na nainput..😊

  • @itsynrs282
    @itsynrs282 2 роки тому

    Hello sir. Nasunod ko po ung mga tutorials ninyo, kaso ang hindi ko po magawa talaga ung search function. Paano po kung walang ID? Thanks po sana makareply po kayo

    • @NielCastillo
      @NielCastillo  2 роки тому

      hi. need kasi na may existing data para magwork yung search function. pwede nyu po send sakin ung file through whatsapp para macheck ko din .

  • @xiallou5958
    @xiallou5958 4 роки тому

    answer me plss
    error
    invalid or unqualified reffrence ?

  • @ryancollado2333
    @ryancollado2333 4 роки тому

    paano mag search ng value using excel macro from multiple text files?

  • @markjosephursssh8644
    @markjosephursssh8644 3 роки тому

    boss? how to debug "i = application.match(vba.clng(me.combobox1.value), sh.range ("A:A"),0)
    run-time error '13':
    type mismatch
    di ko alam boss pano ayosin..bagohan lang ako boss nag aaral sa vba po

    • @IZONARLJOECHUA
      @IZONARLJOECHUA 3 роки тому

      same problem i need it po until friday next week huhuhu if naayos ninyo po problem ninyo pwede po pa reply ano ginawa ninyo

    • @NielCastillo
      @NielCastillo  3 роки тому

      sori late po nakareply sa inyo.. i have other priorities last year kaya hindi ako nakapag asikaso ng YT Channel natin, hopefully naayos nyu po ang problema nu

  • @simpleperson1229
    @simpleperson1229 3 роки тому

    Bakit po ganun wala pong box na nag-appear sa katabi po ng mga Name,

  • @christinevillanueva1076
    @christinevillanueva1076 2 роки тому

    Pwede po tulong pano po pag gawa ng payroll system

    • @NielCastillo
      @NielCastillo  2 роки тому

      hello po mam pwede nyu po ako message thru whatsapp +966570102525 thanks

  • @ralkalifores5983
    @ralkalifores5983 3 роки тому

    maayo gabi may virus po ba ang macro sir

  • @marvsvillan5840
    @marvsvillan5840 3 роки тому

    Hello sir

  • @cornejorizzamaem.4301
    @cornejorizzamaem.4301 6 місяців тому

    Sir hello baka pwede kao mag ash huhu badly needed lg pooooo about sa code ayaw kasi gumana saakin 😭

    • @NielCastillo
      @NielCastillo  8 днів тому

      Hi, Please send email po.
      rhonielcastillo@gmail.com

  • @jeromedaffon5205
    @jeromedaffon5205 Рік тому

    lakasan mo ang audio please next time

    • @NielCastillo
      @NielCastillo  Рік тому

      Yes po next time. Thanks for your comment :)

  • @kapetan354
    @kapetan354 2 роки тому +1

    DELETE COMAND NAMAN NEXT VIDEO SIR.

    • @NielCastillo
      @NielCastillo  Рік тому

      Noted Sir. Please keep on watching and sharing our videos para update po kayo sa next video natin. We will make another video for delete function. Thanks