Great sir. Maine ek request bohat dino se ki hai ki Excel useform ke saath data Access me save ho , search ho, filter ho esi ek app banaiye sir. Jise 10 PC b chalye to data over write n ho. Please
@@vbAFun I will wait for your video as your method of data entry logic is different from common video available in youtube. So to get something valuable need to wait.
Nice video sir..is it possible in listbox specific columns right alignment .using vba ..like debit, credit... (these columns contain numeric values..) plz do for this...thanks
Yes dear that I said that if you want customise allignment then u have to use list view because in listbox no option to use allignment for different columns. Isme LoL ki bat hi nahi hai
Sir agar maximize karte hai to Us condition me userform me koi labels ho to unki position set position se change ho ja rahi hai is problem ko kaise solve kare pls sir help me
Sir is file download karana ka samay... "Google Drive can't scan this file for viruses. This file is executable and may harm your computer.".... ei Warning aa raha hai (For windows 11)
See if your system app is working and there is no issue with code then 100% this will be there. Basically that is to small you can see only min, Max and close button only
Instead of Maximize Button that makes the userform look funny I think this is better: Public Sub AddRestoreButton(ByVal UserForm As Object) Dim hWnd As LongPtr, lStyle As LongPtr hWnd = FindWindow("ThunderDFrame", UserForm.Caption) lStyle = GetWindowLongPtr(hWnd, GWL_STYLE) Call SetWindowLongPtr(hWnd, GWL_STYLE, lStyle) End Sub
You are very talented and best in programming............ SALUTE FROM PAKISTAN.......... EXCELLENCE WORKING
Thank you for your comments 🙏
Nice sir.maine pahle bhi ye sawal Kiya tha.iske liye thanks.
Thank you
HUM APKO AP KE BEHTAREEN KAM PER MUBARAKBAD DETY HAIN...................... CONGRATULATIONS
Thank you 👍
Thank you so much Sir. Maine mere project use kiya hai
Great..... Tutorial......
Thank you
Hello ! Sir
Thank a lot of.
thanks brother
Thank you
HI!
THANK YOUU
Welcome
Sir gold jewellers ke liye bhi koi video bnaiye
Hi sir, if there are any controls in this form will they automatically resized according to the form size. Plz do let me know???
Yes why not but for that you need to understand coding and some mathematics
@vbAFun ohh I see... if possible make video on that thanks!
Sir! Your lectures are great
My question is can we search two sheets data. how
Yes we can this by using loop function
is there a way to make application icon visible on taskbar?
Great sir.
Maine ek request bohat dino se ki hai ki Excel useform ke saath data Access me save ho , search ho, filter ho esi ek app banaiye sir. Jise 10 PC b chalye to data over write n ho. Please
Iske liye already video bana rakha hai please watch chat apps
Ok
Thankyou
great code
pleae make video for copy paste button .thank you. mansoor from bangladesh, live in sharjah.
Nice sir, sir kisi listview ke sabhi row me icon ki jagah different different image या student photo kese adjust karenge, plz bataye.
Good question please wait will upload like that video very soon
Sir please make a video on Google sheet data entry with app script.
Okay, but it will take some time to create
@@vbAFun I will wait for your video as your method of data entry logic is different from common video available in youtube. So to get something valuable need to wait.
Sir ap konsa excel use karte hain, 2013, 2016?
Hi mai 365 use karta hun
@@vbAFunMe 2016 use kar raha hoon mgr usne userform me dateoicker nhi aaraha and not even in tools section (microsoft windows control pannel).
Hi Sir, One Doubt
Yes, please 🙏
sir i am eagerly waiting your video of carry forward value that you ppsted but yet not revealing code
Which code ?
@@vbAFun carry forward valur
carry forward sum of value in printing
print invoice with multiple pages carry forward
Nice video sir..is it possible in listbox specific columns right alignment .using vba ..like debit, credit... (these columns contain numeric values..) plz do for this...thanks
No, if u want customise allignment in listbox type control u have to use list view
@@vbAFunlol If he wants customize listbox then he can't use listview… 😅
Yes dear that I said that if you want customise allignment then u have to use list view because in listbox no option to use allignment for different columns. Isme LoL ki bat hi nahi hai
Hello sir , Is this work on Excel 2013?
Yes it can we work, because in this app windows api has used.
Its always a great idea to copy and paste code from a friendly guy you dont understand...right?
sir cant find dll entry point get winsowlongptra in user32 error will apair, plize hlp me
Hi Sir, Very Nice Video, how can I get this API and which screen recorder do you use to create these Videos..
Check in description
Nice Explained.
Sir Runtime Error 453 dikha raha hai. kya karan ho sakta hai ?
See ye windows api ke dwara banaya gaya hai ho sakta hai ki kisi system me support nahi karta ho
Apka video bahat usefull hote hain but App subscriber ke anusar video nahi banate hain.
Sorry for the inconvenience, I will try to do my best
Sir combobox me mouse scroll kaise kare
When i use this code msg comes..cant find dll entry point get windowlondptra in user 32
ME TOO ALSO
Sir indian currency ka symbol VBA code editor me q nahi aata hai. Pls iss par vedio banaye 🙏
tôi không chạy được đoạn code của bạn, nó báo lỗi này nè "Argument not optional"
giúp tôi với nhé!
I meet Runtime error 453 cant find entrypoint GetWindowLongPtra user32
How to solve it
Please help me
As i said in video that in some system this user32.ll not worked due to windows capabilities
Sir agar maximize karte hai to Us condition me userform me koi labels ho to unki position set position se change ho ja rahi hai is problem ko kaise solve kare pls sir help me
Ek Method maine bataya hai latest video check kijiye
@@vbAFunThank you very much sir for replying.
Sir aap sehi mai application banana sikha hai
Sir iska code de dijie
Bahat bar message Kiya hain ki ak purchase sales and stock maintain ka ak video banane ke liye but app nahi banate hain.
So sorry but mai thoda idhar kusch family matter me busy tha jaldi banaunga
ruclips.net/video/2hWOTYNxpmw/видео.html
Sale purchase & stock maintain vala video hai
Can't Work in Window 11
Error occurred "Argument not optional"
Please sir solve the problem
Some system dll not worked properly.
Sir is file download karana ka samay... "Google Drive can't scan this file for viruses.
This file is executable and may harm your computer.".... ei Warning aa raha hai (For windows 11)
Ye coding pehle support plus vale ne dala hai
Ho sakta hai but please check is this same code?
Error when form runs. UserForm.Caption
Thisbcode has been used with windows api so there could be some issue with other system, i am using windows 10 with 64 bit excel
@@vbAFun
I figured it out.
I had to use the name of my Userform.
Plus I had to change the longptr to just long.
I have change LongPtr to Long my code gets run@@danp6101
when minimized i cant see the form
See left bottom before taskbar
It's not seen there
See if your system app is working and there is no issue with code then 100% this will be there. Basically that is to small you can see only min, Max and close button only
User defined type not defined
hi, ye main pahle hi kaha tha kisi kisi system me problem ho sakta hai, aap dekhe ki apka windows and excel and kitne bit ka hai.
@@vbAFun abh Kiya karna hai sir
@@vbAFun win 10 pro, Excel 2007, 64 bit
hWnd As LongPtr
hwnd error
It could be due to api not supported
@@vbAFun thanks... But Solution ?
100% not working in windows 10.
Instead of Maximize Button that makes the userform look funny I think this is better:
Public Sub AddRestoreButton(ByVal UserForm As Object)
Dim hWnd As LongPtr, lStyle As LongPtr
hWnd = FindWindow("ThunderDFrame", UserForm.Caption)
lStyle = GetWindowLongPtr(hWnd, GWL_STYLE)
Call SetWindowLongPtr(hWnd, GWL_STYLE, lStyle)
End Sub
Yes it can be i am not denied with your comments. I am also learning 😊
hWnd As LongPtr