M m

' EI-©S Microsoft Excel Qb|e I—® Sheet 1 (Sheet 1) Sheets (5heet2) Sheet3 (Sheet3>

ThisWorkbi B-ë5 Modules Nft Modulel —«ÎJ Modules VBAProject (OfficeEHi

Module2 Module 3

Jet'c ]categoiged|_

Jïypeâ question for help

Calculai e_EKpenses

Sut) Calculate_Expenses 1 Calculate Expenses I

^ |Join_Strings

) Join_Strings () n TestStringl As String 1 n TestString2 As String 1

= TestSti

H353ZT

Type TestString3 = TestString1 & TestString2

replacing TestString3 with the variable to contain the concatenated string and TestStringland TestString2 with the string variables.

Q Type Cells(1,1) = TestString3, replacing TestString3 with the variable containing the concatenated string.

0 Run the corresponding macro in Excel.

1-lalxl

Jïypeâ question for help

-■ The value of the first cell becomes the concatenated string created in step 7.
0 0

Post a comment