Re: Better way for writing IF statement ?
- From: tony h <tony.h.28xb1a_1149501001.6536@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 5 Jun 2006 04:47:31 -0500
If the object is to simplify coding (ie make it less prone to typing
errors) there are several ways of doing this but you have not provided
any wider cntext for the issue so it is difficult to advise.
Options include:
- using select statements
- writing a functions that returns a true/false and does the test
internally
- use a class module in a similar way
I have used all these methods in various circumstances.
regards
--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21074
View this thread: http://www.excelforum.com/showthread.php?threadid=548020
.
- References:
- Re: Better way for writing IF statement ?
- From: macropod
- Re: Better way for writing IF statement ?
- From: tony h
- Re: Better way for writing IF statement ?
- From: macropod
- Re: Better way for writing IF statement ?
- From: Don Guillett
- Re: Better way for writing IF statement ?
- From: monir
- Re: Better way for writing IF statement ?
- Prev by Date: Re: Copy named range from file list to summary workbook
- Next by Date: Re: Adding a tip when the mouse is hovered over a shape in Excel....
- Previous by thread: Re: Better way for writing IF statement ?
- Next by thread: Re: Better way for writing IF statement ?
- Index(es):
Relevant Pages
|