+ Reply to Thread
Results 1 to 4 of 4

Populated a variable with a formula

  1. #1
    Registered User
    Join Date
    08-01-2017
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    4

    Populated a variable with a formula

    Hello,

    I am trying to populate my variable called PeriodDate with an End Of Month formula through VBA.
    What I typed is below:

    PeriodDate = EOMonth(....)

    what happens after it adjusts is:

    PeriodDate = EoMonth(....)

    Could somebody please explain what I'm doing wrong?

    Thanks

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,845

    Re: Populated a variable with a formula

    Hello
    You can use evaluate for EOMonth
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    21,039

    Re: Populated a variable with a formula

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-01-2017
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    4

    Re: Populated a variable with a formula

    Thank you this worked!

+ 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. [SOLVED] Combobox populated with a list populated from another file
    By kemit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2016, 06:46 AM
  2. Replies: 3
    Last Post: 09-30-2016, 10:48 AM
  3. Can I populate multiple sheets with data from one sheet (variable name) is populated?
    By CastingDirector in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-17-2015, 02:04 PM
  4. [SOLVED] Populated a column by logical formula using IF
    By eugh in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-20-2013, 05:24 AM
  5. How to find where formula is populated from
    By Vack in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2012, 05:11 PM
  6. [SOLVED] Macro to calc. #'s btwn variable rows/columns corresponding to an adjacent populated cell
    By kbspence in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2012, 12:28 PM
  7. Can a msg box be populated via a macro variable?
    By smileyc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2009, 02:49 PM

Tags for this Thread

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