| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: how to... cell properties has to change based on a condition
Hi Everyone, i'm new to this forum and i have a question for you reguardin excel VBA. I want to declare in a module a function or sub that wil change the CELL properties where the function has been called from i another cell contains certain information...example: A B C D 1 100 5.5 =ONOFFCell(A1) 2 0.5 2 =ONOFFCEll(A2) 3 . 4 . the ONOFFCELL (sub or function) must DISABLE ITSELF (CELL C1) so tha people cannot enter anything in C1 cell IF the cell A1 value let say i bigger than "0". Then on each line i will have to repeat the sam function etc. etc. How can i do that? Can someone help me ? Thank you! William -- will9 ----------------------------------------------------------------------- will99's Profile: http://www.excelforum.com/member.php...fo&userid=2679 View this thread: http://www.excelforum.com/showthread.php?threadid=40041 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change line chart color based on condition like + and -. | Charts and Charting in Excel | |||
| Change row color based on condition of celss | Excel Worksheet Functions | |||
| Change cell format based on condition. | Excel Programming | |||
| Color Change in chart based of condition | Charts and Charting in Excel | |||
| How do i change the format of a cell based on the condition of another cell in same row? | Excel Programming | |||
Threaded Mode
