Nice list - ok arrays and custom functions are in the course - I'll pick one or two lectures and post them here once we cover the basics a bit....Class modules is something I'm planning to add in later and I'll make a note to make a video for RU-vid as well.
I watched several of the videos about this topic. yours are the most precis and easier to understand. I appreciate you awesome work, and I will definitely recomment your videos to my class.
Hi Lelia, this is old question about VBE, if the window, such as "properties window", "explorer window" & "module window", in a mess, how can i re-arrange all the windows like before.. Thanks.
Thanks 🙏, Mam I have a query regarding a VBA code which is in my excel worksheet but whenever my excel gets updates data my VBA code won't work . Why ??
I have looked at a couple of VBA/VBE intros and they don't reference my favorite way to open the VBE window - right-click on a workbook sheet tab and select View Code from the context menu.
hi I am from Pakistan I have made a POS software for my canteen using excel vba form as front end and Access as data storage. I am really impressed by your videos tutorials. I need to improve the same and I need professional support. can you plz help me out. I would be really thank full.
Hi Leila, I have been following your videos with regards to Excel I have seen a drastic improvement in myself. I heartly thank you for sharing your knowledge and ideas. I was going through one of your link "Resources that I recommend". I was looking for a resource for Power query and power BI. When I followed your recommendation (i.e. excelisfun) it helped me a lot. Thanks a ton!!! And now I'm requesting you to recommend me a resource (similar to that of excelisfun) to learn VBA from basic to advanced level. Awaiting for your response. Thanks in advance, Leila. Have a Blessed Day!!!
My Excel file has with few cells having ||. how can I remove these characters using vba macro? example cell AC64 has 2020-07-24 17:00:00||2020-07-24 17:00:00 Any suggestions?
When I open Visual Basic in Excel in Office 365 I get the message "VBE6EXT.OLB" could not be loaded". Could you help please. I seem to have exhausted all resources.
Dear Madam, My Personal Macro file is been deleted by mistake, Some time ago. and also not found in the Recycle bin. Please advise me on how to recover and activate my Personal Macro file again when I open any excel file, as I have saved many macros to work fast in Excel. I m using Office 2016
Hi leila, I will follow all ur trainings and video in RU-vid all the time those are very helpful for me. I need some help like Is there any way that I can get all the details of certain number or word from internet to excel automatically. Example if I take weather information of a certain country like USA in excel A2 cell I want weather information should reflect in B2 Cell automatically from the internet. If I would change the country from USA to some other country the data in B2 cell should also change. If it is possible please help me on it
Hello All, This video is super helpful for a newbie like me. Anyway, I am assigned to build a VB Script/macros to perform the following (I have zero experience to build VB Script/macros) Let say I have excel file named Test.xlsm There are two sheets in the file Sheet 1 is list of items like the below (in reality this list is very long) Item # Description 100 ABC 102 XYZ ... .... Sheet 2 is kind of lookup table like below Item # Item Name 99 Test 99 100 Test 100 101 Test 101 102 Test 102 103 Test 103 ... ..... Here is my challenging: I need to build VB Script/Macros to run over the sheet 1 and replace (under Item # column) 100 by Test 100 102 by Test 200 As you see the script has to "go" over sheet 2 to look for item name that associated with Item #100 and replace "100" in sheet 1 by "Test 100" and "102" by "Test 102". I am wondering if someone has already done it and guide me to the right directions how to do it Thank you so very much.
Hello there. I've a question about VBA. How can I create a blinking cell in excel via VBA? I do not need to create it with Module and start-stop buttom. I mean when excel opened by user; a specific cell starts to blinking permenantly till he / she closes the excel files.
hi Gharani... super presentation and quite useful! I am trying to use excel ... in.developer tab i have an issue... "object library not registered", I am using office 365. please help me with this issue. Thanks
hi Lella , I am new subscriber of your channel , And I want to learn VBA from begin.to get a new job in MIS department. Can you help me to achieve my goal?
Hi...Leila Can we set a limitation to a macro (recorded) to be Run only when we select any cell in particular column I used macro that it copy a evaluted formula in cell(T2) to paste the value in another cell(A2)...I used relative reference..I create the Marco that do the above operation when I Select cell-S2... When I run the macro when I select another column's cell... Marco will wrong operation...
Hello I recently signed up for your VBA course doing macros. I was able to get the first lesson, but when I try to move on to the next lesson I must have done something wrong. I can't seem to find the issue hoping you can help.
Hi Leila, I personally like all the videos that you've posted. It is because of your sturcured explanation for each topic. I have one suggestion on the VBA excel. Can you help me with VBA coding to convert database (table type) into invoices format. - with some invoice has two or more items inside. I'm sorry I don't know to notify you except in this comment. Thank you in advance.
Hello Leila_ Liked your tips about vba. But I got a problem. When I try to write codes using active x comands they became translucid. How can I solve this? Are there any sittings I should try to activate?
Hi 😊 im a CS student. Its hard for me to Learn Visual Basic because i don't have a laptop or pc is there an vb app that i can use in mobile phone? Thanks ..
VBA only works on desktop version of Microsoft office. Being a Cd student, you should definitely try and save for a decent laptop. Nothing too fancy, Just one where you can code and do other things for your learning.
hello guys, can someone help pls, I have a excel file with 30 and more sheets and I want to protect all with VBA code and can write comments same time and I cant find code pls help me tnx
hi Leila, what is the difference between intellisense (pressing control + J) and complete word (pressing control + space). do they behave the same way and autocomplete the same things? i only use intellisense and sometimes some things are not autocompleted or don't show up in the intellisense list, or no list is displayed at all despite the code is accurate
Thank you for your amazing work. I've just bought one of your courses on Udemy on Excel Dashboards and I am super impressed. You truly have an amazing, God-given gift to explain in such a way that anyone can understand. Keep it up and be blessed in all that you do!
Leila Gharani please upload videos on whatever new things you learn on excel and power BI. You teach so nicely that it straight goes into my brain. I would be grateful if you teach us all that u know. Stay blessed😊
I have the exact same thoughts. Over a month ago, I was binge watching Leila's Excel tutorials (I repeat, binge watch Excel tutorials). Then, I said to myself, enough for now. But, I guess, I have to catch up. LOL
How to make Excel sheet DDE server I want to poke out Excel data to my software Please code some one I want to pull stock data in Excel and send to software
EXCELLENT, I thank sincerely for publishing this video on VBA. Your style of explaining the things/concepts, very very informative, inspiring, revealing, thought provoking , interesting & injects a love spirit to learn Excel/VBA for faring better officially/personally. I pray the almighty to bestow good health, prosperity and let more number of people learn the Excel/VBA and do good to the society at large. BIG SALUTATION FROM THE BOTTOM OF MY HEART TO MY LOVELY AND BEAUTIFUL TEACHER. NAMASKAR.
Thank you very much Gopala for your very kind comment. I am very happy to hear you enjoy the tutorials & find them useful :) Thank you for your continuous support.
Dear mam Pls make any simple video on how to maintain stock inventory in Excel with Opening stock Received stock Issue stock Closing stock With different sheet or one single sheet and how to filter individually every type
Do you know how to create a "link" in excel such that, when the user presses it, it unfolds a certain number of columns (which are initially merged) and reversely. I want it to be just a typed phrase, not a button (I know how to do it using toggle button). Thanks a lot!
Chris, yes, you can create a button with an event that adjusts the Sheet object - unhiding/hiding columns and rows; dynamically or statically. Or, to suit your needs, you make an ActiveX TextBox, using the 'change' event; then am IF or WITH statement - just waiting for the desired phrase to be entered, then execute whatever afterwards.
Hi Madam, I am very much impressed with your online training. Can you create one module to work with API using excel VBA? If it is already available, please share the link with me. And also help me with the code to auto create the text boxes or combo boxes with the no of excel sheets in the excel workbook. Ex: If there are 5 sheets, I need my macro to auto create 5 text boxes or 5 combo boxes. Thanks in advance
Hello Leila, I am trying to run macros to multiple sheets but all of them shares the different format. Is there any way I can record my macro with keyword? Thank you,
Hi Leila, vba coding how to protect if I m protected vba coding with password but vba break zip extension through how to make other way to parmanent protection. Please tell me
There's only one way to "break" a VB Project (form the Project Explorer), and that's with either downloaded or online Hex editor. Yes, people can convert the XLSM/XLSB files to ZIP, then use a Hex editor to unlock it - there's no way to make the project 100% inaccessible... However, perhaps using Windows API functions, you can write something to detect when the VB Editor is open, then to automatically close it....
Great intro video! Would you have one on docking/resizing the vbe windows. I have managed to "undock" them and they overlap now. The check boxes are all marked under Tools>options as being docked, but they are not snapped in. I've tried resizing them and while functional, they just look messy. :P
:) it's challenging and fun & I agree, it's not something that makes perfect sense immediately. Takes a lot of revisiting and learning and re-watching to get the hang of it (at least it was for me) But once it clicks, it's really useful. It also helps with logical thinking and problem solving skills.
Hello Miss Leila, I need help with something, is there any way we can integrate any other code editor with Excel (Ms VS Code for example) as VBA Editor is very out dated and lacks many of the features I have been looking online for a solution but could not find anything. Thanks for your videos they are very helpful you explain everything really really well, keep up the good work, thanks again
Hi, I have a rather difficult question: I got a file Excel with activation macro. I use many conditional formatting and I wish that the interval of application would remain unchanged. I think that the problem are the macros but I obtain no effect registering a macro and setting the conditional formatting. Do you have any ideas? Thanks
I need your help. I created an button and wrote the code but when I click on it, I get this message. Cannot run the macro 'Workbook.xlsm!PrepareTheTables'. The macro may not be available in >this workbook or all macros may be disabled. Thank you so much.
Ka, make sure the macros fired are "Public" and not "Private." And, that the macro is reachable. To ensure a Global scope, you can put your macros in your "Personal" book - doing that, and making them Public, means those macros will be accessible in any Workbook you ever open; new or saved!
Hellow Leila, congrats for being excel Guru, for sure i have learnt lots from you. My question is, how do i ensure that my macro enabled doc is permanently enabled automatically even when a doc is transfered to another device without re - enabling macro again and again??? Thank you...!!!
Once is a macro file-type (i.e. XLSM, XLSB) it will always be that way. You're asking how Microsoft Office interprets these macro-enabled files. That would depend on the Trust Center settings for that user. Depending on the organization, like mine does, they may have to enable content manually every time. Unless, they save locally, then no issue.... That okay?