button caption

  1. M

    How to create an ActiveX button and add code to it (tell it what sub to run) using vba?

    Hello. I'd like to create an ActiveX button in a sheet and assign a code to it (i.e. tell it to what sub to run and that sub already exists). I can create the button: (recorded) ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False _ , DisplayAsIcon:=False...
  2. G

    Button caption toggles whether on or off

    Dear All, Using Excel 2003, I am looking for a way to have a button where the caption toggles (changes) whether the button is on or off. I want the caption to read "US Dollars" when the button has not yet been pressed, to read "Canadian Dollars" after the button has been pressed, and to...
  3. S

    Special requirements for Save As File dialog box

    Hello, I want to open Save As File dialog box in Excel. I need it to have these features: 1) ability to add filters (msoFileDialogSaveAs does not support it) 2) ability to change Save As button text 3) Unicode support I was able to get all my mentioned functionality with...

Some videos you may like

This Week's Hot Topics