codemodule

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

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

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

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

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

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