Filipino Tutorials ( Create Data Entry Form Using Excel + VBA Programming
Вставка
- Опубліковано 8 лют 2025
- shopee.ph/wise...
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....
Thank you and God bless!!!
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
roducido 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
excel macro 365
excel macro 3 dimensional array
excel macro 32809
excel macro 3d array
it excellence award
it excellence award 2019
it excellence award in disaster management
it excel llc reviews
it excel templates
it xcel consulting
it excellence sp. z o.o
it excel courses
it excel llc training
it excel llc
i in excel formula
i in excel vba
i'm excellent in spanish
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
0 in excel phone number
0 in excel blank
hide 0 in excel
#div/0 in excel
show 0 in excel
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
Sobrang daling sundan. Tapos nag search nalang ko ng ibang codes para mapaganda pa sya. Thank you so much.
Your welcome sir. Thanks
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
Galing! Followed the step by step procedure and nakagawa ako isang data entry form. Lupet!
Your welcome sir :)
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
No drama.. no introductions.. no etc etc.. brilliant yet easy to follow.. thanks.. you deserve more subsrcribers.. thank you..
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
Thank you for this! I appreciate the step by step/ I was able to finish a template for work using this as reference.
Thank you for your support, God Bless :)
wow... i hope na matutunan ko yan... ang galing... easy to understand anf tutorial mo... congrats and thanks
keep on watching and sharing lang po tayo sir. marami pa po tayo mga tutorials na gagawin about excel and VBA . Thanks
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
Grabe galing. Dahil dito napaka basic pala ng alam ko sa excel. Pede po video ano function ng mga codes na yan
I’ve been looking for this guide for hours! This is very easy to follow! Thanks to you, I just finished creating a file that will help me calculate expected results and daily target to reach gap to goal.
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
hi ang galing mo talaga, sa gamit ng microsoft excel
Natapos ko deadline ko. And thanks to you!!!!!! The best na nakita kong tutorial. 😭😭😰
Wow!!! THANKS din po miss Joy Marie.😊
Ito ung hinahanap ko pinaka malinaw na turo kayang sundan
Sobrang dali! Maraming salamat!
keep on learning sir God bless
Galing nyo po Sir more tutorial about VB ang bilis kasi ng kamay nyo po Sir... Pero thank you sa tutorial sir
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
Very interisting video lam na
pa hug po.. hug din kita agad..
THANK YOU VERY MUCH....THIS IS VERY HELPFUL
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
Solid mo amo! Salamat! 🔥
Thanks :)
yey subscribed.
Thank you
Kaya pala Pamilyar. Kaw pala yan Kuya. Nice nice!
Hehe sino po eto? any way thanks
Hi Carl ikaw pala to. Thanks sa panonood. :)
galing po. suggestion po, baka po pwede next time bawat code nyo po ay may explanation at ano function nila. hehe
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
Nice friend informative good to share
Thanks.. God bless!
Sir, can you also make a video sa purpose nung mga codes na nilalagay? Para in the future, we won't need a guide and kaya na namin gawin sa sarili namin depende sa format na need magawa. Thank you!
Good job po. Make some color for christmas
Thanks boss... :) God blesss
Marami talagang palang pinoy ang magagaling sa excel.
Thank you .. I will visit your channel too and subscribed.
Thank you po.
Welcome 😊
Wew nice tips ...pang tree po ako tnx
Thanks sir.. more tutorials coming.. :)
mas malakas pa ang keyboard sound kay sa boses mu sir. pro very useful tutorial para marefresh ang visual basic ko:)
Thank you po sa feedback . Next time po improve ko po . Thanks
Sir. Sana may tutorial din kung ano yung use ng codes like "dim", "me", "sh", interesting kasi pero mas ok kung makukuha po yung logic nya. Salamat.
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
Nice one galing
Kapag nakakalimot me sa code..heto ung tutorial na binabalikan ko.Thank you po
no problem po :)
Nice content! Astig
Thank you very much for this very gorgeous tutorial. Salamat salamat!
your welcome sir , God bless po
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
naakap na po! ❤️❤️❤️
na hug na po kita
nice video i like it
thanks!
Hello sir, pwede ba tong iupload sa sharepoint pra magamit ng ibang employees?
Yes po pwede po
Hi po, sana po Data Entry Form naman using Microsoft Access 😊❤
you mean po ba using MS Access as Database?
@NielCastillo opo sir, pero okay na sir Salamat po ☺️
@ sorry po medyo matagal po ako nawala.
VERY HELPFUL :)
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
sana meron din po kayong tutorial yung create quiz form.
Will try po soon kapg hindi po masyado busy sa mga project.. 😊
Thank you 😊
Your welcome po. 😊 keep safe and God bless po
Maraming Salamat 👍😁
Sir damihan nyo pa po about programing video.
God willing po makpag upload tayo ng maraming tutorials
Sir if i may suggest, instead of typing better to say it nalang kasi naka reveal naman mukha mo sa video. Just saying thanks sa tutorial..😊
Noted po sir. Thanks po sa suggestion. :)
Gawa ka nmn po ng tutorial how to make powerpoint presentation through excel and vba. t.y
God willing po. as of now hindi po makapg upload due to other priorities..
edit and remove of data naman please :)
Hello Sir, Possible po bang yung data na e sasave is matatapon sa ibang laptop ?
Yes sir it's possible po. You need to do lang po is dapat the same network kayo then naka file sharing ang data
pwede rin po ba sir yang method na yan sa record / filing naman po mga documents? thanks
yes po pwede :)
idol may connection po ba ang "version registration failed" sa pag hahang ng macro?
pwede po kayang ma complie yung ganito and magin executable file?
salamat idol
Yes sir pwede po..
Thanks for making this informative video. Idol ask po ako paano gagawa nang formula sa auto loan maturity, yung date yung e compute sa vba.
Thanks
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
How to delete an entry po sir?
Hi sir, salamat at marami ko natutunan sayo. Pano yung pag open mo ng file, makikita agad ang dashboard lang di kasama ang ibang blank na column. salamat
kung saan po nakalagay na sheet yung dashboard mo doon po kayo magsasave lagi ng file.
Pano po gawin sa multiple ecxel book na parepareho ang format
Hi, very nice tutorial. How can I save the data into a different workbook? Can you help me?
gagawa po tayo soon ng tutorials about dian.
contact me po sa whatsapp +966570102525
@@NielCastillo to get a ßtt zaa
Hello po paano po Kung may nka ready n pong work sheet as in may data n paano po iliipat sa ganyan.
Yes it posible po. Need mo lang palitan yung name ng mga textbox based on your preference at yung arrangement para pag naginput po kayo ng data same papasok doon sa desires column na dapat puntahan. Then palitan lang po sa vba code yung name ng sheet
Nice Sir. Thank you. Do you accept personal tutorial about Macro and VBA?
Boss Trucker nakabased po ako Riyadh Saudi Arabia. Pero maguupload po ako ng mga other tutorials. Pasubscribe po para updated ka po sa lahat ng mga tutorials ko. Thanks
@@NielCastillo Thank you sir. subscribed :) thankful ako kase may tagalog. :)
ua-cam.com/video/idYkQzgKP-k/v-deo.html new tutorials po.
hello po, sa code po sa gender bat po code not found sa .Clear
Please send us message in our WhatsApp +966570102525 so we can help you to fix the error. :)
How to create Log in system to protect your excel file -- ua-cam.com/video/5EOnQj7Da_4/v-deo.html
Galing. Sir ung part2 po?
God willing po... :) gagawa tayo ng part 2 Thanks
Ito ang hinahanap ko sir. Pano po ba yang mga codes na yan my turotials kdin ba
hello sir , for now po wala pang mga updates due to my other priorities. soon po gagawa din tayo ng tutorial, keep on learning po. God bless :)
next video po natin sir, .Thanks
Nice info bro.. keep it up
JUNE ALMERINO ua-cam.com/video/idYkQzgKP-k/v-deo.html
Please po how to create a search box,. Tsaka po yong makikita yong list na nakalagay sa search box...all output in one table po. Ty.
Ok sana eh...kaso explained all the formula na inin put mo para mas maintindihan
good day. sir ask lang po sana ako kong ano ang problema dito? ( n = sh.Range("a" & Application.Rows.Count).End(xlUp).Row ) sinunud ko naman po sya pero ayaw talaga. thank you
Hello po sir! Napakagaling na tutorial po 🙏🙏San po kayo nagaral nung mga code niyan?
And may tutorial po ba po kayo ng dretso print po ung form? Tnx po. Godbless po sa pagshare ng knowledge ❤️
Thank you po. Gagawa po tayo ng separate video for that :)
Do you accept programming works?
dm me po sir >> facebook.com/spywarekiller/
Easy and simple programming on Visual Basic to create a LOG IN system... ua-cam.com/video/5EOnQj7Da_4/v-deo.html
I hope you can make a data entry form that can add pictures as well thank you for inventory management
yes we can do it po in a separate video. God willing po makagawa ulit ng tutorials. thanks
@@NielCastillo I would really love it if makakagawa po kayo ng visual basic ng inventory po siya with items of different equipments/cars, pag nalagay po siya sa excel if the user acess the form makikita po niya yung mga history of the specific model of car meron mga samples of pictures and dimensions ganon po possible po ba kaya ? Thank you :)
Limited slot only! get 55% of discount on all products in our shopee store shopee.ph/wisebudget
Hey, I left column A for dates. Do you know how I can autofill present day (DD/MM/YYYY) into column A to give a date for each data entry?
idol after ko magawa yan tutorial mo di pa ako nagawa ng dash bord ... then save ko macro pero di ko na ma open .. paano ba un idol????
Sir question, how to fix the Run time error '9': Subscript out of range? It does not transpose/copy the data from the data entry form to the assigned sheet. Thank you.
E rply mo dito sir yung code mo tutulugan kita.
sir, bakit sa akin hindi mapunta sa database ang na input ko na details.,
Hello Sir, ask ko lang po kung bakit kapag nagcocode ako ay ayaw lumabas ng linagay kong name sa aking text. For example po ay txtmass, kapag icocode ko na po siya ay wala pong drop down na lumalabas kaya mano mano ko pong itinatype. Beginner lang po kasi ako. Thank you po!
Sana po masagot.
hi nhel ask ko lng kung panu gumawa ng autmatic invoice numbering and calcu. print using data entry form
Hello sir you can contact us thru email rhonielcastillo@gmail.com or whatsapp +966570102525
Ok sna ito kaya lng masyadong mabilis para sa mga bagohan na gusto matuto like me
We will try na bagalan lang po sa next video para makasunod po lahat .. salamat po
Hello po! I just want to ask if how can I delete a data entered?
hello what do you mean po after click the save button or you want to clear the data you enter thru mistake
by using macro po
n = sh.Range("A" & Application.Rows.Count).End(xlUp).Rows
i have a lil probz in this line.. errors occur. help sir..
Hello sir please pa screenshot po ng error please Thanks
@@NielCastillo ganun din po problem sakin
@@JA-oc7kq send us email po ng screenshot ng error so we can help you po to fix error pasend din ng buong code..
ai@rhonielcastillo.com
Will send po mamayang gabi salamat po!!!
Nakapagsend na po ako, today lang pong afternoon and nodouble pa po. Sorry po, hope for your reply!!! Thank you!!!
sir paano program kapag print preview gamit ang button sa form
hi pano po kapag update records ano po ung code nya?
How to edit po ng haba ng columns if need mag adjust sir?
Please paste your code here of screenshot para maexplain ko po. :) Thanks
Sir pano ko kaya to iupload sa isang web page?
Hello, Boss ung akin sa .clear na command, laging error ung sayo big letter na C akin ay small tapos panay error
hello boss send your screenshot po para makita ko po ung error :)
lods sa akin poba bat sya nag statart sa row 35 bat di sa 2 row?
Ito hanap ko
Hope it helps.. thanks :)
pwede ba yan i convert into executable file?
you can use third party application po
Hello sir. Pano po kaya if mag eedit lng existing data gamit din ng vba?
check nyu po sir sa vids na to. >> ua-cam.com/video/SLr0G8WUnTw/v-deo.html
idol bakit nag hang na after ma input ang code ng clear???
Hi. How to add drop down value in a specific range instead of typing male and female sa mismong script. Thank you
we will create separate video for that po. thanks
Hello where else can I reach you for possible collaborations?
eto po ang aming contact number whatsapp +966570102525 or send email po rhonielcastillo@gmail.com
n = sh.Range("A" & application.Rows.Count).End(xlUp).Rows ERROR sakin to boss bakit kaya? PLs HELP
How to create log in system using excel VBA.. ua-cam.com/video/5EOnQj7Da_4/v-deo.html
boss bakit kapag nagsave ako ng data sa row 1 lahat na sasave?
n = sh.Range("A" & Application.Rows.Count).End(xlUp).Row may problema dito?
Please let me know po or make screenshot if anong error?
Hello sir is it possible to add user login form?
Yes its posible po
pano gawing exe? para di ko na sya ioopen sa excel possible ba un?
use third party application
Hi dko na po nasundan kc marami ako combo options tinry ko gayahin ung command ulit sa gender changing options ayaw na, pano po ba un tsaka sa Date of Birth pwede bang mag insert ng calendar? salamat po madalai pong kayong sundan simpleng instruction lang pero panalo, di malikot ang kamay.. salmat if mapansin mo ung comment ko
may other tutorial po tayo para doon but for now wala pa po ako upload. gagawan ko na lng po ng tutorials ulit God willing po. God bless ;)
wwo nice sino pwdi patulong mag gumawa ng excel form
messsage me po sa whatsapp hopefully makatulong +966570102525
Nice tutorial kabreader
Thank you.. :) pa hug .. hug din kita agad...promise
Pwede ba maging vertical yung kakalabasan sa data?
yes po next video natin gawin ko po tutorial
Hello po. Pwede bang ibahin yung function nyang Submit, instead of submit gawing "Copy" in order to copy the data and paste it to a blank page?
yes po pwede :)
please explain po sana yung mga codes na ginagamit para mas ma simplify ang pag gawa
salamat po
God willing po. kapag may time na ulit gagawa po ako ng videos para doon. :) salamat po sa panood
pano sya lagyan ng female and male entry na separate sila sa excel pag na record sa database at pano yung age counter na pag 1-15 years old and 16-40 na mag kakahiwalay
Hello sir gagawa po tayo ng separate video for that
Thanks
@@NielCastillo as soon as possible sir 😁 one thing more sir paano aya magkakaruon ng multiple table sa iisang excel with only one code/ pano sya magiging column hind sya rows example sa name is under A1 tapos nxt Date of birth under naman sya sa A2 parang pababa sya pag nag ask ng infos tapos pa right naman sya pag na input na yung datas salamat sir
Hello po pwede po ba magtanung paano po kung paghihiwalayin ko ung Male and Female, for example po kapag male select nya mapupunta sa Sheet 1 pag female naman mapupunta sa sheet 2
possible po , gawan po natin ng tutorial next video. Thanks po