Results 1 to 5 of 5

VBA Function Help

Threaded View

Jay637 VBA Function Help 04-17-2008, 04:57 PM
shg Jay, please edit your post to... 04-17-2008, 05:00 PM
Jay637 Thanks for the quick reply,... 04-17-2008, 06:41 PM
shg Yes: encapsulate it as a... 04-17-2008, 07:29 PM
Jay637 Thanks a lot shg... I... 04-17-2008, 07:43 PM
  1. #1
    Registered User
    Join Date
    07-20-2005
    Posts
    6

    VBA Function Help

    Hi,

    I'm trying to simplify some of my VBA function codes. For example:
    Function func1(x,y)
    
    zzz = x + y
    
    func1 = zzz * 2
    
    End Function
    
    Function func2(x,y)
    
    zzz = x+y
    
    func2 = zzz * 3
    
    End Function
    Is it possible to not keep typing in the "zzz = x+y" line in each function that needs the "zzz" value?

    Thanks,

    Jay
    Last edited by Jay637; 04-17-2008 at 06:16 PM.

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