module code

Hi everyone, I'm new to Visual Basic. For the past 2 days I've been trying to make functional an automatic code that should process multiple Excels and change one of the modules code from their respective Visual Basic projects. Each VB project is protected. I used this following code to...

Hello to all. I have been working on a macro in a module and it does what i want it to do. I want to run the macro from a Command Button on a worksheet. I copied and pasted it making sure not to double up the "Sub" commands - beginning or end. Now the macro does not run. I get errors...

Hi everyone, I have another question for everyone. This one is a bit complicated as several aspects of the code need fixing, and I am having a hard time doing so. If there are any helpful mind out there please have a look at he the problem below. What the VBA code should do: Each time text is...

I have a Excel sheet: (1 tab - Test_OHLC, 3 modules VBA) CryptoCurrency_7_14_days_kraken.xlsm at the moment I can obtain info into according AssetPair=C6=ListOf_All_Crypto(I can select just 1) and Interval=C8 and TimeFrom=C10(Calculated in M2:M4) cells: B16:J800 which contains: assetpair time...

I'm trying to create a macro that will compile specific columns from all worksheets in a workbook into a single new worksheet. What I have so far creates the new sheet, and returns the correct headers for each column, but copies across all columns from the existing sheets rather than just the...

I keep getting an error message every time I try to test the macro, after assigning it to a cell in my excel file. This is what the error says: Run-Time Error '380' "Could not set the RowSource property. Invalid Property Value." I've included a screenshot of this message and a copy of my...

Hello All, I am having a problem I hope someone can help me with. I currently have three columns, from which I take their contents and combine into a single column (#2). I then used a VBA code to Concatenate each cell in the new column (#2) and have the output come together in one cell (#3)...

Hi All, I have a module written to pull data from one sheet (Raw Data) and into another (Opportunities). But I am having trouble with the last piece. I THINK I need to group by Column B in Raw Data - but I still want to sum by Column C in Raw Data. Not sure if that is correct, but I was able...

<code class="vb keyword">I have a spreadsheet displaying a list of "Topics to address" that people from different departments can add notes and updates to. I have a "last modified by" column and "date modified" column that i would like to merge and display the name, date, and time of the last...

Hi I have a macro that works fine if it is in the workbook that is being used, but i want to be able to make it work in any active workbook by assigning the macro to the quick access toolbar, but i cant get a worksheet selection change event in a module in my personal xlsb. This is my code i...

Hi All, I am trying to Accomplish the following: Create a form that has a search function to search an item list but allow the user to also search through the item list using a bar to move up and down through the list. allow the user to edit only 1 column in the list (qty) list is stored...

Dear Users, I'm trying to run the code here: Stack Overflow When you press a button it checks the active worksheet and tries to run all the code in the worksheet object in Microsof Excel Objects that has the same name. I tried running it but I get a Subscript Out of Range Error. Thanks...

I appreciate that I already have a post running (with no responses thus far ) requesting help on rejected automatic emails that have failed due to the email accounts no longer exisiting. The initial sending having been completed by some VBA code (in a module). Am I asking for too much in wanting...

Hello excel masters! I've written some module code for a button that when clicked, the contents of particular cells are transferred to another workbook, however it seems that when the contents of the original cells are not numbers the code doesn't work. One of the cells I'd like to send from...

Hi legends! I'm trying to code a button that allows you to take the contents of one cell (that will be a time unit - hh:mm, let's say, cell F12) and add it to a range of cells that you define in another cell (say H12). Could anyone help me with this?? Thank you all for you awesome help!