Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ask user to choose
in column A i have dates
in column B i have BP stock price in column C i have brent crude values in cell j2 , i calculate = slope(b, c )... now if i have data in column D ie the beta exposure , i dont neeed the formula from cell j2... i want to be able to have a product of values of crude dat with the beta exposure ( i mean multiply column c with D )...for each of those dates.... how do i ask the user to choose whether to choose option A( slope ) or B ( data from column D method )... using a macro .... i want the user to be asked whether he has beta values or not . if he says no , then it shud calculate the slope ( b, c ) if yes , then he shud multiply as told above .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allowing user to choose to accept saveas option | Excel Discussion (Misc queries) | |||
How do I report to User A vs User B from shared data table? | Excel Discussion (Misc queries) | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
dropdownlist- I want user to choose a # but can I add definition | Excel Discussion (Misc queries) | |||
Can the user "Choose" the path via a VBA command? | Excel Programming |