Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 167
Default Incrementing Variable shortcut

In several languanges (C++ and Jave for eg.) there is a short cut method of
incrementing a variable by 1. For instance in C++ if I have a variable var,
I can have var++ instead of var = var + 1.

Is there something similar in VBA or do I have to write it out?

I know, I know...I have issues with laziness, but is there a way?

Mike
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 983
Default Incrementing Variable shortcut

I am with you... It would be nice... But alas it is not to be. There is no
increment operator in VB.

"crazybass2" wrote:

In several languanges (C++ and Jave for eg.) there is a short cut method of
incrementing a variable by 1. For instance in C++ if I have a variable var,
I can have var++ instead of var = var + 1.

Is there something similar in VBA or do I have to write it out?

I know, I know...I have issues with laziness, but is there a way?

Mike

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 167
Default Incrementing Variable shortcut

Thanks for the reply.

"Jim Thomlinson" wrote:

I am with you... It would be nice... But alas it is not to be. There is no
increment operator in VB.

"crazybass2" wrote:

In several languanges (C++ and Jave for eg.) there is a short cut method of
incrementing a variable by 1. For instance in C++ if I have a variable var,
I can have var++ instead of var = var + 1.

Is there something similar in VBA or do I have to write it out?

I know, I know...I have issues with laziness, but is there a way?

Mike

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
shortcut has change or move so this shortcut can not open bakerstreet Excel Worksheet Functions 2 April 2nd 10 01:21 PM
incrementing luuthur Excel Discussion (Misc queries) 4 May 23rd 07 05:07 AM
Variable Incrementing John Excel Discussion (Misc queries) 3 May 12th 06 10:16 PM
Next not incrementing davegb Excel Programming 11 March 19th 05 01:25 PM
Increment variable not incrementing? [email protected] Excel Programming 3 November 19th 04 12:10 AM


All times are GMT +1. The time now is 04:01 AM.

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"