-
UserForm help
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
-
Do you mean
Code:
Userform.label1.Caption = fnOne() & vbNewline & _
fnTwo() & vbNewline & _
" are complete"
-
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.
-
[vba]
Function fnOnNe () AS String
fnOne = "ABCDEFG"
End Function[/vba]
-
Thank you very much!
I'm sorry for the late reply