$$Excel-Macros$$ IF statement logic

2010-01-28 Thread capt edgar
Hi there I have attached a simple spreadsheet with a table in it All the cells except the headers in the tables are conditional formatted so that if i select a cell in the table as No, the colour of the cell turns red if i select Yes, the cell color turns green and if i select NA, the cell color t

$$Excel-Macros$$ Dependent Lists

2010-01-11 Thread capt edgar
Hi there I have attached a small excel sheet called TESTTHEM which i'm testing and learning excel simultaneously. On the attached sheet under the type column, i have created a dropdown list with some values in it. If i select a value from the dropdown list say for ex: Pictures, is it possible to

$$Excel-Macros$$ Event Difference

2010-01-06 Thread capt edgar
Hi there Can u please tell me what is the difference between worksheet_change and worksheetselection_change events please? I can't find a proper definition for it on google anywhere. Also can u tell me a good place for code snippets for vba for quick use in vba programming regards -- -