Creating a Colored popUpmenu items

maneesh

New Member
Joined
Oct 28, 2002
Messages
5
How do i create a popupmenu in which the items in the menu are in diffrent color

i do know how to create a popupmenu
just let me know how to color each item in it ?

please provide me the VBA code
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Hero-0952

Wizard Deluxe
Joined
Jun 11, 2002
Messages
348
Hello maneesh.

If you are talking about the standard type message boxes, I do not know of any way to change the colors without changing the Appearance settings of your computer Display properties.

You would need to employ a Userform to get a pop-up that you can select the color of.

Once the Userform is inserted in the VBE, you would be able to go to the Properties window to set the Back Color to whatever color you want to have. For a Userform you can also insert a picture as the Userform background color - this allows for many great effects.

If you need help with setting up a Userform just post back here.

Regards,

ViperGTS
This message was edited by ViperGTS on 2002-10-30 04:34
 

Forum statistics

Threads
1,144,050
Messages
5,722,231
Members
422,417
Latest member
Johhny

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top