Can flash be an appropriate user interface for excel macro ?

[Lokesh_g]

Hi all

I have constructed a simple macro in VBA, which based on answers to certain questions, maps a particular user to one out of four pre-defined scenarios. I am looking for an appropriate user interface for this macro.In short, I would like users to enter answers to questions on a GUI rather than to the worksheet.

Can I use Flash for the same? If I can, what subject/function of Flash should I look up for reading? (P.S I have not programmed on Flash).

I did look up on threads relating to the same in this forum. But I was unable to find a relevant match. In case I have missed out, any pointers to the prev. thread would also be of great help.

Thanks in Advance
Lokesh

[MarMo]

Lokesh,
Why not use the build in VBA userforms ?

[Lokesh_g]

Lokesh,
Why not use the build in VBA userforms ?

Thanks for the suggestion MarMo.

I tried the userforms. Works good logic-wise. But my only concern is that the interface is less engaging than a flash/rich interface. MarMo and all, Any suggestions on improving the VB forms' richness?

Thanks...Lokesh

[teylyn]

Erhhmm..... is there any reason you want to distract the user from the task of simple data entry by masking it in an eye-candy interface that adds nothing to the situation than "visual noise"? Look at a Google interface. Look at an Apple interface. Reduce, reduce, reduce.

[Delaselva]

Hello ... I'm george...
I have spent a lot of time trying to make a flash based menu for an excel application. i'd like to share what I have found out an the problem I have faced.

I made a flash picture carousel in flash using pre-made templates i found at internet
I embeded the flash carousel in excel as an swf shockwaveflash object, an it works fine .. When you use the mouse the Carousel rotates the pictures with excelentt effects.
Suposse i selectes the second picture in the carousel .. Then select the design mode in excel programmers tab. Selected the swf an right-click to the properties window. The FRAMENUM property value displays the number 2 ... If I select another picture supose picture number 13 ... An reopen the properties window it shows 13 for the framenum position.

That means that excel knows the position of the swf .... If i could be able to retrieve the value of the FRAMENUM to a cell I will be able to control my worksheet using a simple. INDEX function.

To put it in the simplest way Supose you have a product catalog an you have 5 product pictures .. If you select any picture in the carousel then any excel cell could show you the price an any other information about that product.... This could be some way to make a visual menu ..... BUT I DONT KNOW HOW TO RETRIEVE THE VALUE OF THE PROPERTY TO A CELL IN REAL TIME. ... I have search at internet for months an it seems nobody but you is interested in making a rich visual application in excel..... If you could help me please write me to my email. removed by Admin. Or removed by Admin

Thanks in advance

I have constructed a simple macro in VBA, which based on answers to certain questions, maps a particular user to one out of four pre-defined scenarios. I am looking for an appropriate user interface for this macro.In short, I would like users to enter answers to questions on a GUI rather than to the worksheet.

Can I use Flash for the same? If I can, what subject/function of Flash should I look up for reading? (P.S I have not programmed on Flash).

I did look up on threads relating to the same in this forum. But I was unable to find a relevant match. In case I have missed out, any pointers to the prev. thread would also be of great help.

Thanks in Advance
Lokesh[/QUOTE]

[mikerickson]

To reiterate what was said when this thread was fresh.
Using Excel's built in userforms would be an easier interface than using flash.
To use the product catalog example, Image controls could show the product, their Click event could show their info.

Someone with more Flash experience than I might be able to use Excel controls to control a Flash player to show Flash images, but having the user manipulate Excel's controls, rather than Flash controls, would be the recommended way to get their response.

[teylyn]

To add to mikerickson's post:

re

If you could help me please write me to my email. [email protected]. Or [email protected]

This is a public forum. Taking a discussion offline is counterproductive to discussing solutions for everybody's benefit.

Also, you may want to remove your email address from the post, unless you really, really need more spam in your inbox.

And finally:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.