Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default using a scroll bar to make a slide show

I'd like to be able to link a series of pictures to a scroll bar. For
example, if I had a set of pictures of say, Kieth Richards or Michael
Jackson, I'd like to embed them or otherwise link them to a scroll bar
so that I might scroll through time and watch them age. I've tried
embedding a pic into a chart and other objects, but I can't seem to
figure out how to link these objects to the scroll bar. Is there a way
to embed a pic in a cell? or perhaps some other way to do this?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 226
Default using a scroll bar to make a slide show

Hi Fastdaddy

You could do this quite easily with a userform although this may not
be the option you are look for. Add a userform and then set the
following properties:

"ScrollBars" = "1 - fmScrollBarsHorizontal"
"ScrollWidth" = 1000 or however wide you need the form

Then in the code module of the userform add the following code

Private Sub ScrollBar1_Change()

UserForm1.ScrollLeft = ScrollBar1.Value

End Sub

I hope this is of some use to you

Steve
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
Unable to scroll in excel using mouse wheel or right slide keninmilwaukee Excel Discussion (Misc queries) 1 July 26th 09 02:38 AM
want to make a slide show in excel Suleman[_2_] Excel Discussion (Misc queries) 5 June 8th 08 08:59 PM
Slide show Suleman[_2_] Excel Discussion (Misc queries) 2 May 6th 08 06:34 PM
slide show Suleman[_2_] Setting up and Configuration of Excel 1 May 5th 08 10:30 PM
Can I make the scroll bar show the row number? Marcia Duckworth Excel Discussion (Misc queries) 11 June 20th 07 08:33 PM


All times are GMT +1. The time now is 06:46 PM.

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"