worksheetsproject

Afternoon all I am using the code below to populate a Userform from data held on "Project Master" Worksheet. I am trying to add a command button to transition to previous and next rows, but for some reason the code i tried either jumped me to the header row (row 1) of the "Project Master"...

Good morning I have the following code which clears the contents of one Worksheet "Project Summary" then copies and pastes certain columns of data from another worksheet "Project Master" and pastes them into "Project Summary". the problem I have is that when I run the code it causes the the...

When my Userform loads a Combobox is populated using the following code: Private Sub comboboxFill() CmbFindProject.Clear totRows = Worksheets("Project Master").Range("A1").CurrentRegion.Rows.count For i = 2 To totRows CmbFindProject.AddItem Worksheets("Project Master").Cells(i, 1).value Next i...

Morning all I have an excel workbook I am using as a database with 2 worksheets "Project Master" with 72 Columns of data and "Project Summary" with 8 Columns of selected data from "Project Master". I also have a Userform "frmViewData" which when open is populated by selecting a Project from a...

Is there as way of sending the contents of a Multi Column Listbox to a single cell in a worksheet. I am currently using the following code to send data from a Userform to Worksheet, but for some reason the data from my Multi Column listbox does not transfer over. The data is a combination of...

I'm launching a user form from a worksheet. I then concatenate the values from that form to make a string and sending its value to a cell on another worksheet. Private Sub SaveButton_Click() Dim resources As String Dim r As Integer r = ActiveCell.Row If ProjectSponsorBox.Value <> "ERROR"...

I need to delete a range and I want to preserve the cells around it, so deleting all of the rows is not an option at this point. So far, my research has shown that you can only delete an entire row. You can shift the cells up or to the left, but I have found nothing that shows how you can...