Results 1 to 5 of 5

How to update a function when opening worksheet

Threaded View

  1. #1
    bugmenot
    Guest

    How to update a function when opening worksheet

    I made


    Public Function GetMonth()
        GetMonth = Sheet1.Range("H2").Text
    End Function
    and then in a cell I entered =GetMonth()
    and it displays what I want it to display but does not update when I reopen the program in the even that the date has changed... How would I go about doing this? I don't mind making a button to refresh the data as I already have one that does that and I could just add to it
    Last edited by bugmenot; 07-21-2009 at 01:45 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