+ Reply to Thread
Results 1 to 3 of 3

UDF, Subsequent macro syntax error

  1. #1
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    UDF, Subsequent macro syntax error

    I am trying to design a UDF that will translate Japanese words into English

    The first bit of code is the UDF,

    The second bit of code is where I get the error, when I try to use the UDF.

    Any help on the syntax for getting the macro to work would be great.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JapanDave; 01-07-2012 at 07:45 AM.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: UDF, Subsequent macro syntax error

    Your argument must be in brackets:
    Please Login or Register  to view this content.

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: UDF, Subsequent macro syntax error

    Please Login or Register  to view this content.
    You'd better put both in 1 module.

    Used as an UDF:

    in cell D1:
    PHP Code: 
    =translation(A1
    Last edited by snb; 01-06-2012 at 08:17 AM.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1