Microsoft Excel, SQL & Internet Tips : How to Use a Do-While Loop in Excel VBA

[ducksaj]

Hi, could plz help me, I am trying to create a macro to run automatically everytime I change the cells value like " if range ("E7") = "cnh" then" I want to execute the macro if E7 = "cnh" or else exit sub. I hope you have understood me, thank you so much

[ducksaj]

Hello, I think if you dont know nobody does, so, is there a way to create a macro to set up the macro security level to "down" automatically, because threre are many users dont know how to do it, thank you very much..(sorry for my english, I am brazilian)

[ducksaj]

Thanks to put subtitle, I am brazilian and dont understand english very well, but this time was so easy, thank you so much

[IIIIROGUEIIII]

So how do I get the entry to go to the next "Row" if there is text in the line it is coded to be entered on?

[IIIIROGUEIIII]

**********Private Sub BtnSave_Click()

Dim WS As Worksheet

Set WS = ActiveWorkbook.Sheets("VENDOR DRAWING LOG") WS.Cells(3, 2).Value = TxtMachNo.Text WS.Cells(3, 3).Value = TxtModelNo.Text WS.Cells(3, 4).Value = TxtDrawNo.Text WS.Cells(3, 5).Value = TxtDrawDesc.Text WS.Cells(3, 6).Value = TxtRevision.Text WS.Cells(3, 12).Value = TxtRFI.Text WS.Cells(3, 13).Value = TxtRfiInfo.Text WS.Cells(3, 14).Value = TxtTransNo.Text WS.Cells(3, 15).Value = DTPicker1.Value End Sub*********

[IIIIROGUEIIII]

Very helpful to me as well. I am having trouble and thought this would answer my question, but it did not. I have a "Workbook" with two "Forms" in it that I use for data entry. But I can only get the entries to "Write" to the first row of the sheet. Whenever I add new data it will overwrite the existing entry in that line. I'll post the code in the next comment....

[MrStefanica]

Good work man!

The video is clear and straight.

Thanks!

[75STARFISH]

Cheers dude, this is really helpful, clear and consise