macros for vba

ch as string ch = ch & "}}}],""must_not"":[{""query"":{""match"":{""work"":{""query"":""****"",""type"":""phrase""}}}},{""query"":{""match"":{""work"":{""query"":""****"",""type"":""phrase""}}}} I would like to split it into many lines. How do I do it ? I tried using underscore but it...

Hello All, I am starting to learn advanced functions in Excel so please forgive me if I do not explain this well. What I am trying to do: 1. I need to create a check box per row. (not a big deal to explain, I can figure that one out using videos/forums I have found already). Check box begins...

Normally I can figure these errors out but I am stumped. I am getting the dreaded runtime 1004 Method 'Range' of object failed. The issue I am having appears to be that I cannot set a range to the Target when using Worksheet_Change event handler Here is the VBA: Private Sub...

I want to refer to any date of the data set and make the cell value move UP until cell value is equal to text or in this case "BRL" Because "BRL" is a Row label of a Pivot table and I want VLOOKUP to look at the code assigned for BRL. If it is text, I want excel to run the formula in BLUE...

Can i Use rectangle shape as a progress bar showing progress of my work. I don't want to use cells as progress bar as my application has the requirement that the shape should move from column to column. I want to do it using macro.

Hi guys, I wasn't able to find this question in any of my searches so it would be great if you could help me out. I want to create a macro that will copy a set of data (identified by common field, ie. Coffee Type in this example) and replace existing data in a separate worksheet. I.e...

Dear Experts, I have a problem, I need to insert a dropdown list in my first excel sheet named "POC" Which should automatically show any sheet being added and on a click of button can directly take me to that sheet. My other sheets are named as "APRIL 2015" "MAY 2015" and so...

I want to create a spreadsheet that will send a product link to amazon.com and have amazon send back certain product information to excel For example, here is a product link that would reside in the excel spreadsheet: Amazon.com: Corelle Livingware 16 piece Dinnerware Set, Service for 4...