Microsoft Excel Forum

What is the problem with the macro : below Sub M() C = Worksheets("SHEET1").Range("B5") C = ActiveCell My_row = ActiveCell.Row End Sub

I have an Excel workbook, which is an order form using tick boxes, if "ticked"(true)the item seleted data appears into other worksheets. If it returns "" (blank)then I want to delete the blank rows in various other worksheets within the workbook. Can someone please help with some code I have the following code which will work in 1 worksheet but...

Hi, I have an excel sheet that has a graph in it. The graph is a line graph and has bars that contain 2 numbers that add together that create 1 bar. I have made a textbox that has "Active X" functions on it. meaning that the textbox pulls from VB code. Anyone know of the code to grab numbers from a worksheet and add them together? EX:...

There are so many functions available in Excel Worksheets that users often stick with the most common ones until they start exploring trying to find a solution to a problem. Sometimes it doesn't even occur to them that there may be a function to deal with the issue. So I decided to draw on my experience to note some of the lessor known functions...

Below is the function I defined. It is supposed to calculate the amount of payment terms between two dates (rounded up) and do this according to a dropdown menu that gives users the option to select monthly, quarterly or yearly payments. Functions first argument is the result of this dropdown, the second argument is the first date and the third...

This macro is written in Excel 2010 which works perfectly on Microsoft XP but it fails on Windows 7 and 8. What macro does --- It gives 3 drop down options to user Select Month ----This is the excel file for e.g. July 2013.xlsx it contains sheet from the date 1st July to 25 July Select From Date --- Dates from 1st July to 25th July Select To...

In Excel, I am trying to convert the date yyyy-mm-dd to yyyy-mm (in my database), so that my pivot table doesn't included every day of the month. Is there a simple way to do this?

I have a public json URL that outputs a digit. How can i have a certain excel spreadsheet cell pull the data from that URL and use that data?

Hi, I have a notepad and I want to find a text into notepad. Once I find the text in notepad then I want to replace entire line with new text. This I want to do using Excel VBA. I have written a code that searches in a file but replaces only the text which it finds but not the entire line. Below is my code

Hi Hope someone can help? I have a form with a number of text boxes - users enter a numeric value into some of the boxes where appropriate. I would like to have another text box that keeps a running total of the numeric values entered in the same VBA form. Is this possible? TIA

Hello everybody Is it possible to disable the keys Ctrl + Alt + Delete in excel? I searched a lot but found no results which can do that

Hello everybody I have four cells which I need to navigate through using Enter key My range is ("D10:D13") If I was in D10 and press Enter then go to D11 (That's the deafult)>>>> If I was in D13 and Press Enter key I need to go to D10 again As for other cells no change in using Enter key Hope it is clear

Hi i am trying to open a wizard on an excel file (.xlsm) but it fails to start and gives me this error: Microsoft form could not load some objects because they are not available on this machine. how can I solve it?

I have a range of cells containing names in A6:A12. I also have corresponding values in columns B,C,D and E. I want to compare the value of C3 to see if it matches in the names then extract the corresponding values in B,C,D,E and placed them in column G,H,I, and J. This is the formula I used...

I have this sub i created for Excel. The idea is to populate multi column list box from values in an excel spreadsheet. I am stepping through the code which executes fine but no values are loaded in my list. Anyone have any ideas? Private Sub cmdContact_Click() Dim cell As Range Dim Rng As Range 'Me.lstEmployee.Clear 'Make sure...

Folks, Trying to do something simple here, I want to take a value that is a string and convert it to a control. Simply put I am looping through an array and when i find a value i am looking for, i want to grab that counter and generate the control. I am using a string to put the value together and then I simply want to convert it to a control...

Greetings, I have a routine that iterates through many worksheets and Autofilters (using criteria filterStart and filterEnd) a range of data (A8:H200) using (field:=1). The code works well for that. What I want to do is filter using field:=1 unless field:=1 is empty, then I want to filter by another field. I have no idea how to accomplish this....

I have created a chart with present and future dates. In this chart I use a vlookup formula to look up information from a pivot table. I have also added error handling so that if a date is not in the pivot table that is on the chart if leaves the cell blank. This works great for all future dates. However when I have created a graph from the...

I was sorted all my data in MS Excel. I saved .xlsx file and went for a walk. It was yesterday evening. After my boss called, me and I had to add some data in file. During I was saving it, MS Excel was closed. After opening it, I didn't find most of my changes for a day. I am using MS Excel 2016 on Win 10 x64.

Greetings, I am trying to find out if something is possible in Excel VBA. I would like to use a string or integer to modify/represent the name of a range object. Please note that I do not have a range stored in string format. For example, I have the following range objects already set: rng1, rng2, rng3, etc. I am looping through rows and...

I have created a button on Excel which I would like, when clicked, to attach the completed workbook to an email and be sent directly to a mail recipient. How do I do this? The button has been created and is clickable I just need the process of embedding the/a code to it and what that code is! Many thanks

OK, So I have a very specific problem that I hope to make not-a-problem, but I need some help. I am a complete neophyte when it comes to making Macros. I’ve got a customer that has put long lists of references in a single column in Excel (normally, the references are just in one cell). I’ve figured out how to consolidate a selected portion of a...

Hi all, I need to combine the action of a command button to be dependent on the selection in the Combo Box in order to fill the cell with the selection that the combo box refers to. For instance, if I have three A columns, A2: Shoes A3: Socks A4: Gloves

I am trying to create a macro that copies the active worksheet to a new worksheet and paste values only. For instance, Sheet1 is the active sheet. I want to make Sheet1(2) with values only. Additionally, I evaluate each row of the Sheet1(2) to look for a value of X in a cell in each row. If there is an X, then the row is deleted. My...

I have a WordPress website that have affiliate products on Amazon. I want to integrate my website with Excel Sheet to get all my customers data those have visited my website, clicks on it and also purchased products from Amazon.