How do I save the captions on buttons on a VBA for

  madwab 11:32 02 Mar 2005

(Also posted on the MrExcel forum earlier today.)

I have a spreadsheet with several buttons whose captions I change of the fly. When I save the sheet and reopen, the altered captions are still in place.

In the same sheet I have a form which has several buttons. When I alter their captions and close and reopen the sheet, they revert to the original, unmodified captions.

Is there a way of forcing the modified captions to be saved? (I'm using Excel 2000 / WinXP.)

If you have set the 'Caption' property of the first set to blank strings then they will retain the fly version, on the second set if you have set the captions property to a value then they will revert to that value on reopening.

Hope that makes sense.

  madwab 07:44 09 Mar 2005

- make sense to me, that is. Blank strings seems to cause the buttons not to display, but when captions are then applied they still aren't saved. I've got around this by applying captions when the form is opened, but that shouldn't be necessary...

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

There’s more to Finnish artist Tove Jansson than creating the Moomins

iPhone X news: Release date, price, new features & specs

Comment regarder la Coupe du monde de rugby à XIII en direct ?