module code

  1. M

    How to automatically change a Module code in multiple protected Visual Basic projects

    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...
  2. M

    Code from module does not work when i attach it to command button

    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...
  3. N

    Triggering a HTTP Search, through Cell Value Alteration

    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...
  4. MinoMacro

    CryptoCurrency - obtain information 7, 14 days min/max for all currency pair from Kraken

    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...
  5. A

    Copy columns from existing sheet to new sheet with VBA

    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...
  6. C

    Run-Time Error '380' When testing the macro in VBA Excel (Rowsource Property issue)

    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...
  7. R

    Updating Comments Textbox VBA

    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)...
  8. L

    Sum if / Group by VBA Module

    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...
  9. R

    cell specific "last modified by" module

    <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...
  10. S

    Worksheet Selection Change to work on all sheets

    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...
  11. L

    compile error User-defined type not defined Set objXL = New Excel.Application

    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...
  12. M

    Call all procedures of a worksheet module that relate to the active worksheet name

    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...
  13. W

    Returning/failed emails following vba code distribution exercise

    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...
  14. J

    Module code

    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...
  15. J

    Button code for module

    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!

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top