Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a string by reference?
Is it possible to return a string "by reference" through a string
parameter? Here's what I'm trying to do: -------------------------------------------------------------------- Sub GiveBackString (ByRef targ as String) targ = "Hello" ' This string is returned through 'targ' variable??? End |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a string by reference?
hi Robert,
Public Const MyString = "Hello" Sub test() GiveBackString MyString End Sub Sub GiveBackString(ByRef targ As String) MsgBox targ End Sub isabelle Le 2013-02-02 03:51, Robert Crandal a écrit : Is it possible to return a string "by reference" through a string parameter? Here's what I'm trying to do: -------------------------------------------------------------------- Sub GiveBackString (ByRef targ as String) targ = "Hello" ' This string is returned through 'targ' variable??? End |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert cells reference to string reference?? | Excel Programming | |||
EXCEL: find string in vector & return cell reference | Excel Worksheet Functions | |||
return partial string | Excel Worksheet Functions | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
SQL string to return top row | Excel Programming |