smartart

  1. L

    VBA Populating SmartArt and demoting nodes

    Hi all! Have to start with a big thank you! I have learnt so much from this forum and wish to contribute in some way in the future! I have been lurking far to long with out creating an account. To the problem at hand: I'm building a tool to follow up activities/tasks I have a table (tabell1)...
  2. G

    SmartArt Hierachy - Multiple "Titles" Possible?

    I've been building up an organizational chart for where I work using the Excel SmartArt. Currently I'm using the Name and Title template. I was wondering if it is possible to somehow add additional titles to all the boxes. Below is a quick example similar to what I currently have built up. I'm...
  3. O

    Extract smartart node text on object click

    Hello! I would like to show a message box with the text of each node clicked on my smartart. I would like to return the node text and not the main object text. I tried using Application.Caller and it didn't work Help would be much appreciated! :)
  4. C

    Icons detached from SmartArt, work-around?

    Hi, I have formed a process using SmartArt and would like to add icons to the chart area, which works fine! But, when copying or marking in order to move or resize, icons are not following. Is there any work arounds on this issue?
  5. P

    Exporting a SmartArt graphic

    I dynamically generate Org Charts using the SmartArt CirclePictureHierarchy object, but I am unable to export them as PDF files in code. I thought I could use the same code as I use to export a Chart, but that didn't work. I believe exporting Shapes is doable, but I can't capture the code in a...
  6. K

    SmartArt Formulas

    I have a dashboard that I am trying to make nicer than just cell sized boxes. Is there anyway I can add formulas to SmartArt? I am using excel 2013
  7. D

    Excel VBA SmartArt Colours

    Hi all, I've managed to write some code that converts a list of people (with column headings: Name, Title, No of People, Manager) into a hierarchy SmartArt object. The code also formats each of the nodes (the forecolor, the box outline and the text color). The issue is that there are lines that...
  8. S

    Code for adding hyperlinks to smartarts

    Hi, I have generated a code to automatically fill up a Smartart with data from some cells. The remaining point is how to add also hyperlink to the smartart nodes. This can be done in excel by right clicking. But I want to this to be also automatic. The cells from which the data is generated do...
  9. A

    Inserting a picture into shape quickly

    I am working with Excel for Mac 2011. In the SmartArt section they have a picture tab, where you can select from various formats. None of these formats fit my needs. So my question is, can I customize these? If not, can I add a macro to a shape so that it can do what the picture boxes do...
  10. A

    Inserting a Picture into Shape Quickly

    I am working with Excel for Mac 2011. In the SmartArt section they have a picture tab, where you can select from various formats. None of these formats fit my needs. So my question is, can I customize these? If not, can I add a macro to a shape so that it can do what the picture boxes do...
  11. S

    Running Private Sub

    Hi Experts, After checking the forum I found what appears to be perfect for my needs but not able to get this VBA private sub to run (or it's simply not doing anything that I can see). I have taken the code from this post (I'm using Excel 2010), My set-up is as follows, Open new Excel...
  12. T

    Smart Art Org Charts Linked to Dynamic Pivot Table

    Hi All, Does anyone know of a way to dynamically link Smart Art (especially hierarchy charts like an org chart) to a Pivot Table? If not a Pivot Table then just a normal set of data in a worksheet, so when the data changes the Smart Art changes accordingly. Many Thanks Don Johannesburg

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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
Top