When using public function in vba I inserted sum formula i.e.
Sum = textbox1.value + textbox2.value


When i calculate 1 and 2 it delivers 12 instead of 3 but other symbols such as *,/,- it works correctly. I did hear on internet that + and & used for concatination in vba. So is there a way to use + sign as addition symbol. Please reply.