#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 266
Default Push Down Stack ?

Does VBA have a "push down/ pop up " stack ? Thanks for any help on this.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default Push Down Stack ?

Not like you're thinking about; that is not one that you can "push" and "pop"
from as in assembly language. It does have internal stack space that the VB
engine uses, but you can't access that directly.

You could probably simulate a stack with a dynamic (or even static) array.
If you'd explain a little more about what you are trying to do or want to do,
then we might be able to offer some better suggestions.

"dhstein" wrote:

Does VBA have a "push down/ pop up " stack ? Thanks for any help on this.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 266
Default Push Down Stack ?

Thanks. I'll probably just simulate it - keep track of the level of the
stack with a pointer and push and pop accordingly. I'm showing a progress
meter for several applications. The applications can be called directly or
can be called from an application that is already showing the progress meter
- so I need to keep track of which application's progress is being displayed
and the percent complete and I thought a push and pop type of stack would
work well.

David


"JLatham" wrote:

Not like you're thinking about; that is not one that you can "push" and "pop"
from as in assembly language. It does have internal stack space that the VB
engine uses, but you can't access that directly.

You could probably simulate a stack with a dynamic (or even static) array.
If you'd explain a little more about what you are trying to do or want to do,
then we might be able to offer some better suggestions.

"dhstein" wrote:

Does VBA have a "push down/ pop up " stack ? Thanks for any help on this.


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default Push Down Stack ?

Sounds like you have a handle on it all.

"dhstein" wrote:

Thanks. I'll probably just simulate it - keep track of the level of the
stack with a pointer and push and pop accordingly. I'm showing a progress
meter for several applications. The applications can be called directly or
can be called from an application that is already showing the progress meter
- so I need to keep track of which application's progress is being displayed
and the percent complete and I thought a push and pop type of stack would
work well.

David


"JLatham" wrote:

Not like you're thinking about; that is not one that you can "push" and "pop"
from as in assembly language. It does have internal stack space that the VB
engine uses, but you can't access that directly.

You could probably simulate a stack with a dynamic (or even static) array.
If you'd explain a little more about what you are trying to do or want to do,
then we might be able to offer some better suggestions.

"dhstein" wrote:

Does VBA have a "push down/ pop up " stack ? Thanks for any help on this.


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
push result from one cell to another Neall Excel Worksheet Functions 2 May 6th 09 03:42 PM
Time with the push of one button Dale G[_2_] New Users to Excel 7 August 6th 08 01:55 PM
Push updates from one workbook to others? ChrisP Excel Worksheet Functions 1 July 11th 08 05:25 PM
how to push data to another cell Wawa Excel Worksheet Functions 1 May 31st 07 05:49 PM
Push/Pull for Pop3 tshad Excel Discussion (Misc queries) 2 February 6th 07 10:04 PM


All times are GMT +1. The time now is 06:12 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"