sub helloworld()

public World As String
world = someFunction_returns_string

end sub


sub byebye()

MsgBox(world)

end sub

the message box returns nothing....did i do something wrong ?

Hi

You need to declare the public variable outside the Subroutine

public World As String

 sub helloworld()

world = someFunction_returns_string

end sub

hope it works

Cheers
Shasur

sub byebye()


http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi there..

Shasur response is correct, but do you understand why that happens?? maybe you have to read something about variables scopes...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========