PC Review


Reply
Thread Tools Rate Thread

Disabling Function Results in the Function Arguments Window

 
 
john.w.palmateer@boeing.com
Guest
Posts: n/a
 
      23rd Sep 2008
I have written user defined functions that are passing matrices as
arguements and would like to disable the function results in the
function arguement window. Any suggestions?
 
Reply With Quote
 
 
 
 
Héctor Miguel
Guest
Posts: n/a
 
      24th Sep 2008
hi, john !

> I have written user defined functions that are passing matrices as arguements
> and would like to disable the function results in the function arguement window.
> Any suggestions?


a wild idea is valid ?

make your udf a private function procedure (so it won't appear in the function-wizard dialog)
and *call* for it knowing that *there it is* (you shall provide the *known* arguments)

also, note that you won't be able to paste it's arguments in formula-bar (ctrl+shift+A)

hth,
hector.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: customise Insert Function/Function Arguments dialog box Niek Otten Microsoft Excel Programming 1 14th Dec 2006 11:27 AM
Need to open the Function Arguments window from VBA for a user defined function. korrin.anderson@gmail.com Microsoft Excel Programming 0 20th Jun 2006 03:53 PM
Representation of optional parameters in Function arguments window compound Microsoft Excel Programming 0 17th Jan 2006 11:32 PM
Results of asp.net function in new window Web Team @ Borough of Poole Microsoft ASP .NET 0 14th Jun 2005 09:12 AM
problem with IF function with results from MATCH function michelle Microsoft Excel Worksheet Functions 3 24th Oct 2003 11:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:13 AM.