+ Reply to Thread
Results 1 to 3 of 3

adding mutiple dates to message box

  1. #1
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    141

    adding mutiple dates to message box

    Hi guys,

    Just wanting to know is this possible to do,

    I currently have a message box that comes up displays multiple things about my spreadsheet
    I am now wanting to try and add in that message box information about my members licences when they get down to 90 days to display

    I have 10 members so I will have the main sheet then members have there own sheet with there reports of there license dates
    I have only added 2 sheets in the attached spreadsheet the rest are the same

    so I would like the message to say the members name being in row 4 then needs the following either grader / digger / loader or forklift renewed when the day reaches 90 days or less and will stay on the message until the license has been updated

    this would work with message 5 in this code under licence due


    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: adding mutiple dates to message box

    Please Login or Register  to view this content.
    make sure you point to the correct worksheet when it loads
    i assume its the E22b?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: adding mutiple dates to message box

    How about this ?

    Edit:
    Change this
    Please Login or Register  to view this content.
    to this
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by bakerman2; 01-14-2018 at 09:21 PM. Reason: code amendment
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. Adding Mutiple Cells using IF function
    By sankalpchandran in forum Excel General
    Replies: 6
    Last Post: 02-26-2015, 08:39 AM
  2. [SOLVED] Shorter Method for adding data on mutiple pages
    By BBAUGH800 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-24-2014, 06:15 PM
  3. Adding an input message to each cell to bring back corrsponding message
    By Nic31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2014, 09:28 AM
  4. how to add mutiple cells to be include in the body of message.
    By DON_BLACK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2013, 04:59 PM
  5. Adding mutiple rows
    By klind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2013, 03:29 PM
  6. [SOLVED] Formula for adding mutiple numbers in one cell
    By joeybisho in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-17-2013, 10:39 PM
  7. Vlookup Help! Adding mutiple values.
    By mightybhwk in forum Excel General
    Replies: 3
    Last Post: 12-15-2011, 02:05 PM

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