PDA

View Full Version : UserForm help



elyanivson
12-29-2011, 01:44 AM
Hi,
I'm trying to show many rows in Userform label.
I found out that I can do that by:
Userform.label1.Caption = "A" & VbNewLine & "b"

But,

I don't really know how to show it when I want to use many Functions.
I have 3 functions, that each of them returns a String and I want to show them in one UserForm,and each of the function in seperate line.

is that possible?

Thank you in advance.
Yaniv

Bob Phillips
12-29-2011, 03:38 AM
Do you mean



Userform.label1.Caption = fnOne() & vbNewline & _
fnTwo() & vbNewline & _
" are complete"

elyanivson
12-29-2011, 06:28 AM
first, thanks for your help.

now, lets say it's exactly what i meant to.
can you please tell me how should I write the fnOne function?
for example, I want the fnOne function to return "ABCDEFG".
Thank you very much for your time.

Bob Phillips
12-29-2011, 02:38 PM
Function fnOnNe () AS String
fnOne = "ABCDEFG"
End Function

elyanivson
12-31-2011, 10:10 PM
Thank you very much!
I'm sorry for the late reply