icon

I have written a macro to allow for embedding a PDF file into an Excel sheet. I want the icon for the file to show up in a certain cell. So far, so good, but I do have some questions. But first, my code: Range("AN5").Select ActiveSheet.OLEObjects.Add(ClassType:="AcroExch.Document.DC"...

Hi, I am trying to have a cell show an icon set based on another cells value. The other cell being a percentage value. I have it working... almost. It turns out that the cell I am placing the icon set in is a Unit Price cell (column) which is looking at a cell elsewhere in the workbook. When...

I am using the code below as part of a set of criteria to setup an Icon Set in a range N3:N200. Is there an option to not show the icon in the cell associated with IconCriteria(3) in the range N3:N200? With .FormatConditions(1) .SetFirstPriority .ReverseOrder = False...

Hi there. I've recently created a workbook for work that contains a dashboard along with other sheets that contain the data that feeds the dashboard. On the dashboard itself, I want to use an icon/image as a button to unhide a specific sheet in the workbook that's hidden, but also have the sheet...

I've been told to add images to a Doughnut chart with Category Name and Percentage for 50 reports. How can I add an image or icon linked to the Category Name? Will it work with icon sets? If so, how can I create my own icon set? Will this work better with a different type of chart? I'm using...

Need help with "Conditional Formatting", specifically while working with Icon Sets. I'm currently using MS Excel for MAC 2016. How can I use icon sets when I have the following: "when value is between 90-100%, Green Arrow "when value is between 89-80%, Amber Arrow "when values is 79% or...

I have been using HTML Maker for a few months now but it has an odd behavior. Every time I close and reopen Excel, the HTLM maker icon disappears from my toolbar. I have un-check, and then re-check HTML Maker from the list of Excel Add-Ins for the icon to re-appear in my toolbar. Is that the...

Hey folks Are you able to customise or create your own icon sets in Excel 2013? Patients not assessed at baseline = 15 Patients not assessed at post intervention = 5 Need the 5 patients to have a green down arrow as in this case it is better. I've googled and searched the forum but can't...

Hi Everyone, Is there a way of adding an icon to run a macro, using vba onto the quick access toolbar, I know you can manually do it, but I wish to add it via VBA if that's possible, I can't find any discussions with any solutions as yet! Thanks for reading :)

In cell A1 I have the number 100 and in cell B1 I have the Green, Yellow, Red icon set so that: - if the value of cell B1 is greater than A1 the dot is green - if the value of cell B1 is equal to A1 the dot is yellow - if the value of cell B1 is less than A1 the dot is red Applies to = $B$1...

I could really use your assistance. I am creating a inventory sheet with minimum and maximum amounts for each part. Is it possible to apply an Excel icon set based on the sum/difference of another cells formula =IMSUB(E2,F2)? E2 would be starting stock, F2 would be number of stock used, G2 then...

Hi, is it possible to create conditional formatting of icon set as an indicator of task status, i.e. if an action is "in progress", i want to show a yellow circle icon next to "in progress", if an action is "completed", i want to show a green circle icon next to it. The icon set currently in...

Is it possible to have an listview column show an image (or icon) in certain rows ? if yes, is there an example? I can't find anything on this. Playing around I find switching to either icon view upsets text/layout of the other columns. Must you have either icons or text, not both ?

We have a template we use for action plan overviews, currently with a "progress column", which is set up display the default 5 quarters icon set. 0: Project not started, empty circle 1: Project started, 1 quarter 2: Project Under Development, 2 quarters 3: Project Testing, 3 quarters 4...

I'm trying to use Icon Sets to indicate the 'Age' of the last update made to the file but only want to display this 'Aging' icon when the Status IS NOT certain text values. Here's some sample data: a b c 1 Date Updated Status Icon 2...

I'm am looking for something that I thought would be relatively easy. This is proving to not be the case for the amount of knowledge in VBA I have obtained. I would like a Plus and Minus icon on a spreadsheet and use these to increase/decrease a specific columns width. The key is I want to...

https://app.box.com/s/m8shnmf18zbawqej3gbx0xms9z00neif How do I get the drop-down icon in the Accounts column to be present all the way down the column and not have to keep dragging it down? I don't know how I got in this situation, like why the icon isn't in the cells where I've added the...

Hi, Pretty new to VBA, anything I've learnt so far has come from threads on this page - it's amazing! Needing some help that I haven't seen an answer for so far I need to add a button to a workbook which will allow the user to add a file (this will vary in extension and file name) I also need...

Hi - How to use Icon Sets for NewPrice column to reflect Icon Style : 3 Arrows (colored) with reference to CurrentPrice ? In the below, I need to reflect the ICONSETS in New Price along with the value. Please help me on that. <tbody> Current Price New Price 50 42 42 42 42 50 80 38...

Hi, Trying to figure out a formula for conditional formatting icon sets (directional Up, Down, =) based on another cell reference. Data is in Column B that I want icon set arrows. If whats in column B > whats in Column A, Up Arrow. If =, then =, if column B<column A, down arrow. Please...