Roger
asked on
Excel UserForm: seeking a different button face
I have buttons on my UserForm that open and close HELP instructions to the User.
It would great if these open and close HELP buttons had a distinctive and small button face - like the classic info buttons.
I found code that I thought would help (in attached file in UserForm2 - code window) from the URL typed at the top as a comment.
I get a bug at:
Dim oIL(0 To 1) As MSComctlLib.ImageList
I do not have a reference loaded for MSComctlLib.ImageList and cant find one.
My experience with UserForms is mainly with forms drive dynamically with data, and I know nothing about using new button faces.
Can you steer me, with or without ference to the attached.
Thanks
Kelvin
ButtonIDs-to-UserForm-v1.0.xlsm
It would great if these open and close HELP buttons had a distinctive and small button face - like the classic info buttons.
I found code that I thought would help (in attached file in UserForm2 - code window) from the URL typed at the top as a comment.
I get a bug at:
Dim oIL(0 To 1) As MSComctlLib.ImageList
I do not have a reference loaded for MSComctlLib.ImageList and cant find one.
My experience with UserForms is mainly with forms drive dynamically with data, and I know nothing about using new button faces.
Can you steer me, with or without ference to the attached.
Thanks
Kelvin
ButtonIDs-to-UserForm-v1.0.xlsm
Why not just change the Picture property of the button and load the picture you want? You only need an image list if you need to change images at run time
ASKER
Thank you. I've got a home made .ico graphic onto a cmdButton.
How can I acquire graphics files, or references, to display on my cmdButton other images used by MS Office? For example, the i-for-information button (with 'i' on blue circular background).
Kelvin
How can I acquire graphics files, or references, to display on my cmdButton other images used by MS Office? For example, the i-for-information button (with 'i' on blue circular background).
Kelvin
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks for speedy advice. Got me started.
I've attached a workbook that will put the Office icons on a grid. The macro (written by John McLean) runs slowly, so be patient.
On my computer, the blue circle with white i in the middle is in cell BD21
FaceIDsInGrid-Macro.xlsm
On my computer, the blue circle with white i in the middle is in cell BD21
FaceIDsInGrid-Macro.xlsm
ASKER
Thanks, byundt,
I was hoping to find something like that, and its really useful!
This question is closed - but I'd like some general advice about making icon graphics and applying them to ctl buttons.
Can I use the icon thumb nails in the excel cells to make graphics. Do I paste them into ppt, or (I'm learning to use) IcoFX 2 for drawing icons?
I have a fair number of icons to make (for RibbonX as well).
I seek to avoid making beginners' mistakes in handling graphics / know of good practice.
If you can can - perhaps you'd indicate what choice of area you would like to offer, and I will open new question accordingly.
Kelvin
I was hoping to find something like that, and its really useful!
This question is closed - but I'd like some general advice about making icon graphics and applying them to ctl buttons.
Can I use the icon thumb nails in the excel cells to make graphics. Do I paste them into ppt, or (I'm learning to use) IcoFX 2 for drawing icons?
I have a fair number of icons to make (for RibbonX as well).
I seek to avoid making beginners' mistakes in handling graphics / know of good practice.
If you can can - perhaps you'd indicate what choice of area you would like to offer, and I will open new question accordingly.
Kelvin
I am not the right person to give guidance on how to make great icons.
I will say, however, that you can go a long way with a simple word, especially if the users all speak the same language. Unless you are absolutely brilliant in your icon design, most people would be hard-pressed to guess what it means, and only learn the user-interface through frequent use of the product.
Besides my bias towards a well-chosen word, I also encourage the use of Tool-tips--the text that is displayed when the cursor hovers over an icon. The Tool-tip can display a phrase, and so can serve to reassure a user who is trying to discover all the commands.
Brad
I will say, however, that you can go a long way with a simple word, especially if the users all speak the same language. Unless you are absolutely brilliant in your icon design, most people would be hard-pressed to guess what it means, and only learn the user-interface through frequent use of the product.
Besides my bias towards a well-chosen word, I also encourage the use of Tool-tips--the text that is displayed when the cursor hovers over an icon. The Tool-tip can display a phrase, and so can serve to reassure a user who is trying to discover all the commands.
Brad
ASKER
Yes! Point taken and thanks for now.
Kelvin
Kelvin