ask user to choose

S

Sam

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 ..
---------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ask user to choose 0
Relevant user should see only his data 0
Macro storing as a date? 11
Slope from a range of cells 1
modified date of the file 3
How to get a value from 1 table to a 2nd. 15
Date Stamp by User and cell value 8
Need to create an excel template with many dependencies between columns and some prog 0

Top