Message Box - Inputs

Excel VBA for Beginners 10 - Interacting with users
7 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€92.84
List Price:  €129.98
You save:  €37.14
£79.48
List Price:  £111.28
You save:  £31.79
CA$136.74
List Price:  CA$191.45
You save:  CA$54.70
A$150.88
List Price:  A$211.24
You save:  A$60.36
S$135.02
List Price:  S$189.03
You save:  S$54.01
HK$781.40
List Price:  HK$1,093.99
You save:  HK$312.59
CHF 90.57
List Price:  CHF 126.80
You save:  CHF 36.23
NOK kr1,084.75
List Price:  NOK kr1,518.70
You save:  NOK kr433.94
DKK kr692.49
List Price:  DKK kr969.51
You save:  DKK kr277.02
NZ$166.11
List Price:  NZ$232.56
You save:  NZ$66.45
د.إ367.25
List Price:  د.إ514.16
You save:  د.إ146.91
৳10,956.06
List Price:  ৳15,338.92
You save:  ৳4,382.86
₹8,347.75
List Price:  ₹11,687.19
You save:  ₹3,339.43
RM473.85
List Price:  RM663.41
You save:  RM189.56
₦123,487.65
List Price:  ₦172,887.65
You save:  ₦49,400
₨27,772.29
List Price:  ₨38,882.31
You save:  ₨11,110.02
฿3,673.43
List Price:  ฿5,142.95
You save:  ฿1,469.52
₺3,227.91
List Price:  ₺4,519.21
You save:  ₺1,291.29
B$507.22
List Price:  B$710.14
You save:  B$202.91
R1,843.50
List Price:  R2,580.97
You save:  R737.47
Лв181.60
List Price:  Лв254.25
You save:  Лв72.65
₩135,529.28
List Price:  ₩189,746.42
You save:  ₩54,217.13
₪374.14
List Price:  ₪523.82
You save:  ₪149.67
₱5,714.50
List Price:  ₱8,000.53
You save:  ₱2,286.03
¥15,376.28
List Price:  ¥21,527.41
You save:  ¥6,151.12
MX$1,692.97
List Price:  MX$2,370.23
You save:  MX$677.25
QR364.12
List Price:  QR509.78
You save:  QR145.66
P1,360.02
List Price:  P1,904.08
You save:  P544.06
KSh13,423.65
List Price:  KSh18,793.65
You save:  KSh5,370
E£4,794.44
List Price:  E£6,712.40
You save:  E£1,917.96
ብር5,730.37
List Price:  ብር8,022.75
You save:  ብር2,292.37
Kz83,526.97
List Price:  Kz116,941.11
You save:  Kz33,414.13
CLP$94,107.58
List Price:  CLP$131,754.38
You save:  CLP$37,646.80
CN¥707.87
List Price:  CN¥991.05
You save:  CN¥283.18
RD$5,800.92
List Price:  RD$8,121.52
You save:  RD$2,320.60
DA13,449.71
List Price:  DA18,830.13
You save:  DA5,380.42
FJ$224.39
List Price:  FJ$314.16
You save:  FJ$89.76
Q775.96
List Price:  Q1,086.38
You save:  Q310.41
GY$20,884.44
List Price:  GY$29,239.05
You save:  GY$8,354.61
ISK kr13,954.60
List Price:  ISK kr19,537
You save:  ISK kr5,582.40
DH1,006.90
List Price:  DH1,409.70
You save:  DH402.80
L1,768.33
List Price:  L2,475.74
You save:  L707.40
ден5,716.08
List Price:  ден8,002.75
You save:  ден2,286.66
MOP$803.50
List Price:  MOP$1,124.94
You save:  MOP$321.43
N$1,847.92
List Price:  N$2,587.16
You save:  N$739.24
C$3,674.94
List Price:  C$5,145.06
You save:  C$1,470.12
रु13,329.02
List Price:  रु18,661.17
You save:  रु5,332.14
S/372.66
List Price:  S/521.73
You save:  S/149.07
K385.89
List Price:  K540.26
You save:  K154.37
SAR375.01
List Price:  SAR525.03
You save:  SAR150.02
ZK2,692.78
List Price:  ZK3,770.01
You save:  ZK1,077.22
L461.79
List Price:  L646.53
You save:  L184.73
Kč2,323.07
List Price:  Kč3,252.39
You save:  Kč929.32
Ft36,167.88
List Price:  Ft50,636.48
You save:  Ft14,468.60
SEK kr1,082.52
List Price:  SEK kr1,515.58
You save:  SEK kr433.05
ARS$87,865.40
List Price:  ARS$123,015.07
You save:  ARS$35,149.67
Bs691.31
List Price:  Bs967.87
You save:  Bs276.55
COP$388,509.43
List Price:  COP$543,928.75
You save:  COP$155,419.31
₡51,021.71
List Price:  ₡71,432.44
You save:  ₡20,410.72
L2,466.06
List Price:  L3,452.59
You save:  L986.52
₲747,341.53
List Price:  ₲1,046,308.05
You save:  ₲298,966.51
$U3,819.97
List Price:  $U5,348.11
You save:  $U1,528.14
zł401.45
List Price:  zł562.05
You save:  zł160.59
Already have an account? Log In

Transcript

Hey guys, welcome back. So in this video, we're going to speak about the three arguments for the message box that we're going to focus on, which is the prompt and the buttons and the title. And we're going to especially focus on the buttons because the buttons is basically the bread and the butter for the message box function. Because the prompt and the title are basically straightforward. So the buttons argument actually has different groups of values or different groups of constants that you can use. So this blue group here, for example, controls what type of buttons appear on your message box.

And this green group controls what type of message icons appear on the message box. So whether you have this error one or you have this exclamation or information or question, the yellow group, they couldn't Which button is the default button and the default buttons basically the button that is highlighted when the message box appears and this button will just get clicked straight away if you press space or Enter on your keyboard so if you press space or enter when your message box appears just straight away without thinking this is the button that's going to be executed. So this controls what button is going to be the default button is going to be highlighted and ready for you to press however Of course you can choose any other button using your mouse or using the direction keys on your keyboard. But these just control which button is going to be the default button.

The red group actually we're not going to discuss because three of the red group are not working at least in my experience. So the VB application modal on the VB system modal on the VB message box set foreground these are functions inherited from Visual Basic from the visual basic language used to desktop applications and I've tried them and they didn't make any difference to me and we're not going to discuss them. The VB message Help button is related to the help file on context arguments here which are obsolete, we're not going to discuss that as well. And these actually are not used Barri 99% or even more of the users who use message boxes. I haven't seen them being used so we will not need them. The white group here, the bV message box right and the VB message box RTL reading the first one here VB message box right just makes your text align to the right and this will be applied to both the title and the prompt.

So it will just make them get aligned to the right and the VB message box. RTL reading specifies that the text should appear as right to left reading on Hebrew and Arabic system. So it enables you to basically specify that you're going to write from right to left. So that is useful in case you're going to write in Hebrew, or Arabic, which is my native language. So this is going to be useful in that case. Okay, so let's have an example for the message box to illustrate these functions.

Okay, so let's have an example for the message box. So let's say message box. I love chocolate. So this is the simplest form of a message box, it contains only a prompt. And if you run it, you will have just the prompt the title is going to be the default title which is Microsoft Excel, but you can change that and you'll notice here that you've got an OK button. So the reason we've got an OK button is that if you just put a comma here you will see that the buttons argument has a default value of VB okay only.

So the VB okay on these the default value that if you do not modify the buttons argument, you will have a VB okay only or just an OK button. We can put a different set of buttons so we could have for example, VB yes no cancel, for example. So this will display a yes, no and cancel Suburbans. If we just run that you can see here, we'll have I love chocolate Yes, no cancel. And if you click on any of them, it doesn't make any difference. Because we are not putting any code to capture the user's input, which we will learn how to do shortly.

So now we've added just one input for one group or one category of inputs for the buttons argument, which is this blue category here which controls which buttons appear on your message box. Okay, so we've put an input from one category, which is the blue category. If you need to add another input from another category, you need to put a plus sign and you will get this drop down menu again to start selecting an input from another category. And please note that you cannot put too inputs from the same category except actually from the white category here because these two inputs do not cause a conflict. So you cannot put to have the blue or to the green or to the yellow. Okay, so after putting a plus sign, we can select something from the green categories.

So for example, VB information, so this will have yes no cancel buttons and also it will have the VB information this icon here and notice that the VB information has a sound effect that you've heard just now when it appears and there is also the VB default button one two, or three or four here, this yellow category, if you put a plus sign you can put something from that category as well. So here this just specifies which button is going to be the default button is going to be highlighted. So if we select one for example, VB default button one and we run that you can see here that the Yes button here is the one highlighted If you press space on your keyboard or enter straightaway without doing anything, this is the button that's going to be selected. Of course, you can select another button by pressing your direction keys on your keyboard or selecting it with your mouse.

So this is what the yellow category does, basically, the white one year VB message box, right? For example, if you put a plus in select VB, message box, right, it's just gonna make your text align to the right so I love chocolate and also the title are now aligned to the right. Now if you add another plus sign here and write VB message box, all RTL reading, which is the one for making you write in Arabic, or Hebrew, if you run that, you can see here that the information sign has actually moved to the right instead of being on the left. So it's kind of preparing you to write in Arabic or Hebrew, this way, okay, so now if you put another comma, you're going to be in the title argument and you can actually enter the titles. So for example chocolate here. And you can see here that because we've got VB message box, right, the title is going to be affected by that as well.

So also the title is going to be aligned to the right. So this is how the message box arguments work. And on the next video, we're going to see how to capture the user's input as well.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.