arrow

Hello, I'm working with 3 cells on this question. I want cell (G6) to display a left arrow ("×" with 'Wingdings' font) and when a name is typed or pasted into cell (E6), I then want a right arrow ("Ø" with 'Wingdings' font) to replace the left arrow in this cell, where when the user enters a...

At the moment I have the following Private Sub SpinButton2_SpinUp() TextBox_starttime.Value = Format(CDate(TextBox_starttime.Value) + 1 / 96) End Sub Which for the most part works fine, what's driving me crazy is that I have the textbox formatted as "13:00", however when I click the up...

I have list in following fashion. A B C D Act Serial number Month Units 100412403 8604158 Sep-17 351 100412403 8604158 Aug-17 396 100412403 8604158 Jul-17 379 100412403 8604158 Jun-17 407 I have 25000 rows (or more)(records), I want to filter by column 'A'...

Hey Friends, Hope all are doing well. I just made one drop down by using combo box. I want to select items by using up/down arrow keys. is it possible? please help Regards

Hello I have been using this form in the past and with it I have been able to produce combo boxes that are dynamic. I’d like to take the combo box to another level and allow users to scroll through the results with the arrow keys. The only problem is that the field updates to the first item...

Hi All, I'm trying to do some conditional formatting that appears to be more complex than what excel wants to do: I have a set of about 10 metrics. For each metric I want to do the following: A) If the metric went up or down from the prior period, I want to see an arrow going up or down (or...

I am using link live data to Excel sheet. In particular row live rates updated every second. I want to use up down arrow icon while changes the price movement. For example: In Excel particular row value start with 10.05, if next value 10.06 comes it shows up arrow again 10.05 comes it shows down...

Hi, the shortcut Ctrl + arrow is skipping fields with data? I've tested both up and down columns and also left and right in rows. There is no pattern to the data it's skipping over. Has anyone ever had this occurrence? Philip

Hello all. I have found a few articles but nothing that really matches what im trying to acheive. I would like if B2 end with the letter B then shape "Up Arrow 1" rotates to 180 degrees elsewise keep at 0 degrees. Any help would be greatly appreciated.

Hi, I currently have the code below placed into a wksheet that changes the size of an arrow when the value (from a formula) in cell B13 automatically changes. I would like to be in control of when to execute this routine using a command button / macro at any time that will simply just change the...

Hello All, In order to make the 'Up' and 'Down' arrow keys work properly, I am using some code like the following: First, the Worksheet Selection Change event: If Target.Row = 49 Or Target.Row = 58 Then Application.OnKey "{Up}", "NextUp_toRow31" GoTo UpArrowEnd End If and then, in a...

i want to make a diagram/graph out of a given function. The diagram (dont know the enlish term) is made out of a line connecting the X axis and the point that is calculated with the function. I have an example here in this google(r) picture. In stead of a little dot at the end of the line, it...

I recently had all my dropdown arrows disappear from my Data Validation cells in Excel 2007. I tried going into the Excel Options-Advanced-Show All objects, but this did not work. I also tried enabling/disabling the "In-cell dropdown" command in the Data Validation itself but to no avail. Any...

C2=numerical value. D2=Either of 1 or 0 Solution required: I want to 'add' an up arrow in C2 if D2=1 else no arrow to be added. Using Excel2007

This is my first post at MrExcel.com I have a spreadsheet in Excel 2007 containing hundreds of thousands of data. Several cells in the sheet have a right facing arrow at the beginning of certain cells and it seems that I cannot even copy that arrow to replace it with nothing It looks like this...

I would like to build a scatterplot where each icon is a simple arrow. The arrow would change orientation based on a given value so, for instance, if the value were above 80 the arrow would point upward but under 20 would point straight down. Is there a way to use the arrows, either the ones...