Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB MACRO ?
i want to make a button to highlight / color a range but
when i create the macro on one cell will color in... here is the code .... Sub Button1_Click() ' ' Button1_Click Macro ' Macro recorded 6/23/2004 by New User ' ' Range("E3").Select With Selection.Interior .ColorIndex = 12 .Pattern = xlSolid End With End SubSub Button1_Click() ' I am assuming where it states Range("e3").select is the cell to highlight/ color but how can i change this to be random or be aable to highlight more than one cell Thanks in advance David ' |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB MACRO ?
David
just delete the line "Range("E3").Select" Regards Trevor "David ulrich" wrote in message ... i want to make a button to highlight / color a range but when i create the macro on one cell will color in... here is the code .... Sub Button1_Click() ' ' Button1_Click Macro ' Macro recorded 6/23/2004 by New User ' ' Range("E3").Select With Selection.Interior .ColorIndex = 12 .Pattern = xlSolid End With End SubSub Button1_Click() ' I am assuming where it states Range("e3").select is the cell to highlight/ color but how can i change this to be random or be aable to highlight more than one cell Thanks in advance David ' |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |