Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 533
Default Alter ribbon button label on the fly?

You should use Outlook Express or another real newsreader. The attachment is
right there. Web interfaces block it I gather.

If you send me an email I'll send it to you. jrrechAThotmail.com

--
Jim
"XP" wrote in message
...
Hi Jim,

Your attachment did not come through?

"Jim Rech" wrote:

Actually it's pretty straightforward to dynamically change button text,
if I
understand what you want correctly. See attached.

--
Jim
"XP" wrote in message
...
|I have a custom ribbon with a date button, a Fund dropdown, and an
import
| button.
|
| When the user clicks the "Date" button, I have an input box open in
which
| the user enters a date (the date is validated using VBA under the
covers).
I
| would like the date entered by the user to then appear in the label of
the
| "Date" button. So when a date has been selected, the "Date" button will
| appear as: Date: 04-28-2008
|
| Can this be done? If so, could someone please post generic example code
that
| does it?
|
| FYI, the next step will be to capture the date stored in the label
(right
| 10) and run an import based on that date and the selected Fund selected
in
| the dropdown.
|
| Thanks much in advance



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ribbon and Office Button Hidden L Lightner Excel Discussion (Misc queries) 2 September 1st 09 02:04 PM
changing the order of the ribbon button Craig Excel Discussion (Misc queries) 1 April 28th 08 10:14 PM
no custom button in ribbon Birgit[_2_] Excel Programming 3 February 21st 08 03:41 PM
Add strikethrough button to ribbon George Conard Excel Discussion (Misc queries) 1 February 15th 08 08:53 PM
Alter mask of image on button RB Smissaert Excel Programming 1 January 8th 06 11:36 PM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"