+ Reply to Thread
Results 1 to 2 of 2

calling a function

  1. #1
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    office 2007
    Posts
    242

    calling a function

    Hi All

    I want to write a function. where user enters a DATE in A1 and it shows the day in B1.

    i know there is a text function in excel like text(a1,"dddd") which gives the value
    but if we have to write this function how to proceed.

    Also

    where do we call this function
    a)Private Sub Worksheet_SelectionChange(ByVal Target As Range) or
    b)Private Sub Worksheet_Calculate()

    Basically whats the diffrenece between this a and b

    Please Login or Register  to view this content.

    many thanx

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,882

    Re: calling a function

    Why would you want a function? If you have a date in cell A1, just put
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in cell B1 and format it as Custom | "dddd"


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro exits prematurely from function after calling other function
    By LouisPhilippe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 03:22 AM
  2. [SOLVED] help with calling a function (B) and return control of program flow to the calling functio
    By john/nyc in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-26-2012, 11:06 AM
  3. Calling Function on IF = Yes
    By opsman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2010, 07:44 PM
  4. Calling my function in VBA
    By jasonjenkinson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2006, 10:04 AM
  5. [SOLVED] calling a function
    By dmexcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-23-2006, 08:10 AM

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