| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Visual BASIC in Excel
hi,
I would put the code in the worksheet change event. Cells(1,1).interior.colorindex = 40 or range("A1").interior.colorindex = 40 see this site for excel color indexes. http://www.mvps.org/dmcritchie/excel/colors.htm regards FSt1 "Emerogork via OfficeKB.com" wrote: I can write the code but wonder where to place it and how to activate it in a spread sheet. I hope to run the code when the value in a cell changes. How do I control the cell background color in VB code? Specifically, I wish to change from grey to crosshatch when someone clicks on the cell. (Maybe there is a better way without using VB?) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200708/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Programming for Excel | New Users to Excel | |||
| changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
| Excel and Visual Basic | Excel Discussion (Misc queries) | |||
| visual basic in excel - | Excel Discussion (Misc queries) | |||
| Formula in Visual Basic For Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
