addme

Hi I have a VBA that i'm able to select records from the userform and add them to a new worksheet, however I need the data to start of D9 how do I go about changing the code for this to happen Dim addme As Range Dim x As Integer Set addme = Sheet1.Cells(Rows.Count...

I have inherited a spreadsheet which has a number of userforms that have some reasonable coding in behind them. One userform allows the user to click on which teacher they are, and the userform then populates showing which students belong in the class(es) that teacher teaches. The user can...

All: I have a listbox that is populated by a dynamic range from another sheet. The listbox has (1) command button. Once that command button is selected, it "grabs" the selected lines of record and adds them to a worksheet so those records can be assigned. Below is my code that I am working...

Hi, can some one help me to add search option in user form(search as you type) here is the code Private Sub cmdadd_Click() Dim addme As Range Dim x As Integer Set addme = Sheet1.Cells(Rows.Count, 3).End(xlUp).Offset(1, 0) For x = 0 To Me.lstSelector.ListCount - 1 If...

I have the following code that does several things. Private Sub CommandButton3_Click() Dim Addme As Range Dim x As Integer If IsEmpty(Sheets("PrintTemplate").Range("V49")) Then Set Addme = Sheets("PrintTemplate").Range("V49") Else Set Addme = Sheets("PrintTemplate").Range("V" &...

I have a UserForm ListBox that has two columns. I'm currently using the following code that, when an entry in the ListBox is clicked, the code will send the contents of the left column of the ListBox to PrintTemplate!V49 (and downwards), and the 2nd column information to PrintTemplate!W49 (and...

Here is a code I'm using to ... * choose students from four list tables on a userform * make copies of a template sheet .. each sheet named one of the names found in the range that houses the names of the students chosen from the userform list boxes * print page 1 of each of them * delete the...