Question description:
This user has given permission to use the problem statement for this
blog.
In excel how do I activate an object based on a value from a cell.
I'm wanting an arrow to appear based on a value in a cell that has been returned from the sum (formula) of a range of cells.
I'm trying to teach myself to code and I'm very much at the beginning stage
Solved by F. A. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
05/08/2018 - 01:10
Hi there
User
05/08/2018 - 01:10
Do you use the developer tool in excel?
User
05/08/2018 - 01:11
Developer is an add-on so you can code and build macros
Excelchat Expert
05/08/2018 - 01:11
Developer tool in excel are used on for macros.
Excelchat Expert
05/08/2018 - 01:11
That;s right.
Excelchat Expert
05/08/2018 - 01:12
To display the DEVELOPER tab, click on the File menu and then select Options from the drop down menu. When the Excel Options window appears, click on the Customize Ribbon option on the left. Click on the Developer checkbox under the list of Main Tabs on the right. Then click on the OK button.
User
05/08/2018 - 01:12
Yes, I havfe done all of this
User
05/08/2018 - 01:12
What I need to know is how to get a custom shape to appear when a value has been returned in a cell from a calculation of numbers over a range of cells
Excelchat Expert
05/08/2018 - 01:12
So buddy you want to input some object on cell?
User
05/08/2018 - 01:13
I'll upload the spreadsheet so you can see what I have been working on, is that ok?
User
05/08/2018 - 01:14
Did you receive this?
[Uploaded an Excel file]
Excelchat Expert
05/08/2018 - 01:14
Sure buddy.
User
05/08/2018 - 01:15
When a value appears, like in column "F", I want a custom arrow (red) to appear alongside the corresponding graph (image). How do I get this to work?
User
05/08/2018 - 01:16
I know how to get the arrows to appear and disappear using code, but I don't know how to do this based on a value (or range of values), that appear in a cell
Excelchat Expert
05/08/2018 - 01:16
Let me check dear.
Excelchat Expert
05/08/2018 - 01:18
Is the result is what band is?
User
05/08/2018 - 01:22
Yes
User
05/08/2018 - 01:22
So the arrow will appear alongside the corresponding band, reflecting that number
Excelchat Expert
05/08/2018 - 01:23
Do you like to do it by If function?
User
05/08/2018 - 01:23
An arrow represents a range of numbers
Excelchat Expert
05/08/2018 - 01:23
Do you know how to make it arrow up and down.
Excelchat Expert
05/08/2018 - 01:24
Its sound its VBA topics.
User
05/08/2018 - 01:24
I know how to use conditional formatting, if that's what you mean
Excelchat Expert
05/08/2018 - 01:24
Yes.
User
05/08/2018 - 01:24
That isn't what I'm looking for
Excelchat Expert
05/08/2018 - 01:24
Conditional formatting.
User
05/08/2018 - 01:24
Yes, it will fall under vba
Excelchat Expert
05/08/2018 - 01:24
Can you please elaborate .
Excelchat Expert
05/08/2018 - 01:25
But subjects here for now is excel and VBA.
Excelchat Expert
05/08/2018 - 01:25
Passed on Excel.
User
05/08/2018 - 01:25
It has to be a code written to get the custom shape to appear and disappear based on a value from a cell
Excelchat Expert
05/08/2018 - 01:25
Do you have any idea about VBA/
User
05/08/2018 - 01:26
I have some very basic understanding
Excelchat Expert
05/08/2018 - 01:26
Yes but how did ou insert that arrow up and down based on criteria?
Excelchat Expert
05/08/2018 - 01:26
Let me know so that I learned too.
User
05/08/2018 - 01:26
I have been teaching myself by using on-line tutorials
Excelchat Expert
05/08/2018 - 01:26
YEs like UDEMY.com.
Excelchat Expert
05/08/2018 - 01:27
You can extend time by 20 mins here.
Excelchat Expert
05/08/2018 - 01:27
So lets be consider your topics.
User
05/08/2018 - 01:27
So, I'm assuming you can't help me at this point in time?
Excelchat Expert
05/08/2018 - 01:28
I noticed that based on value of F column change the arrow up and down.
Excelchat Expert
05/08/2018 - 01:28
Try my best.
User
05/08/2018 - 01:28
Thanks for your assistance, I appreciated your time.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.