From the course: Excel: Learning VBA

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Concatenate text strings

Concatenate text strings - Microsoft Excel Tutorial

From the course: Excel: Learning VBA

Start my 1-month free trial Buy for my team

Concatenate text strings

“

- [Instructor] You can improve your customer's experience by incorporating their input into your responses. In this movie, I will show you how to combine, or concatenate text strings to do just that. My sample file is 05_05_Concatenate, and you can find it in the chapter five folder of the exercise files collection. In this workbook, I have a single worksheet. And on it, I have a cell, C5 that is shaded and has a number in it. And below, it asks the user to type in the number of cases they would like to buy. So the idea is that this might be displayed on a kiosk or on a touchscreen computer that is available in your store and the customers want to get information about bulk orders. So let's take a look at the VBA code that works with this particular form. So I'll press Alt F11. And in module one, I have a subroutine called VolumeDiscount. At the top, I declare a number of variables. I won't go through them all because there…

Contents