Re: UDF

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

Date: Mon, 29 Mar 2004 00:08:56 +1000

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: UDF
    ... 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? ... Excel and Word Function Lists available free to good homes. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Changing file in all upper case to upper and lower case
    ... > values in place with a macro and be done with it without having to clean ... > To convert a selection on a worksheet see upper_case macro at ... > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm ... >>> I have a file of names and addresses that were entered in all upper case. ...
    (microsoft.public.excel.misc)
  • Re: Uppercase trick not working
    ... I went back and copied the upper/lower doc into Word. ... and it worked -- copied all upper. ... >> Word, make it all Uppercase, then copy and paste in back into Excel. ...
    (microsoft.public.mac.office.excel)
  • Re: closing 1 file at a time
    ... Have you tried another method of closing individual files, ... However, unlike Word, when I close one Excel file in the task bar ... > (the same is true when I close from the upper right close button in the ...
    (microsoft.public.excel.misc)
  • Re: Button to change view location
    ... The procedure works when I try it using Excel 2000 on Windows XP ... When pressed would move the user to view "Detail1" with cell A1 in the ... the upper left corner. ...
    (microsoft.public.excel.programming)