projection for auctions

  • Thread starter Thread starter Sandoz
  • Start date Start date
S

Sandoz

I know someone who gives auctions and want to use powerpoint to
project a picture of what he is selling on a big screen.
The problem is that also the sum of what is currently offered for the
object must be on the big screen above the photo, and that this must
be changed quickly. I have found everything make to work but the
normal method is way to slow to use in an auction. So I think I have
to create a macro.
Has anyone some idea of how I can create for example a popup with 2
parameters than can be changed : the dia number that has to be
projected and the offered sum, so that all this is can be directly
excecuted.
For the info : He's working with 2 screens and a projection screen
with dual monitor ability.
Any help would be much appreciated!
 
A simple solution, provided you have a dedicated graphics person and a
graphics card with dual monitor (often called extended desktop) capability.
Add a text box at the top of the slide that says something like "Bid: $"
With the computer in edit mode, select the text box and simply type in the
current bid - as it is typed it will show up on the showmode (projector)
screen. As a new bid is given the graphics/computer person deletes the
number and updates. To the audience it appears seamlessly.

If you have set/common bid amounts you could use Chirag's ShortCut Manager
(http://officerone.tripod.com/ppsctmgr/ppsctmgr.html) to input the amounts
even faster.
--
Best Regards,
Troy Chollar
==============================
TLC Creative Services
www.tlccreative.com
(e-mail address removed)
==============================
 
You could use a little VBA to adjust the number in a text box.
Dual screen not required for this, just PowerPoint.

How high is he willing to go? (vbg)

Something like this ...
5 'number' boxes
over each, two clear borderless boxes
the box covering the top will raise the number in that box by 1
the box covering the bottom will lower the number by one.

You could add additional VBA that would allow for rolling over from 9 to 0
and some other housekeeping stuff.

Do I hear a bid?
B
--
===============
Please spend a few minutes checking out www.pptfaq.com This link will
answer most of our questions, before you think to ask them.

Change org to com to defuse anti-spam, ant-virus, anti-nuisance
misdirection.
 
I've created 2 buttons with the macro's where they can jump to the
slide he wants and one button to change the number of the current bid.
It's a pitty no shortcuts can be added standard to powerpoint.. I will
give shortcut manager a try because shortcuts will be needed to access
quickly some macro's.
The trick with the number boxes will not look professional enough..
The only thing people may see is a picture of what is been sold, it's
number and one variable : the money that has been offered for it. When
I change the money in the edit view, the problem is when changing the
slide on the monitor who shows edit view, the slide is not changed on
presentation monitor and projection screen + you can use the function
of just typing the slide number and enter to jump to another slide in
the edit monitor.
This would all be to frustrating for the guy who has to type the bids
and to jump to the slides (it isn't alway the next slide he has to
choose).. Everything is going 2 nervous around there, so no mistakes
or confusion can be made.

Thanks for the help!
 
What about a VBA sub routine with the following goals ...

While displaying an item for bid...
.... if a number entered, display that number as the bid.
.... if the letter "G" is typed, the words "Going" appear separately.
.... if the letter "S" is typed, the words "Sold" appears separately.
.... if the word "Exit" is typed then presentation shuts down.
.... if the letter "I" with a number is typed, the display changes to the
item number entered.

This is a simple case of a repeating 'input box' loop. Then I'd add a
'select case' routine. The input box can be made to appear only on the
laptop, and the changes to the slide on both the projector and laptop. It
you wanted, it could even export an excel table of the item number, name,
bid and time.

B
"You don't know the power of the dark side ..."
 
Back
Top