Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Using flowchart in simulation

Thanks for your reply. I used the "OnAction" property of the shape and with
Application.Caller I can decide what shape beeing clicked.

"Chip Pearson" wrote:

You can assign a macro to a Shape object so that the macro will be
executed when a shape is clicked. Within that macro,
Application.Caller will be a string containing the name of the shape
that was clicked. Therefore, you could assign the same macro to all
shapes, use Application.Caller to determine which was clicked, and
then take the appropriate action. E.g.,


Sub ShapeWasClicked()
Select Case Application.Caller
Case "Rectangle1"
' do something
Case "Oval3"
' do something else
'....
End Select
End Sub

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 17 Mar 2009 08:41:07 -0700, Tomas Nikolarsen <Tomas
wrote:

I want to create a simple simulator with a graphical user interface using
flowcharts. My main problem is that shape objects do not create events. Does
anyone have any suggestion how I can do this?

I´m planning to program in VBA. The program I want to write is inspired by
this screenshot:
http://www.freedownloadscenter.com/B...creenshot.html


Thanks for ideas!


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
flowchart printing problems chainman Excel Discussion (Misc queries) 0 April 30th 09 06:33 PM
Add in Flowchart symbols Mike Excel Discussion (Misc queries) 1 August 22nd 08 07:22 PM
Excel table to a flowchart Generating flowcharts from Excel Excel Discussion (Misc queries) 3 December 1st 06 08:56 PM
How do i create an interactive flowchart Reuben Excel Discussion (Misc queries) 0 August 8th 05 10:41 PM
flowchart bb Excel Discussion (Misc queries) 2 March 14th 05 03:19 PM


All times are GMT +1. The time now is 08:51 AM.

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

About Us

"It's about Microsoft Excel"