Giving VBA UserForm task bar icon

[DPashley]

I am trying to give my Excel UserForm application a task bar icon as on load it hides the Excel workbook which make the form(s) easy to lose behind other windows. I have a .png or an .ico file which I would like to use as the icon. The image can either be just in the folder with the Excel file but if it could be embedded some way into the workbook that would be preferable.

Thanks for any help!

[xlnitwit]

Hi,

There are many examples of code for this scattered throughout the internet. Have you tried any of them? For example this- http://stackoverflow.com/questions/2...in-the-taskbar

[DPashley]

Hi,

I have tried several but to no avail. They generally seem to show some code with no explanation of what they are doing which makes it hard to adapt to my implementation, nor can I see how to change the icon used to be a custom one. Hence why I am trying to find someone who can explain a solution for me

[xlnitwit]

Add a new class module and name it UserformHandler. Next, add the following code to the class module

Please Login or Register  to view this content.

Finally, in any userform you will then require code like this

Please Login or Register  to view this content.

You must use a valid icon format file for this to work properly.

[DPashley]

Thanks for the response!

I am a bit unsure what you mean by "specify your image control here instead of Image1"?

Sorry for the level of noob...

[xlnitwit]

You need to have a picture loaded somewhere. Usually it would be in an image control on the form itself, in which case you merely need to use the relevant control name in that line rather than the default Image1.

[DPashley]

Right. I have it working now with an .ico file and the forms icon is changed but the task bar icon is still the Excel icon. Is this code meant to change that too? Or have I missed something?

[xlnitwit]

The code doesn't change the taskbar icon in Windows 7 or later, I don't believe, since that is the program icon, not the window icon. It will show the form as a preview window when you hover over the taskbar icon.

[DPashley]

That's fine then. Thanks for all your help!

[Sajiko]

Add a new class module and name it UserformHandler. Next, add the following code to the class module

Please Login or Register  to view this content.

Finally, in any userform you will then require code like this

Please Login or Register  to view this content.

You must use a valid icon format file for this to work properly.

With this one, is it possible to disable the close or "x" with the minimize button? just to ensure they click a separate exit button that will also exit the application and not just the userform. Unless there is a way to code the close button to exit Excel and open up that window instead?

[bakerman2]

Sajiko,

Welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.