shape button

  1. M

    Change the text of shapes automatically

    Hi Everyone, these shapes below I make it as a button for changing data when press on it, my question is I need to change the text color of shape once press one of them (using a macro), also when press to another shapes the color followed and be the other as the same original color.
  2. A

    If statment when a image is clicked

    Hello guys. Im new to Excel VBA and i need help with a problem im trying to solve. I have 2 shapes and when i click the shapes the same userform appears. The value that are typed in the userform is gonna be placed in a different cell wich depends on what shape is clicked. The code i have...
  3. H

    Adding shapes to denote milestones based on cell reference?

    Hi all, I have created a large Gantt chart in excel (through formulas, not as a chart). I have 2 additions I am trying to make to my sheet in order for it to be functional: Adding in a date line for today - a red, bold border line that lines up with today's date Adding in a shape (5-point...
  4. K

    Read what's in the shape

    What I basically want is a line of code that can read what's in a shape. So if I click on a shape with a macro assigned to it, that macro reads which text is in the shape so it can look for it in a list and get the other information. So what I need is some code (as short as possible) that reads...
  5. S

    Delete a shape using a macro

    Hello, I have a shape with instructions to enable macros when opening an excel document. Once users have enabled the macros I would like them to select a shape with a macro assigned to it that says "complete" and it will delete the instructions and the "complete button/shape." I tried...

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