View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Keeping macros neat

I may be doing something wrong, but I couldn't get it to work in xl2002
(10.4524.4219) SP-2.



Hank Scorpio wrote:

On Sat, 12 Jul 2003 12:27:39 -0400, "Tom Ogilvy"
wrote:

Just for interest, while of not much utility, you can run a sub like
Sub Tester3(sStr As String)
Debug.Print "tester3: " & sStr
End Sub

from the textbox of the Tools=Macro=Macros dialog by entering

'tester3 "Hello"'

and hitting enter or clicking the run button - but it isn't displayed in the
list.

Based on some other information on xl2002, this may not be possible there -
I haven't tested it in xl2002.


This still works in xl2002.

<<snipped

--

Dave Peterson