oleformat

  1. T

    Dynamically create formula for shapes VBA

    Hey! Trying get this code to work: shapes.OLEFormat.Object.Formula = namesheet.Cells(names, 10) Error Code says it can't set formula property of rectangle. I am trying to get shapes I created to in another part of macro to dynamically change their textframe when the cell they correspond...
  2. S

    [VBA] Difference between OLEFormat and ControlFormat?

    Oftentimes, I confused myself with OLEFormat and ControlFormat. To clarify my understanding, is that OLEFormat must refer to ActiveX Controls while ControlFormat must refer to Form Controls? Sometimes I notice cross-application of them among ActiveX controls and Form Controls. What is the...
  3. mooseman

    PowerPoint VBA updating embedded object with data from excel not holding the changes

    Office 2016 Pro Plus and Windows 7 I have this code that updates the data in a standard embedded excel object (not a chart) and when the code runs the object shows the change, but if I save the file and then open it,as soon as I double click the object to activate it, the data all disappears. I...

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