This video is awesome, all your videos are on point Leila. I managed to learn and create practical simple questionaire responses because I genuinely understood what you taught
Thank you for producing such great videos! I really like the organization, information, and all the details you cover in all your videos! Hope you have a great day!
Thanks a lot for this msgbox ..I got some new knowledge I need something more if you can ^^ How to show Notification message in Tray excel vba I need to see your method as an expert moreover, as I know you a great person with helpful ideas and explantions
Thank you for your video. Message boxes are very easy so wasn't going to watch it. Thankfully I did as I didn't know you could add certain types together or access the function like you did. Just shows you that you can always learn new things
Hi i have a question can I create msg box while saving any spreadsheet because I use excel on daily basis in my job and huge data so if I set some control check so that i can minimize the error
Thank you very much for your teachings for your big fan your youtube subscriber and I had purchased udemy of Microsoft excel vba course 6 months back and I had learned so much from your course I request to you madam please if you know about Tally definition language please make the course on it
Thanks! Your lessons are awesome. However just a suggestion. You should use some bigger screen for display. Kind of smart board. As the visibility is quite less in the current system.
The MsgBox object has limited customization features. If you need something more sophisticated (i.e. logos, font controls, backgrounds, etc...), you need to use UserForms.
Hi Leila. Question, I've got a scenario I'm wondering if it is doable with Message Boxes. Is it possible to have a message box pop up as an event procedure say maybe upon opening a workbook and display only cells that have values in a given range as well as values of an adjacent column? So for example, if I want a message box to show only those cells that have values from Column I(Eye not L) and then the corresponding values in column C, could a message box do that as a vertical listing? So something like: John Smith - 100 Nancy Smith - 50 Paul Smith - 75 I'm not familiar with the limitations of Message Boxes, but is it possible to do something like that?
Thank you. What is the best way to provide the user with multiple lines of information when a button is clicked? Message boxes are great but requires code to insert lines. Is it better to use a text box on a user form? Thank you.
I was wondering if there was a way to refill the table after you clear it with the message box. I want to be able to change my chart and if I need to restart, I can hit the clear button and then it will clear and then start from my original table. Is this possible?
hello leila thanx to share with these type of video bt i would like to say you that although ur content is very good all of us bt i request to u that pick the topic project wise and solve this from where we can learn more.olzz donot mind bt i need this type of video
You're welcome Ismail - it's best to start from the beginning - you can watch the playlist from the start to see if it's something for you - but to get an in-depth understanding I would suggest a book or a complete course....
Hi,, thanks for the video but How can we use this welcome msg whenever we open the excel? (as I tried but it didn't work) (I have already enabled and saved excel as Macro Enabled Worksheet. Also if I want the user to fill a specific cell and he left it blank, is there a way to stop him from closing/saving the file (with an error msgbox)? Thanks in advance for your support.
Anything i can do about that spinning wheel you get when the cursor is moved off the message? I literally had someone wait for it to go away before trying to click 'ok' in the prompt...
I'll be uploading VBA videos on Tuesdays for a bit for the VBA series and the usual Excel videos on Thursdays. So happy Thursday is still in place :) Thanks for dropping by on Tuesday too. See you in 2 days.
Hi - in the full vba course I cover two methods to send automatic emails from Excel. One is a simple method that uses your default email and the 2nd is for Outlook. We generate different PDF files for different people and we automatically attach them to an Outlook email (taking the email addresses from the Excel file) - we cover this in the 3rd milestone of the course.
Hi Mam, this is Siva Kumar I got the access to videos from udemy. I started learning. May I know what is automation in excel/vba and how to do that. Can i have any sample videos for that. Thank you Mam.
Hi Siva - automation in Excel is any procedure that's done automatically - for example in this video, when we click on the button and we get a message box asking us if we want to delete data and we click "yes" and it deletes - that's a mini automation. When you program an Excel tool with VBA, you can automate many different tasks. Inside the course in first milestone (section 9) we automate creating a Table of Contents for our files, in the 2nd milestone in section 14 we automate importing data from other files and creating csv files and so on...
Hi Santhosh. I have a course that takes you from beginner to advanced here bit.ly/LeilaVBA. It's over 20 hours long. I also have a free playlist here, but start from the beginning of the list: th-cam.com/play/PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se.html
Super useful! Do you have any suggestion to create a dynamic message on cell selection. for example imgur.com/p7Zws0e so if I click on a cell with a date it will temporarely have a comment with the day of the week. (maybe ON_CHANGE?)
Thank you Luca - Yes SelectionChange procedure would be useful here. You might also find this article helpful: www.spreadsheet1.com/screentips--onaction.html
Thank you for your reply, Yes I'm using the latest windows 10 version 1803. What file format is the little sun you're using? I was trying to use a small .jpg file
Grab the file I used in the video from here 👉 pages.xelplus.com/vba-message-box-file
Step by Step teaching is much more appreciated and it is very useful for us, Jesus bless you!
You are an amazing instructor Leila ! Cant thank you enough for such great tutorials !!
Everything you do looks so easy, thank's för every video you post, amazing work.. 🙂
Thanks for the message about Message Box in VBA!!!
Thank you Mike for your message :)
This video is awesome, all your videos are on point Leila.
I managed to learn and create practical simple questionaire responses because I genuinely understood what you taught
Always the best and clearest tutorials
Thank you!
Thank you so much, you saved me here. As we usually say here in Brazil: Muitíssimo obrigado!
Thanks to my brilliant & Beautiful VBA teacher, very informative, very useful, waiting eagerly for the next topics.
Thank you very much Gopala. I'm happy to hear you like the VBA series....
ممنون لیلا جون
Excellent tutorial on msgbox. Thanks !!!
good example clear and concise. Thank you
Glad you like it Claudio.
Thank you for producing such great videos! I really like the organization, information, and all the details you cover in all your videos! Hope you have a great day!
Thank you Russell for your very nice comment and support.
Thanks a lot for this msgbox ..I got some new knowledge
I need something more if you can ^^
How to show Notification message in Tray excel vba
I need to see your method as an expert moreover, as I know you a great person with helpful ideas and explantions
Thank you for passing on you're knowledge, it worked
thank you Leila :) U R my favorite teacher :)
Thank you, for the excellent instructions, very clear and concise. 👌
Thank you for your video. Message boxes are very easy so wasn't going to watch it. Thankfully I did as I didn't know you could add certain types together or access the function like you did. Just shows you that you can always learn new things
Hi Gary - I'm glad you found something new :)
Nice and very informative video..
Hi i have a question can I create msg box while saving any spreadsheet because I use excel on daily basis in my job and huge data so if I set some control check so that i can minimize the error
all your videos are very helpful. Thanks
I'm really glad to hear that.
Thank you very much for your teachings for your big fan your youtube subscriber and I had purchased udemy of Microsoft excel vba course 6 months back and I had learned so much from your course I request to you madam please if you know about Tally definition language please make the course on it
Leila you are just awesome!
i found that your tutorial always amazingly useful .. thank you very much ..
Thank you Abdul. I'm glad you like them.
Thankyou mam very knowledgable topics..
You explain very well. Thank you.
Thank and i love you Leila Gharani im learning a lot !!!! Muah!!
Thanks for the video Leila! VBA is amazing and msgbox is so useful !
You're very welcome Kevin. Agree on both points :)
Thank you!
Very powerful.
Thank you very much miss
Please learning vba msgbox in add photos
Thank you Leila for this short, but useful, tuto
You're very welcome Mehdi. Thank you for your support.
@@LeilaGharani wtf
Love this tutorial! Great job, Leila!!
Glad you like the video!
Thanks! Your lessons are awesome. However just a suggestion. You should use some bigger screen for display. Kind of smart board. As the visibility is quite less in the current system.
I've learnt a lot from you, thanks
Thanks Leila, I really found this helpful.
Very nice video It's very helpful for me to use vba in my Excel works
Glad you like it Anubhav.
It's an amazing presentation....
Very useful......
I love you very much.....
Thanks.....💗💗💗💗
Glad you like it :)
Leila Gharani
Your profile picture is so heart touchy......and your presentation is very usefully and I am very happy...
Thank you Leila for this tuto........merci beaucoup pour votre aide ;)
You're very welcome. Thank you for your support.
Awesome video!
Thanks a lot Leila.
Man thanks
Incredible!
I will review those sections. Thank you Mam.
You're welcome Siva.
Gr8 Vedio Very Informative knowledge , Thanks
Thank you. Glad you like it Manoj!
thanks Leila Gharani
Thanks Leila, Very Interesting :)
You're very welcome John - VBA can be fun too :)
Is there an option to record it instead of manually typing the codes? Thanks. Appreciate your tutorials
thanks thanks thanks
its magic 👍
Good One!!!
in Portuguese we usually say in the young figures of speech "ball show" or "show de bola!!"
Your videos are really helpful...can u show me how if number multiple 10(10,20,30....) occur show available...... Plz it's urgent
Thank you for helpful video.
Is there a way to make the message box fancy?
Thanks :)
I want you to show as a practical.
Awesome way to describe Msgbox Leila. Please suggest how we give the background color in msgbox.
The MsgBox object has limited customization features. If you need something more sophisticated (i.e. logos, font controls, backgrounds, etc...), you need to use UserForms.
Hi Leila. Question, I've got a scenario I'm wondering if it is doable with Message Boxes. Is it possible to have a message box pop up as an event procedure say maybe upon opening a workbook and display only cells that have values in a given range as well as values of an adjacent column? So for example, if I want a message box to show only those cells that have values from Column I(Eye not L) and then the corresponding values in column C, could a message box do that as a vertical listing? So something like:
John Smith - 100
Nancy Smith - 50
Paul Smith - 75
I'm not familiar with the limitations of Message Boxes, but is it possible to do something like that?
Thank you. What is the best way to provide the user with multiple lines of information when a button is clicked? Message boxes are great but requires code to insert lines. Is it better to use a text box on a user form? Thank you.
Your videos are awesome. Question for you, how can you change the font/color of the test in the MSGBOX? Is that doable? Thanks
You can't do that using the standard msgbox. You can do it by creating a userform.
Great video,is there a way to make the msgbox timed?
I was wondering if there was a way to refill the table after you clear it with the message box. I want to be able to change my chart and if I need to restart, I can hit the clear button and then it will clear and then start from my original table. Is this possible?
hello leila thanx to share with these type of video bt i would like to say you that although ur content is very good all of us bt i request to u that pick the topic project wise and solve this from where we can learn more.olzz donot mind bt i need this type of video
Thanks Ashish for your comment. Yes - I will be adding in a few of the projects on TH-cam too once we cover some of the basic VBA logic.
Thank you Ms. Leila the video is great but i really want your advice how can i understand VBAs
You're welcome Ismail - it's best to start from the beginning - you can watch the playlist from the start to see if it's something for you - but to get an in-depth understanding I would suggest a book or a complete course....
which is the tutorial for the excel events function you mentioned?
Hi,, thanks for the video but How can we use this welcome msg whenever we open the excel? (as I tried but it didn't work) (I have already enabled and saved excel as Macro Enabled Worksheet. Also if I want the user to fill a specific cell and he left it blank, is there a way to stop him from closing/saving the file (with an error msgbox)?
Thanks in advance for your support.
Private text box 3
Anything i can do about that spinning wheel you get when the cursor is moved off the message?
I literally had someone wait for it to go away before trying to click 'ok' in the prompt...
Are you doing online courses?
Yes, you can check them out here: www.xelplus.com/courses/
Is it possible to put pop up if value exceed certain number?
can you show me how to set up the message box in VBA with expiry date and there are 2 tabs different which are sitting in one file?
Can you help me, for different kind of price rating method in Excel (like FIFO , etc)
Hi Leila.. What if we want to display Emp name with Top 3 bids.. What will be the coding then?
thanks .. How can I put intend to cods' line like yours?!?
I am losing my touch
Greatungs ur highness
Happy thursday
I'll be uploading VBA videos on Tuesdays for a bit for the VBA series and the usual Excel videos on Thursdays. So happy Thursday is still in place :) Thanks for dropping by on Tuesday too. See you in 2 days.
Leila Gharani can i reply now in case of
😅😄😇
@@LeilaGharani bi ommmhnɓbk
Ppppomhu bbjih go. Mnñbnnnbbyou jup
how can I make an excel spreadsheet give an "expired date" message when I turn on my computer? without opening excel?
How to connect userform inside msgbox
Is there a way we can change the fontsize inside the msgbox?
How to custom button name in msgbox like "start & Stop" instead of Yes & No?
Mm. very very nice video,
Mm. how to change text size or colour inside vba msg box
Hi, Just want to confirm do you have VBA videos for outlook automation?
Please advise. Thanks
Hi - in the full vba course I cover two methods to send automatic emails from Excel. One is a simple method that uses your default email and the 2nd is for Outlook. We generate different PDF files for different people and we automatically attach them to an Outlook email (taking the email addresses from the Excel file) - we cover this in the 3rd milestone of the course.
Hi Mam, this is Siva Kumar
I got the access to videos from udemy. I started learning. May I know what is automation in excel/vba and how to do that. Can i have any sample videos for that. Thank you Mam.
Hi Siva - automation in Excel is any procedure that's done automatically - for example in this video, when we click on the button and we get a message box asking us if we want to delete data and we click "yes" and it deletes - that's a mini automation. When you program an Excel tool with VBA, you can automate many different tasks. Inside the course in first milestone (section 9) we automate creating a Table of Contents for our files, in the 2nd milestone in section 14 we automate importing data from other files and creating csv files and so on...
I donot want any sort buttons i.e. ok cancel just show message and keep on showing it until it exit sub then what to do
i am getting expected # error on the same line of code ? for the = sign
Can you write in another language? ie. Chinese, Korean, Japanese. Thank you!
Dear Ma'am i am biggner to learn about VBA please guide me from Basics to upper level
Hi Santhosh. I have a course that takes you from beginner to advanced here bit.ly/LeilaVBA. It's over 20 hours long. I also have a free playlist here, but start from the beginning of the list: th-cam.com/play/PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se.html
Let me check Ma'am.
Thanks for your prompt Response.
In 6:15 timestamp, Can anybody help me to know when we need to use BRACKETS and when we shouldn't?
Your reply / Support will be appreciable.
How can I create a message without expecting a response from the user
Super useful! Do you have any suggestion to create a dynamic message on cell selection. for example imgur.com/p7Zws0e so if I click on a cell with a date it will temporarely have a comment with the day of the week. (maybe ON_CHANGE?)
Thank you Luca - Yes SelectionChange procedure would be useful here. You might also find this article helpful: www.spreadsheet1.com/screentips--onaction.html
It looks cool but is so difficult to follow up,,,,, I´ll keep looking for tutorials ;(
hii liela madam me vijay frm jaipur "how I cn join ur excel vba complate course plz tell me bcoz I wnt to learn vba nd chart pivot dashboard
That's great Vijay. You can check out my courses here: www.xelplus.com/courses/
How to open a file using msgbox vbYes ?
Thank you, unfortunately I cannot get a picture on top of the button, bring to front not working excel 2007
Do you have windows? It should work. I've done this in much older versions of Excel as well...
Thank you for your reply, Yes I'm using the latest windows 10 version 1803. What file format is the little sun you're using? I was trying to use a small .jpg file
This isn’t shreck, wtf