Naresh Patel
asked on
Statistic
Hi Experts,
|
I have macro which populate low point s from the chart or from column J. I need little modification in that. I need it populated Low as well as high point & to its next column it populate its point number in Graph. like this Stat-2.xlsm
|
I have macro which populate low point s from the chart or from column J. I need little modification in that. I need it populated Low as well as high point & to its next column it populate its point number in Graph. like this Stat-2.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I change name of button from "Get Extreeme Points" to "Get Extreme Points". I had tried right click but I cant.
Thanks
Thanks
No it is VBA not a formula. Do you want it as a formula ?
to change the description of the button.
1) Developper tab
2) Press on Triangle to go design mode
3) right click on the button and choose Properties
4) Change Caption to what you want
5) exit properties by clicking on the X
6) Press on design so you activate macros again
Let me know
gowflow
to change the description of the button.
1) Developper tab
2) Press on Triangle to go design mode
3) right click on the button and choose Properties
4) Change Caption to what you want
5) exit properties by clicking on the X
6) Press on design so you activate macros again
Let me know
gowflow
ASKER
to change the description of the button.Done
1) Developper tab
2) Press on Triangle to go design mode
3) right click on the button and choose Properties
4) Change Caption to what you want
5) exit properties by clicking on the X
6) Press on design so you activate macros again
No it is VBA not a formula. Do you want it as a formula ?
No I happy with code just need to understand logic how do I get via formula. so not exact formula for this but just logic. if it is not possible let it be.
Thanks
oooooh
You are asking for something maybe difficult. Did you see the code ? do you understand the logic?
If you want this as a UDF function that I need to work on it, I am not very strong in formulas I usually use VBA but if you want then I can look at it, for sure this you need to ask 10 questions !!! :)
just kidding, let me know if you want to post this as a question, I do not guarantee success but worse the try.
gowflow
You are asking for something maybe difficult. Did you see the code ? do you understand the logic?
If you want this as a UDF function that I need to work on it, I am not very strong in formulas I usually use VBA but if you want then I can look at it, for sure this you need to ask 10 questions !!! :)
just kidding, let me know if you want to post this as a question, I do not guarantee success but worse the try.
gowflow
ASKER
No Sir No new question. actually I wondered how do I achieve this via formula. I think twice but no success. so post a question - no matter VBA or formula. & finally found via VBA.
Now for few days say 3 to 4 days halt for new questions. working on all to gather which you had solved in recent time & past time. Merging all thoughts of back testing & predicting future.
Thanks
Now for few days say 3 to 4 days halt for new questions. working on all to gather which you had solved in recent time & past time. Merging all thoughts of back testing & predicting future.
Thanks
Good glad I could help. Will keep this one open case you need new help pls post link here.
gowflow
gowflow
ASKER
ooopppss
may I ask one new question...?
In which I have to convert shorter period data to longer period - Say I have 1 min Data of stock price want to convert to 15 min - 30 min - 60 Min - 1 day - 1 Week - 1 month.
Thanks
may I ask one new question...?
In which I have to convert shorter period data to longer period - Say I have 1 min Data of stock price want to convert to 15 min - 30 min - 60 Min - 1 day - 1 Week - 1 month.
Thanks
ASKER
ASKER
May I Ask New Question?
ASKER
Thank You