Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scroll bar
Can I add scroll bar to a worksheet and links it to a list of data. If I
have two cells A1 ( amount ) and B1 ( rate ). I want to calculate the product in C1, =A1*B1. In A1, I will put the amount. I want a scroll bar connected to B1 with a list of rates that I can move up & down. The product ( C1 ) will change while I am moving the scroll bar. Is it possible ???? Thank you Mustafa Al-Khars |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scroll bar
Hi
You could add a Data Validation to cell B1 which would show a list of values, but until you had selected the value, the entry in C1 would not reflect the change. -- Regards Roger Govier "MJK700i" wrote in message ... Can I add scroll bar to a worksheet and links it to a list of data. If I have two cells A1 ( amount ) and B1 ( rate ). I want to calculate the product in C1, =A1*B1. In A1, I will put the amount. I want a scroll bar connected to B1 with a list of rates that I can move up & down. The product ( C1 ) will change while I am moving the scroll bar. Is it possible ???? Thank you Mustafa Al-Khars |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scroll bar
Or, you could use a spinner control. Right-click on the toolbar and select
Control Toolbox. Click on the spinner control, then click where you want it on the screen. Right-click on the spinner, select View Code, and paste this code in there. Not exactly a scrollbar, but it will continue to spin when you select up or down, as long as you keep the mouse button down. HTH, James Private Sub SpinButton1_SpinUp() If [b1] < 1 Then [b1] = [b1] + 0.01 Else [b1] = 0 End If End Sub Private Sub SpinButton1_SpinDown() If [b1] 0 Then [b1] = [b1] - 0.01 Else [b1] = 1 End If End Sub "Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message ... Hi You could add a Data Validation to cell B1 which would show a list of values, but until you had selected the value, the entry in C1 would not reflect the change. -- Regards Roger Govier "MJK700i" wrote in message ... Can I add scroll bar to a worksheet and links it to a list of data. If I have two cells A1 ( amount ) and B1 ( rate ). I want to calculate the product in C1, =A1*B1. In A1, I will put the amount. I want a scroll bar connected to B1 with a list of rates that I can move up & down. The product ( C1 ) will change while I am moving the scroll bar. Is it possible ???? Thank you Mustafa Al-Khars |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll bar (control) doesn't scroll!! ??? | Excel Worksheet Functions | |||
Scroll bar control doesn't scroll !! ??? | Setting up and Configuration of Excel | |||
adding scroll bar to scroll on cell's content? | Charts and Charting in Excel | |||
Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
Scroll the screen view with the scroll bar | Excel Discussion (Misc queries) |