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
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 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
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 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 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
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.
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?
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.
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?
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.
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....
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...
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.
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: ruclips.net/p/PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se
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 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 - 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.
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
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
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.. 🙂
Always the best and clearest tutorials
Thank you!
Thanks for the message about Message Box in VBA!!!
Thank you Mike for your message :)
Thank you so much, you saved me here. As we usually say here in Brazil: Muitíssimo obrigado!
Excellent tutorial on msgbox. Thanks !!!
good example clear and concise. Thank you
Glad you like it Claudio.
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....
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
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 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
Thank you, for the excellent instructions, very clear and concise. 👌
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
thank you Leila :) U R my favorite teacher :)
Thank you!
You explain very well. Thank you.
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.
i found that your tutorial always amazingly useful .. thank you very much ..
Thank you Abdul. I'm glad you like them.
all your videos are very helpful. Thanks
I'm really glad to hear that.
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 :)
Very powerful.
Thank and i love you Leila Gharani im learning a lot !!!! Muah!!
Thankyou mam very knowledgable topics..
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
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.
Leila you are just awesome!
Thanks for the video Leila! VBA is amazing and msgbox is so useful !
You're very welcome Kevin. Agree on both points :)
Very nice video It's very helpful for me to use vba in my Excel works
Glad you like it Anubhav.
Your videos are really helpful...can u show me how if number multiple 10(10,20,30....) occur show available...... Plz it's urgent
Man thanks
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...
thanks Leila Gharani
I've learnt a lot from you, thanks
Is there an option to record it instead of manually typing the codes? Thanks. Appreciate your tutorials
thanks thanks thanks
Thanks a lot Leila.
Thanks Leila, I really found this helpful.
Love this tutorial! Great job, Leila!!
Glad you like the video!
Awesome video!
I will review those sections. Thank you Mam.
You're welcome Siva.
Thank you Leila for this tuto........merci beaucoup pour votre aide ;)
You're very welcome. Thank you for your support.
Thank you for helpful video.
Is there a way to make the message box fancy?
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?
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.
Gr8 Vedio Very Informative knowledge , Thanks
Thank you. Glad you like it Manoj!
Incredible!
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?
I want you to show as a practical.
Great video,is there a way to make the msgbox timed?
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.
which is the tutorial for the excel events function you mentioned?
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 RUclips too once we cover some of the basic VBA logic.
Is it possible to put pop up if value exceed certain number?
Thanks Leila, Very Interesting :)
You're very welcome John - VBA can be fun too :)
thanks .. How can I put intend to cods' line like yours?!?
its magic 👍
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.
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....
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...
Good One!!!
in Portuguese we usually say in the young figures of speech "ball show" or "show de bola!!"
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?
Is there a way we can change the fontsize inside the msgbox?
Are you doing online courses?
Yes, you can check them out here: www.xelplus.com/courses/
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.
Hi Leila.. What if we want to display Emp name with Top 3 bids.. What will be the coding then?
How to connect userform inside msgbox
how can I make an excel spreadsheet give an "expired date" message when I turn on my computer? without opening excel?
Thanks :)
Can you help me, for different kind of price rating method in Excel (like FIFO , etc)
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
Can you write in another language? ie. Chinese, Korean, Japanese. Thank you!
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
How can I create a message without expecting a response from the user
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: ruclips.net/p/PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se
Let me check Ma'am.
Thanks for your prompt Response.
i am getting expected # error on the same line of code ? for the = sign
How to open a file using msgbox vbYes ?
It looks cool but is so difficult to follow up,,,,, I´ll keep looking for tutorials ;(
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
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.
Private text box 3
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, 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.
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
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
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/
This isn’t shreck, wtf