subroutines

  1. D

    passing sheet address to subroutine

    what is a correct way to access a open workbook.sheet that is currently open when linking to a subroutine or a function? ie.. i open two workbooks in the main routine and the based on a condition in the main routine i link to a subroutine. I can't figure out how to read a value on the open...
  2. A

    How save/use Subs from central storage

    Hi, I want to save my different subroutines which I use in some tools at a central place, so when I update them I have to update only the subs in this workbook. I put them in a workbook and add this workbook in the VBA ****pit under references. No I have access to the scripts in this central...
  3. O

    Excel Limitations for Large Macros

    Hi All, I'll try to make this as brief as possible, but please let me know if I haven't supplied enough info. I have a project with approximately 19,000 lines of code (I'm assuming that's large but have no frame of reference). It has multiple buttons that launch subroutines to find specific...
  4. P

    Passing 2-dimensional arrays between subroutines

    I cannot seem to get this to work. I want to pass a 2D-array from a subroutine to other subroutines in which a data manipulation should take place. I am calling below subroutine from a command button on Sheet1. In Module1 I have declared the variables as public. Inside the subroutine...
  5. M

    output vba sub names

    Hi, I have a vba program. How can I create a routine to output the names of all the subroutines into the excel worksheet? Thanks
  6. S

    Executing a Subroutine on a cyclical basis using time as a condition for execution

    Greetings, I am interested in building a subroutine that imports external data from using a web query on a cyclical basis, one day, one week, one month, or one quarter. I would like to know if anyone has experience in doing this and if so how might be best to structure the block of code that...
  7. S

    UserForm General Structure

    Greetings, I am somewhat new to userform objects and how best to structure elements within the userform etc to allow for smooth operations. I have many textboxes, listboxes, a few buttons and whole lot of variables. Let me describe the structure I am trying to build... First, I have a...
  8. S

    UserForm and VBA Subroutine Integration Brainstorm

    Greetings, I am trying something new and wanted to share my ideas and get some feedback and potential resources that could improve results before I jump into construction of userforms and subroutines. I would like to build a tool that is GUI friendly using Excel Userforms and VBA subroutines...
  9. B

    Debugging my formatting module

    So I don't know what's going wrong with my code, it's just designed to automate a formatting task that I repeat often at work. I've put comments in for all the subroutines to explain them but basically it finds the used range, borders it, formats the headers, uses select case to find specific...
  10. H

    Extracting and sorting data from a strand in VBA

    I'm trying to take a strand, extract some data (connector type), and sort that data to determine which comes first. For example, given the strands VS IM SC LC SM DPX PVC 2LBL and 5m FDDI ST 62/125 MULTIMODE FIBER I want to write "SC" AND "FDDI" into a column called "ConA" and "LC" and "ST" into...
  11. S

    Parsing variables between subroutines

    I'm doing something which is probably foolish - namely taking some vba that i've written that works and trying to make it more technically correct by using subroutines. It doesn't need it as it is fast enough as it is but i'm a perfectionist and if it ain't broke don't fix it is about to become...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top