icon

Hi forum, Workbook Example I have been playing around with this little vba project and thought I would post it here. Basically, the code creates a full menu system for (MODAL) userforms (up to 10 entries per menu) based on a table in a worksheet. PREVIEW The menus are indexed in the...

Hi, For a static icon, sending the WM_SETICON to the UserForm window is the standard way and it is straightforward. However, for an animated icon, we would need to use multiple images\frames and periodically alternate them in a timer procedure or in a loop. This can become quite tedious and has...

Hi, I have a commandbutton on a userform and I want place on it an icon and a descriptive text below it. Based on a couple of testings, I managed to add an icon to the commandbutton without obscuring the caption text BUT it only works if the icon is very small (16x16) which results in a...

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!

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?

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

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

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

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

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

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?

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

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

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

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

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

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

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:

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

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