arrow

Hi I'm new to using this forum and only dabble in VBA so my apologies if I make mistakes in my attempt to get the information I require. I want the Left Arrow key press to be ignored if the active cell is in column one. Without it being ignored the active cell now moves up one row and to the...

Hey all, I have a worksheet event code Private Sub Worksheet_SelectionChange(ByVal Target As Range) which works great. Well, I want to bypass or stop using it if a specific key is being held down. In this case the arrow keys. Reason being the arrow keys are used for scrolling through the...

Hello I have an excel workbook which runs on a date range. The dates are selected using a dropdown list, everything was working fine until last week when a random arrow (very similar to the dropdown arrow) appeared. When clicked it produces an empty list and I can't figure out how to get rid...

Hi I have a spreadsheet containing a dropdown menu There has never been an issue using it in the past, however we have recently upgraded to 2016 and when i click on it now the drop_down arrow quickly appears then disappears again. In other tabs within the same spreadsheet , the dropdowns all...

Is there a way to more quickly navigate the Fill Color and Font Color pickers using the keyboard, besides using the arrow keys, which takes awhile? For example, it would be great to be able to jump from one end of the picker to another, both up/down and left/right. In case it's helpful, I'm...

I can't seem to find anywhere how to change the Plus or Cross sign (pointer, cursor) back to just a plain ol Arrow. Does anyone here know if it can be done. I want to make my pointer stay as a default Arrow instead of a cross when I'm working on my spreadsheets. Thanks in advance if you come...

Anyone has idea to Split the value of Combobox.Text with smoother functioning I tried the following Private Sub UserForm_Initialize() Combobox1.List = Worksheets("Sheet1").Range("A2").CurrentRegion.Offset(1).Value End Sub Private Sub Combobox1_Click() Dim splitValue() As String Dim...

Hi I just downloaded excel file .xlsx from the internet. It does not have sheet tabs. The first page is table of contents and it has forward arrow -> and back arrow <- to go from page to page (i think these arrow are hyperlinks). How can hide or remove sheet tabs? Thank you.

Hey Guys, Need your assistance and help- So, I'm creating an overview dashboard. My dilemma is that im trying to place an icon indicator up or down arrow key to show whether it meets the requirements example is the attached file here. So if you are looking at CS Quality SCore - if its > 92% a...

Hi there, I would like an arrow to show if cell H107 does not equal zero. I'm not even sure if I'm going in the right direction with this VBA code. Can anyone help please? Private Sub Worksheet_Change(ByVal Target As Range) If Range("h107") = 0 Then...

Hi!, I am trying to show/illustrate a connection between cell A1 and B3,B4,B5 through an automatic arrow / line - not by using shapes. Any help appreciated! Thanks! G

Hi There I received this file from someone, please see the screen shot below. What are these arrows, when i click on them, it opens up with a text box on left and it says its a diagram. how do you get this, is it done in excel or somewhere else like Visio and imported in excel. its not a...

I am wanting to know if this is possible.. I have two months this month and last month which I have a work completed each month and i want to compare between the two. EG current month - June 18 - 76% last month - May 18 - 74% In another tab I have a dashboard screen with tiles in so I want...

I followed the guide in the link below but have encountered a few problems and do not know how to fix them. 1) I have the combo box but the list in the combo box does not shorten when searching, only the helper column shortens which is less than ideal as the first 20 items in the list stay...

Can someone help me with this? I need results to be a green down arrow when A is smaller that C A&C are equal... a yellow sideways arrow A is bigger than C ... a red up arrow <tbody> A B C 50 result would be a green down arrow 100 100 result would be a yellow side ways arrow 100 100...

Hope someone can help me with the problem mentioned in "Title". Here is what I do and what happens: 1. I assign Proc1 to Application.OnKey "{UP}", command is Application.OnKey "{UP}", "Proc1" 2. when I hit the up arrow key Proc1 is run and does what I want. 3. I reassign Application.OnKey "{UP}"...

I have inserted symbols in S1 & T1 to indicate in increase (up) or decrease (down) . Have used the up nd down arrow using Wingdings 3 I have set up a formula to compute the increase or decrease and to include the increase symbol (up sign) and decrease 9down sign) at the end of the formula but...

Hi I want to select large number of cells using shift+ctrl+down arrow keys. I can highlight them no problem. After highlighting them I want to go up the first line, without losing the selection and without using the mouse. How can I do that? Thank you

Need help with "Conditional Formatting", specifically while working with Icon Sets. I'm currently using MS Excel for MAC 2016. How can I use icon sets when I have the following: "when value is between 90-100%, Green Arrow "when value is between 89-80%, Amber Arrow "when values is 79% or...

I have a sheet with annual sales and would to show green, red or flat arrow to show if sales are greater, lese or equal to the previous year.