| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Font Color Dialog
I want my macro to open the Font Color Dialog, allow the user to select
a color, and save the color to a variable. Excel 2002. Thanks! James |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get Font Color Dialog
James,
Public MyColor As Integer Sub StorColor() Application.Dialogs(xlDialogFormatFont).Show MyColor = ActiveCell.Font.ColorIndex End Sub Zone wrote: I want my macro to open the Font Color Dialog, allow the user to select a color, and save the color to a variable. Excel 2002. Thanks! James |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get Font Color Dialog
Thanks much!
acampbell wrote: James, Public MyColor As Integer Sub StorColor() Application.Dialogs(xlDialogFormatFont).Show MyColor = ActiveCell.Font.ColorIndex End Sub Zone wrote: I want my macro to open the Font Color Dialog, allow the user to select a color, and save the color to a variable. Excel 2002. Thanks! James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format for font color using font color | Excel Worksheet Functions | |||
| Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
| Check Font or Font color and take action | Excel Programming | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| VBA with Font dialog without use comdlg.ocx | Excel Programming | |||
Hybrid Mode
