.onaction

  1. Dr. Demento

    Sub quits on Dropdown.OnAction assignment

    I'm running a sub from PERSONAL.XLSB that assigns a DropDown to the active sheet. Below is how it's being assigned. Dim ddFilterDropDown As dropdown ' Add a new filter dropdown Set ddFilterDropDown = rngDest.Parent.Shapes.AddFormControl(xlDropDown, _...
  2. I

    From Personal.xlsb, set .onaction macro to a macro in a worksheet in a differert workbook.

    From personal.xlsb, I am trying to create a button in the calling workbook and assign a macro that exists in one of the worksheet in the calling workbook. All of the combinations I have don't produce a macro that is correctly defined. I thought this was going to work since this is exactly how...
  3. K

    Change .onaction of a button created as part of a macro

    As part of a routine I create a button to perform an advance filter. With Sheets("Data").Buttons.Add(300, 0, 100, 25) .OnAction = "PO_Filterinplace" .Characters.Text = "View Supplier" End With Rather than having a separate clear filter button I would like to change this button when the...
  4. L

    Passing multiple arguments to a subroutine using the .onaction command in a menuitem

    I am trying to pass 2 arguments to a subroutine by assigning it to a .onaction command. The code works when I only pass one string argument but falls down ( I get the "The macros is not available in this workbook or all macros are disabled" error) when I try and add a second integer argument...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top