1. K

    Finding the line number of code using code with VBA/VBIDE

    Basically i want to use a macro to search another macro to return the line number of the particular code i'm looking for. The problem is, codemodule.find() has no other valid qualifiers to tag on the end such as .line or .row (codemodule.find().line) This is the general concept i would like to...
  2. J

    VBA Code dynamically written to worksheets not working when project is protected

    Hey Guys, My problem: I have a userform launched on the workbook open event for the user to input the names and tech data for a range of fans. For example, they enter 5 fans. Once they enter the data into the form and click start, 5 sheets named,for example Fan1, Fan2.... to Fan5 are...
  3. L

    Assign Macro to Checkbox using VBA

    Hi all, I am new to VBA and trying to make my Excel Workbook create checkboxes and then have each checkbox add a certain series to a chart if checked, or remove the series if unchecked. Here is the part of the code, that adds the checkboxes: Sub CreateMainPage() ProjectRow = 5 ProjectCol =...
  4. A

    Create new worksheet with Event Handler code with vba.

    Hi, I'm trying to create a new sheet with event handling code using vba. I've read and tried heaps of options but none work for me. My code is: Sub Macro3() Dim code As String Dim NextLine As Integer Sheets.Add.Name = "Test" code = "Private Sub Worksheet_FollowHyperlink(ByVal Target As...
  5. K

    Adding code to a programmatically created userform CodeModule

    I'm having trouble finding a simple (relatively so) way to add a huge chunk of code I already wrote for a previous userform to a userform that is programmatically created. The userform has a set of OptionButtons, some TextBoxes, and CheckBoxes. I previously created a userform the normal way...
  6. M

    Change Code using VBA

    I am trying to change hundreds of workbooks using VBA. I have a main drivers workbook with the following code.. in a simple file processing loop.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I got this from the following thread. <o:p></o:p>...

Some videos you may like

This Week's Hot Topics