Posted to microsoft.public.excel.programming

nick

external usenet poster

Posts: 192

sheetChange event and list validation

in Worksheet_Change sub-routine, i have certain cells change the interior
pattern whenever the column of the cell is let say 5. the cells in column 5
are list validation. when i change the value through the list it goes into
the code and goes thru the code correctly but the interior pattern did not
change. I am currently using windows XP Pro and office XP Pro. Thank you!

Nick

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Validation Procedure with a worksheet change event	Bhupinder Rayat	Excel Worksheet Functions	2	October 3rd 07 05:18 PM
MS Bug? Data validation list dropdown with Worksheet_Change event	Dan Frederick	Excel Programming	0	April 6th 04 05:35 AM
XLapp and SheetChange	strataguru[_5_]	Excel Programming	1	October 8th 03 04:39 PM
SheetChange event starts before .calculate finished	Stephen Bullen	Excel Programming	5	September 13th 03 01:34 AM
SheetChange event starts before .calculate finished	Dave Peterson[_3_]	Excel Programming	2	September 9th 03 08:49 AM

All times are GMT +1. The time now is 06:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us