View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tracey[_6_] Tracey[_6_] is offline
external usenet poster
 
Posts: 1
Default declaring a msgbox

Hello, I'm writing my first function using both an inputbox and
msgbox. Do I have to declare them at the beginning of the procedure?
i.e. dim msgbox as variant

Also, after doing this and using the F8 function to do a trial ru
through the code to see how it executes, it appears that the sub wor
at the beginning of the function causes a problem. Is it that thi
cannot qualify as a subprocedure? What should I do instead?

Thank you in advance.
Trace

--
Message posted from http://www.ExcelForum.com