LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Changing a variable with a SLIDE-BAR.

I saw something interresting in a spreadsheet of somebody. The spreadsheet
contained a table with a certain value in for instance cell D5.
The contents of cell D5 was used somewhere in the sheet to perform several
calculations.
To create different situations one would change the value in cell D5.
Underneath cell D5 I saw a slide-bar. Putting the mouse over this slidebar
a Hand appeared (like a Macro was assigned to it).
With the Hand I could move the slide left and right and the value in D5
would change with the position of the slide.
The creator of this sheet is not known by the person who used it.

I would like to use this feature in some of my own sheets.
How can I create something like this?

Ricky


 
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
Changing a Formula Variable David Excel Programming 4 June 3rd 05 11:50 AM
Range("C9:V9").Select ==> changing the 9 to a variable B. F. Excel Worksheet Functions 8 May 23rd 05 01:16 PM
Changing a formula using a variable... Albert Jameson Excel Programming 0 October 13th 04 06:45 AM
changing selected label on userform w/ a variable mike k Excel Programming 1 February 19th 04 01:48 AM
Changing a range number to a variable Dave Baker Excel Programming 2 November 1st 03 06:58 AM


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