Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
KR KR is offline
external usenet poster
 
Posts: 121
Default operator statements, shorting when reusing one of the statements?

Maybe I'm just on crack, but I could swear that there was syntax allowed
where you could replace:

A = A+1

With something like:

A +=1

I've never used it before, because readability has been a primary focus, but
now I'm in a situation where I'm using long statements, and readability
would actually be improved if I can use a shortened syntax. But I've tested
different options to no avail, and haven't been able to find this anywhere
in the helpfile or old posts (maybe I don't know the correct search terms to
use).

Is a shortened syntax available in Excel? Maybe I'm just remembering
something from lurking in VB or VB.net ng's...

Thanks,
Keith

--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,119
Default operator statements, shorting when reusing one of the statements?

That is C syntax and it would be nice if VB had something similar but alas it
is not to be...
--
HTH...

Jim Thomlinson


"KR" wrote:

Maybe I'm just on crack, but I could swear that there was syntax allowed
where you could replace:

A = A+1

With something like:

A +=1

I've never used it before, because readability has been a primary focus, but
now I'm in a situation where I'm using long statements, and readability
would actually be improved if I can use a shortened syntax. But I've tested
different options to no avail, and haven't been able to find this anywhere
in the helpfile or old posts (maybe I don't know the correct search terms to
use).

Is a shortened syntax available in Excel? Maybe I'm just remembering
something from lurking in VB or VB.net ng's...

Thanks,
Keith

--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF statements dannyboy8 Excel Worksheet Functions 1 May 14th 08 06:53 PM
IF statements dannyboy8 Excel Worksheet Functions 1 May 14th 08 05:10 PM
IF Statements (Mutliple Statements) Deezel Excel Worksheet Functions 3 October 19th 06 06:13 AM
if statements, and statements Sum Limit and marking Excel Worksheet Functions 3 March 29th 06 03:25 PM
If statements paule1982 Excel Discussion (Misc queries) 4 February 18th 06 05:09 PM


All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"