What is the Difference between a sub and a function?
- 9 Answers
- 18845 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bhupendran
sub does not return's a value,but function return's value
| Is This Answer Correct ? | 36 Yes | 2 No |
Answer / aravindreddy
SUB is a method
FUNCTION is to return a value to it
| Is This Answer Correct ? | 29 Yes | 2 No |
Answer / alam
Function always returns a value but sub does not.
| Is This Answer Correct ? | 22 Yes | 4 No |
Answer / m. aqueel
Sub keyword is used for the procedures and procedures never
return a value where function key word is used for function
and function returns a value that can be assign to any
variable.
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / aaa
Function returns a value, Sub doesn't.
Function can be called from within a cell, similar to
=Today() function.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / kinjal
sub does not returns a value but function returns a value
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / bart calixto
yeah, sure.. everyone says that but...
what's the purpose of sub.?
I can do a function
Function ThisIsASub()
write "HELLO WORLD"
end Function
wow! I have a sub now.
so, besides the stupid reason that sub don't return value, what's the point of using subs?
If like someone create a newIF but it doesn't support ELSE... what's the point?
Greetings,
Bart.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / digvijay
Sub is also function but never return the value and Function
must return the value.
Function is user defined and System define but sub is
keyworlds that defined by user.
function can be macro but Sub is Not.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raju chauhan
Like a Function procedure, a Sub procedure is a separate
procedure that can take arguments, perform a series of
statements, and change the value of its arguments. However,
unlike a Function procedure, which returns a value, a Sub
procedure can't be used in an expression.
| Is This Answer Correct ? | 0 Yes | 0 No |
What's a windows process in .net?
Define marshling?
What is the native image generator?
What does jit compilation do in .net?
Explain the difference between vb and vb.net?
Sql Queries: A Table will be given Omiting Duplicate rows and adding a new column
Explain the difference between asp.net & vb.net and explain architecture?
What is .net assembly?
Explain Creational design pattern in .NET?
Give an example program for Getter /read-only methods in JAVA
A developer company sends dlls to the client. Some client is not happy current functionality, so request some modification. Developer made some changes and send new dll to all clients. Some client is happy with old version, tell me minimal change to so that neither clients get affected?
Explain the top .net class that everything is derived from?
Dot Net Framework 
