key

HI all, Need a help to disable the Escape key while running a macro. I am calling all the macro by below code is there any way I can disable "esc" key so that no one can interrupt the running macro. Sub EveryThing() Call Clear Call CSV Call Lookup1 Call RefreshAllPivotTables...

In Power Query, how can I add a column which merges columns based on a list (so the list of column names gets merged)? If done manually, I would have let Source = Input_Original, #"Added Key" = Table.AddColumn(Source, "Key", each Text.Combine( { [Column1]...

Hi there, I have a spreadsheet which I need to replace a users keystroke with a bullet point when they type. I thought that the # key would be suitable as it doesn't have much use in this document... I was hoping to use some code such as: Application.OnKey "#", "addBulletPoint" so that when...

E.g A cell containing "app" or "apple69" should be cleared; but they are getting matched to "apple" This macro was posted by another user in a different forum and they will not reply. How can the match creteria be made Exact. Option Explicit Sub REMOVEINV() Dim LastRowD As Long Dim...

Hi I have the following path in vba which at the moment is static: "C:\Completed Scorecards\May" Rather than May being fixed, is it possible to prompt the user to key this in using an InputBox so the user can specify June, July etc? thank you

Hi guys, I have a spreadsheet which contains a list of people (A new row for each person. Information on home country, organisation, contact number etc.. are in columns A-Z). I want to highlight any cell in columns I, J and K which contain specific 'key words'. The column of key words is...

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

Hi Everbody, I have done the summary using Dictionary in VBA, but i have many loops in my code. Is there a shorter method that I can use or nest the loops one inside the other. Secondly , I am looking for a solution to summarize the data by name and by Location, 2 criterias using the same code...

Under Macros, functions from one of my modules has the workbook and module name prefixed to it. Wouldn't be much of a concern, but it won't let me assign a shortcut key to it as a result. How do I get the macros to name the functions as initially set? Any help would be greatly appreciated...

Hello All, So currently I have a macro that cleans up some data and the copies it so I can paste it into a different program. The formatting of this copied information needs to be very specific and if the "Insert" key is currently enabled it breaks the formatting when pasting the information...

(Apologies, just joined - this question has been asked here before, but was not followed through) I have received a locked spreadsheet (from a source I wouldn't be able to query) that wraps both horizontally and vertically, when moving between cells using the arrow key. e.g. if the active...

Hi, I created a dashboard for work and a part of the screen it allows you to select different charts (Top location breakdown, custmer breakdow etc.. Basically when criterai in cell is select it will bring that chart/analysis to the front of the area. They asked if I could add Key stats option...

Hi, Im using the VBA dictionary to make a summary report by salesrep for quantity and value. The problem is if I put an IF condition testing for the year to be 2017, one of the values comes wrong. If I remove the IF condition the code works fine and gives all the correct results. Is there a...

Hello all, i have table like this: <tbody> <tbody> texttexttextKEYVALUEtexttexttext </tbody> here i need fill value of item for if the key is found in text in column A <tbody> texttexttextKEYVALUEtexttexttext </tbody> here i need fill value of item for if the key is found in text in...

Hi Experts Looking for suggestion on Data model(PowerPivot) with Fact and dimesion for below Fact table on which i need to measure KPI for "ZONE" with filter option on Area and Region [ fact Table ( below is example of 60000 R and 90 C) ] I have create 3 dimension tables 1. Area ( Primary...

I want to use function key F2 only - disabling all other function keys what is the vba for enabling function key F2 only and return to default when exiting workbook should the code be written in thisworkbook or in modules? Thank you very much

Hi, Is it possible to press a toggle button to activate a send key button then press that button (i.e. directional buttons - Up Key, Down Key, Left Key, Right Key which will have a macro assigned to each) but be able to repeat the key button press as many times as desired until the toggle button...

Hi all, Hope someone will be able to help. I am below beginner with VBA and what I'm trying to do is starting to frustrate. I have a form for a customer to complete. When a number < 5 is entered into a specific cell I need a pop up to come up saying "Please provide key improvement" This would...

On this userform I have been working on, basically I have TextBox1 + TextBox2 = Subtotal, Then subtotal + TextBox3 = Grand Total Which the code looks like this Private Sub TextBoxSum() Dim Total As Double Total = 0 If Len(TextBox1.Value) > 0 Then Total = Total + Val(TextBox1Value)...

Good Morning All, I’m looking for a solution to not have to use the tab key when entering golf scores on a form. Separate field for each hole. Scores are entered like: 4 4 5 5 4 10 4 5 ... ==================== If the score entered is greater than 1 Then Go to the next field ‘ Post the tab...