icon

  1. J

    Referencing an "icon"

    On the INSERT menu of the Excel ribbon, right under "shapes" you can insert an "icon". Once you've done that, how can you reference the resulting picture via VBA? I tried searching but most of what comes up for "icons" is in relation to conditional formatting.... Thanks!
  2. B

    Gantt Chart Deadlines

    My gantt chart shows a list of tasks and their start date, end date, duration etc., but within the calendar/timeline I would like it to show a marker on the date of the deadline. How can I do this?
  3. Q

    I have forgotten what I did to make this work!

    I have a macro to pull a row of information from a worksheet upon clicking an icon and posting on the sheet with the Icon. Its been a long time since I used this macro and I have forgotten how I made it work. Can someone tell me what is wrong with this macro? It gives me a runtime error of 1004...
  4. B

    Windows API to check if currently selected object is of the outlook data type

    Is there a windows api function to check the data type of the last item focused on or clicked down on (this includes a dragged object) is of the outlook object type? For instance, if you clicked on your desktop icon to drag it highlights to show its been selected and when you select an email in...
  5. T

    Conditionally remove conditional formatting icons? VBA?

    I have columns of ones (for True) that I format with an icon set. I want to see the green dot, not a one. This works well. But I also have a Total line, and that total line isn't static. When a list of data ends, a formula adds "Total" in the next empty cell below. It's at that point that I...
  6. J

    Print Black and White - Don't Hide Icon Set

    I have a spreadsheet and I have conditional formatting on all cells so that if a formula exists in a cell it shades it a gray. this is solely for my benefit when i'm in the workbook. I also have a column that contains conditional formatting to provide a visual cue using icon sets which is for...
  7. J

    Quick Access Tool Bar Self-Changes

    I am a big fan of the Quick Access Tool bar which I have customized to give easy access to my most commonly used functions. I have them grouped logically. For some reason the icons don't stay put. The icon in one location keeps moving elsewhere on the Tool Bar. Occasionally, another icon...
  8. UniMord

    Suppress Sizing Handles on "Packager Shell Object" icon

    When embedding a file as a “Packager Shell Object”, I’d like users to be able to click the icon without the sizing handles displaying. Is there any way to prevent the handles from appearing?
  9. S

    Customize Ribbon on Excel for Mac - Symbol or Icon is Not Available

    I just added a handful of macro buttons to my ribbon (using Excel for Mac) in customizing my ribbon. On the Windows version of Excel, when you create or rename the button being added to the ribbon, a symbol / icon palette appears, allowing you to choose the icon you want to appear above the...
  10. M

    Picture Icon

    Is it possible to have a picture inserted that is roughly the size of an icon in a cell that opens up to a full sized image? I don't want it linked. If I drag and drop a file from an email, it links to the email. I want to be able to open the picture to see it in full size, but not take up...
  11. S

    Cannot insert content of PDF in document

    Hi All, This is actually a problem that is effecting not just Excel but all office. I am trying to embed the content of a PDF into the workbook - I totally understand that I will only get the first page of the document, thats all I want as the PDF is always one page in length. I am using...
  12. C

    Embedded files within excel naming

    In Excel, when I go to Insert/Text/Object/Create from File/Display as icon then Browse and find the file I am wanting to embed. Then go to Change icon and ensure that my Caption box is the exact name of the file I am wanting to embed, then click OK. It successfully embeds the file and shows...
  13. welshgasman

    White is the new Yellow

    Hi all, Posted here on thread https://www.mrexcel.com/forum/excel-questions/1078016-what-am-i-missing-again.html and got to the bottom of that problem. Solved it by using the Round() function. Now my sheet and not even the affected rows does not show values > than a cell value as yellow...
  14. E

    Why a function does not populate across when clicking the + icon?

    Hello, I have a function but when I click the + icon it does not populate across the whole column. Any idea how to fix this please? Thanks
  15. S

    Icon sets

    The icon sets in excel are pretty basic and boring. Is there a way to make your own or upload better looking sets from the internet?:confused:
  16. G

    Icon Sets using text values rather than numerical values

    I want to use Icon Sets for a sales spreadsheet based on the status of the sale. For example when something has been allocated, it is one colour, when it's invoiced and waiting payment it is another colour and then when it is fully paid it's a third colour. Unfortunately I dont' believe the...
  17. L

    embed an object in excel based on user values

    Hi, I have an excel file with embedded pdf object (as an icon) in B1. Is it possible to change the file based on the user values entered in A1 ? For e.g. if user types the name "tony" in A1, it shall show the resume of that person in B1(embedded icon in pdf). If they type again "Greg", it...
  18. M

    Embedding PDF file into a specific cell

    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"...
  19. G

    Conditional Formatting Based On Another Cells Value

    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...
  20. A

    VBA Not Show Icon In Cell Of Conditional Formatted Icon Set

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top