+ Reply to Thread
Results 1 to 6 of 6

Date on Excel Ribbon

  1. #1
    Forum Contributor CobraLAD's Avatar
    Join Date
    07-23-2007
    Location
    Boksburg, South Africa
    MS-Off Ver
    Office 2019
    Posts
    346

    Date on Excel Ribbon

    Is it possible to display today's date on a ribbon button, if so how will you give the label the command?
    Last edited by CobraLAD; 05-06-2013 at 03:23 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Date on Excel Ribbon

    You need to use the getLabel callback

    standard code module.
    Please Login or Register  to view this content.
    customui xml
    <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" >
    <ribbon >
    <tabs >
    <tab
    id="Tab1"
    label="Tab1">
    <group
    id="Group1"
    label="Group1">
    <button
    id="Button1"
    imageMso="ViewAllProposals"
    size="large"
    getLabel="Button1_getLabel"/>
    </group >
    </tab >
    </tabs >
    </ribbon >
    </customUI >
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor CobraLAD's Avatar
    Join Date
    07-23-2007
    Location
    Boksburg, South Africa
    MS-Off Ver
    Office 2019
    Posts
    346

    Re: Date on Excel Ribbon

    Thank you very much Andy

  4. #4
    Forum Contributor CobraLAD's Avatar
    Join Date
    07-23-2007
    Location
    Boksburg, South Africa
    MS-Off Ver
    Office 2019
    Posts
    346

    Re: Date on Excel Ribbon

    if I add
    Please Login or Register  to view this content.
    it auto add the date to the cell. How wil the button be setup so that the date is added only when the button is clicked

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Date on Excel Ribbon

    you need the onAction callback not the getLabel one for pressing the button
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  6. #6
    Forum Contributor CobraLAD's Avatar
    Join Date
    07-23-2007
    Location
    Boksburg, South Africa
    MS-Off Ver
    Office 2019
    Posts
    346

    Re: Date on Excel Ribbon

    Thanks Joseph

+ Reply to Thread

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