Dinesh Kumar Takyar

Dinesh Kumar Takyar

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.

Print Selected Range

Print Selected Range

Assign Expiry Date to Macro

Assign Expiry Date to Macro

Create Floating Button

Create Floating Button

What is  Modeless UserForm

What is Modeless UserForm

MsgBox Function in Excel

MsgBox Function in Excel

Пікірлер

  • @HildaAmut
    @HildaAmut9 күн бұрын

    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

  • @HildaAmut
    @HildaAmut9 күн бұрын

    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

  • @commoditycontrolserviceslt6655
    @commoditycontrolserviceslt665510 күн бұрын

    Website down sir

  • @Xaviergonzalez85
    @Xaviergonzalez8510 күн бұрын

    How did you create that search box???

  • @mahesh7355
    @mahesh735514 күн бұрын

    Nice info

  • @HabiburRahman-up1wi
    @HabiburRahman-up1wi16 күн бұрын

    Thanks for this great information

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

    Sir how about in vb 6.0 how to use dsum im using query access 2007

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

    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

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

    How can we add multiple variants

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

    Thank you Very much. been stuck on this for weeks and now you solved it for me. Big thanks

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

    Wherefore you, i miss you

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

    OMG! This is the Best video ever! Thank you!

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

    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

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

    Nice and helpful vdo sir,Thanx

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

    I'm interested keep me posted

  • @ClementLeLievre-wk4yf
    @ClementLeLievre-wk4yfАй бұрын

    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.

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

    Permission denied problems

  • @ShivKumar-ed7ce
    @ShivKumar-ed7ceАй бұрын

    Sir your video fake because your selenium install in user /appdat then why show in programme file

  • @sirebinouze1870
    @sirebinouze18702 ай бұрын

    exactly what I needed. Thanks a lot !👍🙏

  • @alisashko21
    @alisashko212 ай бұрын

    Is it possible to write vba code to unzip a password protected zip file (by of course having the password and not bypassing it)?

  • @RahulYadav-yl2ul
    @RahulYadav-yl2ul2 ай бұрын

    Thanks

  • @angelichugs9001
    @angelichugs90012 ай бұрын

    hi there is no download file please send download sour code file

  • @1234567890lion
    @1234567890lion2 ай бұрын

    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

  • @jasonfleishman9884
    @jasonfleishman98842 ай бұрын

    Very useful. Well explained.

  • @cyrilpiot3697
    @cyrilpiot36972 ай бұрын

    Hi Thank you very much for this works a treat!

  • @EmekaOgbu-lz6bk
    @EmekaOgbu-lz6bk2 ай бұрын

    Thank you so much sir. God bless you and your family and generations!!

  • @rohinichincholkar
    @rohinichincholkar2 ай бұрын

    Can we do this same from text file to word table format?

  • @tvarah1344
    @tvarah13442 ай бұрын

    Thank you sir. I got it. I also want to know print preview before printout.

  • @oslcparksville
    @oslcparksville2 ай бұрын

    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?

  • @norbaitiak9657
    @norbaitiak96572 ай бұрын

    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.

  • @norbaitiak9657
    @norbaitiak96572 ай бұрын

    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

  • @THECHANDUG
    @THECHANDUG2 ай бұрын

    Lot's of Thanks sir....

  • @LAZARSELVA
    @LAZARSELVA3 ай бұрын

    Thanks, its works great. Need to play audio if value changes How to do?

  • @Boomdog88
    @Boomdog883 ай бұрын

    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! ;-)

  • @SumeshTkBSNL
    @SumeshTkBSNL3 ай бұрын

    Done ✅

  • @lymitutit3046
    @lymitutit30463 ай бұрын

    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.

  • @aravindhan9165
    @aravindhan91653 ай бұрын

    Watching this after 9 years even now it's useful thank you sir

  • @posterdotcom4176
    @posterdotcom41763 ай бұрын

    im sorry but the code link is not working... can you re-post the code please? thank you

  • @chandanroy2570
    @chandanroy25704 ай бұрын

    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.

  • @gamespeopleplaygpp9543
    @gamespeopleplaygpp95434 ай бұрын

    thanks for the help in this!

  • @bhavingada1
    @bhavingada14 ай бұрын

    Getting selenium error

  • @triviatalks4179
    @triviatalks41794 ай бұрын

    Sir if we accidently delete the 1st file ( the reference) will still work on new workbook?

  • @keepitsimple7394
    @keepitsimple73944 ай бұрын

    It is filling the form sequentially. do you know they way to fill all the column at one go

  • @karlabruce2871
    @karlabruce28714 ай бұрын

    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!

  • @LIV-FREE-VET
    @LIV-FREE-VET4 ай бұрын

    Wow, this actually worked. Thanks so much! Subscribing.

  • @hariadi9994
    @hariadi99944 ай бұрын

    how to bold a part of concatenate text??? Please answer

  • @DEKINGLOTTOO1
    @DEKINGLOTTOO14 ай бұрын

    Please can you help me to Embed my worksheet to web i will pay for it

  • @xavierrodestami40
    @xavierrodestami404 ай бұрын

    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

  • @satishdeshmukh1023
    @satishdeshmukh10234 ай бұрын

    Very well explained!