| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to test cell contents in a macro?
I'm using MS Excel 2000, and I want to write a macro that tests cell contents. Unfortunately, after a couple hours of looking at help files (MS Visual Basic 6.0), I have found no method to do so. My code concept is If Cellcontents(activecell) = "dog" then DoSomething EndIf This used to be so easy in Lotus 1-2-3...haha, way back in the pre-Win95 era! Can someone point me on the right track? -- JennyGard ------------------------------------------------------------------------ JennyGard's Profile: http://www.excelforum.com/member.php...o&userid=31803 View this thread: http://www.excelforum.com/showthread...hreadid=515272 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to transfer contents of 'Selected' cell to alternate cell. | Excel Worksheet Functions | |||
| Is there a logical test for a cell's format instead of contents | Excel Worksheet Functions | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| Test is cell contents are a URL | Excel Programming | |||
| Please help! Macro to change cell contents based on cell to the left | Excel Programming | |||
Threaded Mode
