Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 192
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default sheetChange event and list validation


Hi Nick,

Please supply your code so that people may give you the correc
response or solve your problem.

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=27098

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"