Bullsandbears123
Technical User
I have a function that I use for repeated procedures. When I insert the function in code it always want to be set to a value. Is there a way to get ride of having to set it?
Example (simplified):
Function myfunction()
'set cbobox to default
cbobox.value=1
end function
******************
The VBA want my to set myfunction = to something when I don't.
---It wants this
dim value as variant
value=myfunction()
---When I just want to run the function
myfunction()
Any ideas as to get the function to run with out setting it equal?
THANKS
Example (simplified):
Function myfunction()
'set cbobox to default
cbobox.value=1
end function
******************
The VBA want my to set myfunction = to something when I don't.
---It wants this
dim value as variant
value=myfunction()
---When I just want to run the function
myfunction()
Any ideas as to get the function to run with out setting it equal?
THANKS