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!
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 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
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
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?
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.
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.
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.
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....
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
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
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: ua-cam.com/play/PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se.html
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.
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!
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 for the message about Message Box in VBA!!!
Thank you Mike for your message :)
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 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 !!!
Thank you so much, you saved me here. As we usually say here in Brazil: Muitíssimo obrigado!
Thank you for passing on you're knowledge, it worked
Thank you, for the excellent instructions, very clear and concise. 👌
good example clear and concise. Thank you
Glad you like it Claudio.
all your videos are very helpful. Thanks
I'm really glad to hear that.
thank you Leila :) U R my favorite teacher :)
You explain very well. Thank you.
i found that your tutorial always amazingly useful .. thank you very much ..
Thank you Abdul. I'm glad you like them.
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 :)
ممنون لیلا جون
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
Leila you are just awesome!
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 :)
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 for this short, but useful, tuto
You're very welcome Mehdi. Thank you for your support.
@@LeilaGharani wtf
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 Sis
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...
Love this tutorial! Great job, Leila!!
Glad you like the video!
Thankyou mam very knowledgable topics..
I've learnt a lot from you, thanks
Thank you Leila for this tuto........merci beaucoup pour votre aide ;)
You're very welcome. Thank you for your support.
Very nice video It's very helpful for me to use vba in my Excel works
Glad you like it Anubhav.
Awesome video!
Thanks Leila, I really found this helpful.
Thank you!
Thanks a lot Leila.
Very powerful.
Incredible!
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 very much miss
Please learning vba msgbox in add photos
Gr8 Vedio Very Informative knowledge , Thanks
Thank you. Glad you like it Manoj!
Thank you for helpful video.
Is there a way to make the message box fancy?
what if i want to allow the user to pick which cell the formula in the macro will be based on?
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.
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?
which is the tutorial for the excel events function you mentioned?
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.
its magic 👍
Thanks Leila, Very Interesting :)
You're very welcome John - VBA can be fun too :)
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
thanks .. How can I put intend to cods' line like yours?!?
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.
Great video,is there a way to make the msgbox timed?
I will review those sections. Thank you Mam.
You're welcome Siva.
how can I make an excel spreadsheet give an "expired date" message when I turn on my computer? without opening excel?
Is it possible to put pop up if value exceed certain number?
Is there an option to record it instead of manually typing the codes? Thanks. Appreciate your tutorials
Hi Leila.. What if we want to display Emp name with Top 3 bids.. What will be the coding then?
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.
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?
Good One!!!
in Portuguese we usually say in the young figures of speech "ball show" or "show de bola!!"
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.
Can you help me, for different kind of price rating method in Excel (like FIFO , etc)
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....
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.
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
thanks thanks thanks
Are you doing online courses?
Yes, you can check them out here: www.xelplus.com/courses/
How to custom button name in msgbox like "start & Stop" instead of Yes & No?
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 UA-cam too once we cover some of the basic VBA logic.
Can you write in another language? ie. Chinese, Korean, Japanese. Thank you!
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.
i am getting expected # error on the same line of code ? for the = sign
Thanks :)
thanks Leila Gharani
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
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 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
How to open a file using msgbox vbYes ?
Mm. very very nice video,
Mm. how to change text size or colour inside vba msg box
I want you to show as a practical.
How to connect userform inside msgbox
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...
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: ua-cam.com/play/PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se.html
Let me check Ma'am.
Thanks for your prompt Response.
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
Private text box 3
This isn’t shreck, wtf