Our Excel training videos on youtube cover formulas, functions and VBA or macros. Useful for beginners as well as advanced learners. New upload every Thursday.
Microsoft Excel is a trademark owned by Microsoft Corporation and our MS Excel training programs are not associated with the company.
Пікірлер
Hi sir, I am currently doing a student assessment program working with vba. I tried printing multiple sheets using cell value but the printing copies had gone over the maximum number in the class. Please how can I print using the cell ranges as minimum number and maximum number of a cell range? Thank you Ajay
Hi sir, I am currently doing a student assessment program working with vba. I tried printing multiple sheets using cell value but the printing copies had gone over the maximum number in the class. Please how can I print using the cell ranges as minimum number and maximum number of a cell range? Thank you Ajay
Website down sir
How did you create that search box???
Nice info
Thanks for this great information
Sir how about in vb 6.0 how to use dsum im using query access 2007
Hello sir. hope you are doing good. Could you please help me with the vba code which translate languages by using our own API and URL instead of using google api
How can we add multiple variants
Thank you Very much. been stuck on this for weeks and now you solved it for me. Big thanks
Wherefore you, i miss you
OMG! This is the Best video ever! Thank you!
hi thank you for your explanation , i have problem with compile error invalid use of me keyword if me.combobox1..value= ws.cells(i,"b") i did all the code you did but dosent work with me can you help me thanks
Nice and helpful vdo sir,Thanx
I'm interested keep me posted
Hi, excellent info. Just what I wanted thanks. Would have been good to explain whether "Me" was the name of your worksheet (for me to replace with the name of my worksheet) or just referenced the current worksheet. Also would be good to have the code available to copy. A shame Excel doesn't offer this as a formatting option as I often want it on for some columns and off for others. Turning it on or off for the whole worksheet is quite clutzy. Your solution is elegant but beyond many users. Thanks heaps.
Permission denied problems
Sir your video fake because your selenium install in user /appdat then why show in programme file
exactly what I needed. Thanks a lot !👍🙏
Is it possible to write vba code to unzip a password protected zip file (by of course having the password and not bypassing it)?
Thanks
hi there is no download file please send download sour code file
Hi and thank you in advance. I need to copy & send a table by email, but I need to hide some columns, not to be sent, without deleting them from the table, can you help me? Thank you
Very useful. Well explained.
Hi Thank you very much for this works a treat!
Thank you so much sir. God bless you and your family and generations!!
Can we do this same from text file to word table format?
Thank you sir. I got it. I also want to know print preview before printout.
Great video. Thank you. Do you have a video of doing the reverse, that is to copy an image from a page to a user from?
I would like the login details captured in the same workbook at the last sheet. How to do that. As in your video, you created a different workbook just for the details.
How to define the variable b. From your code there was a "b" equal to cells(row,2). Address but when I followed your instructions, the Excel said the variable is not define
Lot's of Thanks sir....
Thanks, its works great. Need to play audio if value changes How to do?
Thank you very much for this video... single buttons work. Is there a way to get a second button using similar code? I tried adding a 2nd button to float in concert but it seems that it causes some kind of problem in VB. I am editing a column.... with two options each programmed to a different form control. With each row, I press either for the two buttons. Does anyone have an answer? Thanks in advance! ;-)
Done ✅
Very well explained Sir. In fact I'm more interested on doing something similar , but the output of the macro should stay on the other workbook ( where the real macro is built) . For example I'm working an the workbook (A) . In macro in workbook (A) I'm opening another workbook (B). Now I'd like to write something which run a macro already built in Workbook (B) and the output of this run remains in the Workbook (B). The idea is to create a workbook ' central' (A) which open a dozen other workbooks ( B, C, D, etc etc) , consecutively ( via a loop), run the macro built in them ( the same macro), save them and close them. I couldn't find a good solution for it.
Watching this after 9 years even now it's useful thank you sir
im sorry but the code link is not working... can you re-post the code please? thank you
Dear sir i chandan roy i also try your best coding code but one issue my vba project not run also show me "USER-DEFINED TYPE NOT DEFINED" so kindly i request you your best hand. Thank you sir.
thanks for the help in this!
Getting selenium error
Sir if we accidently delete the 1st file ( the reference) will still work on new workbook?
It is filling the form sequentially. do you know they way to fill all the column at one go
Thank you thank you thank you! So easy and straightforward. I know nothing of Visual Basic. As I added the code, I wasn’t expecting it to actually work. I for sure thought I would get some error. But it worked!! Thank you again sir!
Wow, this actually worked. Thanks so much! Subscribing.
how to bold a part of concatenate text??? Please answer
Please can you help me to Embed my worksheet to web i will pay for it
Thank you so much Dinesh Kumar! I was very confused for almost three hours with this struggle, and I was almost close to give up, but you explained quite properly, and it was easy to understand and follow along your tutorial. Great work, and congratulations :D :D
Very well explained!