Hi All
I have started a new thread as the requirements have changed. Can anyone please assist in the simplification of the below code. It is the saving and re-call of a userform containing check boxes.
Please Login or Register to view this content.Please Login or Register to view this content.
How's this for starters?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Nope, right over my head.....
bakerman2....don't understand that at all.
It works very well but have never seen it before. Perhaps a link to broaden my mind lol
Returns one of two parts, depending on the evaluation of an expression.
You can use IIf anywhere you can use expressions. You use IIf to determine if another expression is true or false. If the expression is true, IIf returns one value; if it is false, IIf returns another. You specify the values IIf returns.
See some examples
Syntax
IIf ( expr , truepart , falsepart )
The IIf function syntax has these arguments:
Argument
Description
expr
Required. Expression you want to evaluate.
truepart
Required. Value or expression returned if expr is True.
falsepart
Required. Value or expression returned if expr is False.
Remarks
IIf always evaluates both truepart and falsepart, even though it returns only one of them. Because of this, you should watch for undesirable side effects. For example, if evaluating falsepart results in a division by zero error, an error occurs even if expr is True.
Wow, that is new to me. Thanks bakerman2 for your assistance and tutorial.
Don't suppose the IIf could work for the Userform_Initializing code
Hi All
For those of you who have never seen this before....like me
Found following link using IIf
https://support.office.com/en-us/art...0-647539c764e3
different approach using loops and old standard if
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks humdingaling
That works like a charm.
You're welcome and thanks for adding rep points.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks