+ Reply to Thread
Results 1 to 13 of 13

Excel 2007 : How I implement a code?

Hybrid View

  1. #1
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: How I implement a code?

    You put the code in a standard module
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  2. #2
    Registered User
    Join Date
    02-13-2011
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: How I implement a code?

    Thank you for the earlier answer.
    I attached a picture. This is a standard module?
    Attached Images Attached Images

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,959

    Re: How I implement a code?

    Quote Originally Posted by marianmix View Post
    Thank you for the earlier answer.
    I attached a picture. This is a standard module?
    Yes, that is a standard module. Just paste the code in, alone. You do not need to add any other code, like you did here:

    Sub Macro1()
    '
    ' Macro1 Macro
    '
    
    '
    Then in your spreadsheet you can use the function like this:

    =SplitText(A1,5,10)

    or whatever arguments are appropriate.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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