Search results

Why does it skip case 1?

to change the row I would add +1 to it?

Been working on a new program that is working however when it reaches the case select it skips case 1 moves to case 2 checks it and skips the rest of the cases and exits the cycle. Variable myID will only stay on the first row of data and will not check the rest of the excel spreadsheet. What...

I have created a database and would like to link the data from excel into the database but I have found that one of the columns will only accept numbers and will not allow changes to the datatype to allow this otherwise I have #!NUM and you cannot read it. I have imported the data from excel...

Thank you for responding I have changed how I am going to do this. Thanks

Is there a way to add a comment to a specific cell while unprotecting and protect the sheet?

I think it might have been a glitch in my system causing the duplication.

Nevermind I figured out what I had done wrong. Thanks for your help

sorry. What I have going on in excel is the countif that will calculate the number of Y in a particular column and then in another cell it keeps track of the total number. The countif is no longer working therefore not allowing the countif and percentage to change with the new code. When I look...

none of the above counts are working any suggestions and it is duplicating cells in excel?

thanks I will try it

Is there a way to modify the if statements to help reduce the cluttered mess for the if statements. I am going to be adding more if statements to compensate for more data. Below is the program that I currently have: Private Sub process(ByVal myRow As Integer, myCol As Integer) Dim ce As String...

Thank you it worked

So far this code is running fine however I have noticed that everytime I rerun the update for data it keeps showing the form while updating is there a way to hide it and have it show only once for each page that requires it. Option Explicit Private Sub process() Dim ce As String Dim AA As...

What I am also trying to do is learn VBA but here and there I seem to get stuck

Update this is what I came up with and it worked Private Sub CBOk_Click() tbentry = tbentry Sheets("ToolChange").Range("C3").Value = tbentry.Text tbentry.SetFocus tbentry = Cells(3, 3) End Sub However, the value and form still remains active so I will need to close the form and erase the entry...

What I am doing is I have a form with a text box called tbentry. I want this value with the sub CBOk_click() to load the valule from the textbox and go into the sheet called ToolSheet into cell C3

Private Sub CBOk_Click() Dim tbentry As Long Sheets("ToolChange").Range("C3").Value = tbentry.Value tbentry.SetFocus tbentry = Cells(3, 3) End Sub I am receiving an error for tbentry. value as an invalid identifier.

Option Explicit Private Sub process() Dim ce As String Dim AA As Range Dim AB As Range Dim AC As Range Dim AD As Range Dim AE As Range Dim AF As Range Dim AG As Range Dim AH As Range Dim d As Integer Dim e As Integer Dim f As Integer Dim g As Integer Dim h As Integer Dim i As Integer Dim j As...

I figured this out.