Re: UDF

From: Norman Harker (njharker_at_optusnet.com.au)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 10:38:32 +1000

Hi All!

And now a question.

I've found that I can use the Sheet on an addin to call my functions
in upper case and thus force conversion of entry to upper case.

How can I best achieve this for an existing Addin? 

-- 
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Norman Harker" <njharker@optusnet.com.au> wrote in message
news:%23Ugw34MFEHA.1272@TK2MSFTNGP12.phx.gbl...
> Hi Hans!
>
> Prevention better than cure?
>
> Close Excel
> Re-Open
> Put the function in your Personal.xls file
> Unhide the Personal.xls
> Use the function in upper case in the Personal.xls file
> Hide the Personal.xls
>
> Now try and use your function using lower case.
>
> Or:
> Close Excel
> Open Excel
> Put the function in a separate file
> In the (compulsory) empty sheet use the function with upper case
> Save as an Addin in the Library File
> Close Excel
> Open Excel
> Tools > Addins
> Select your new Addin
> Try using the new function without using upper case
>
>
> Thanks for this post! We now have a way of getting UDFs to convert
to
> all upper case if entered in lower case. John Walkenbach (I recall)
> recommends using lower case entry of functions as failure to convert
> to uppercase indicates a mis-speling.
>
> -- 
> Regards
> Norman Harker MVP (Excel)
> Sydney, Australia
> njharker@optusnet.com.au
> Excel and Word Function Lists (Classifications, Syntax and
Arguments)
> available free to good homes.
> "Hans Knudsen" <hans.knudsen__REMOVE__@mail.tele.dk> wrote in
message
> news:%23P68ciIFEHA.3856@TK2MSFTNGP12.phx.gbl...
> > Thank you to all who replied.
> > Should I add that shortly after I posted my message I tried the
> following which also worked:
> >
> > 1.  Changed the code so that all instances of EF temporarily were
> named EFF.
> > 2.  Used the function EFF one time in a worksheet.
> > 3. Changed the code back (EFF replaced by EF)
> > 4. Used the function EF in a worksheet, remembering to enter EF
> (uppercase) the first time.
> >
> > Regards
> > Hans Knudsen
> >
> >
> >
> > "Hans Knudsen" <hans.knudsen__REMOVE__@mail.tele.dk> skrev i en
> meddelelse news:uGQtQl9EEHA.3336@TK2MSFTNGP12.phx.gbl...
> > > Hello
> > > I made a UDF and wanted to name it EF (uppercase). However,
first
> time I entered the function, I happened by mistake to enter ef
> > > (lowercase). Is there any way I can change it back to uppercase?
> > >
> > > Hans Knudsen
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Hyperlink from Word to specific sheets in Excel workbook
    ... The easy way - In Excel click the unmarked box where the Column & Row ... Heading bars meet (upper left corner) to select the sheet you want to link ... In Word use Edit>Paste as Hyperlink. ...
    (microsoft.public.word.docmanagement)
  • Re: AutoSave code problem
    ... you may want to look at Jan Karel Pieterse's addin called ... > sheet, when AutoSave runs, the leftmost worksheet in the tab order is ... > If I close Excel, then create a new blank workbook and run this code ...
    (microsoft.public.excel.programming)
  • Displaying help for an addin
    ... I have a "Help" sheet within the addin file. ... Excel file once the addin is installed. ...
    (microsoft.public.excel.programming)
  • Re: AutoSave code problem
    ... you may want to look at Jan Karel Pieterse's addin called ... >> sheet, when AutoSave runs, the leftmost worksheet in the tab order is ... >> If I close Excel, then create a new blank workbook and run this code ...
    (microsoft.public.excel.programming)
  • Re: cleaning up Windows DLL (made with VB6)
    ... a new session of Excel. ... use as an Automation Addin for Excel, and wanting to use the "Register UDF" ... involves aliasing the UDFs in your addin with functions in a Windows-style ... I can now make Windows DLLs from VB6 (the kind you ...
    (microsoft.public.vb.general.discussion)