| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting color number to use in vba code.
I use code to fills in cells for the color red - the number for red is 3.
Thus the selected line in the code reads : ..Interior.ColorIndex = 3 I would like the user to be able to define the color themselves in the spreadheet with a dropdown list. Is there a way to transpose the code number for the chosen color to the vba code macro? Can anyone help? Thanks, Roger |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting cells of a specific color only. | Excel Discussion (Misc queries) | |||
| Selecting no color for a graphed series | Charts and Charting in Excel | |||
| How to color automatically color code sums in cells | Charts and Charting in Excel | |||
| Selecting Background Color? | Excel Programming | |||
| Selecting cells by color? | Excel Programming | |||
Threaded Mode
