ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PASSING A STRING VALUE (https://www.excelbanter.com/excel-programming/275334-passing-string-value.html)

sirron

PASSING A STRING VALUE
 
I have 2 modules my first module contains a string that
has a value and I want to pass that string value to
another module how can this be done?
thanks Sirron

Harald Staff[_4_]

PASSING A STRING VALUE
 
Sub test()
Call SomewhereElse("Hi Sirron !")
End Sub

Sub SomewhereElse(What As String)
Dim L As Long
For L = 1 To 3
MsgBox What, , L & " of 3"
Next
End Sub

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Sirron" wrote in message
...
I have 2 modules my first module contains a string that
has a value and I want to pass that string value to
another module how can this be done?
thanks Sirron




[email protected]

PASSING A STRING VALUE
 
can you be more specific, where exactly is the string



-----Original Message-----
I have 2 modules my first module contains a string that
has a value and I want to pass that string value to
another module how can this be done?
thanks Sirron
.



All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com