PC Review


Reply
Thread Tools Rate Thread

Conditional Expressions for VBA

 
 
thread
Guest
Posts: n/a
 
      7th Nov 2007
Hi all,
i'm trying to find expression like we have in C for example
x = (y==9) ? 10 : 5
is there another solution beside using if else and variable?

 
Reply With Quote
 
 
 
 
Pieter Wijnen
Guest
Posts: n/a
 
      7th Nov 2007
IIf is your friend

x=IIf(y=9,10,5)

Pieter

"thread" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all,
> i'm trying to find expression like we have in C for example
> x = (y==9) ? 10 : 5
> is there another solution beside using if else and variable?
>



 
Reply With Quote
 
thread
Guest
Posts: n/a
 
      8th Nov 2007
thank you man it was very helpfull
On 7 , 16:03, "Pieter Wijnen"
<it.isi.llegal.to.send.unsollicited.mail.wijnen.nospam.ple...@online.replace.with.norway>
wrote:
> IIf is your friend
>
> x=IIf(y=9,10,5)
>
> Pieter
>
> "thread" <yaniv...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > Hi all,
> > i'm trying to find expression like we have in C for example
> > x = (y==9) ? 10 : 5
> > is there another solution beside using if else and variable?- -

>
> - -



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Expressions Reese Microsoft Access Reports 10 31st Oct 2008 02:50 PM
Calculated Conditional Expressions Caburky Microsoft Access Queries 1 8th Dec 2007 12:03 AM
help with conditional expressions or calculations =?Utf-8?B?U29jYWwgQW5hbHlzdCBsb29raW5nIGZvciBoZWxw Microsoft Access Queries 1 19th Apr 2006 02:09 AM
? and : for conditional expressions in v2 Mark Rae Microsoft C# .NET 14 30th Jan 2006 10:37 PM
Joining Conditional Expressions =?Utf-8?B?U29rYW4zMw==?= Microsoft Access 6 7th Aug 2005 08:15 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:33 AM.