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

When using Excel's VBA, or visual basic editor, create a code that runs when a worksheet is activated and use a do-while loop that has an end condition. Use a do-while loop in Excel VBA with tips from a software developer in this free video on using Microsoft Excel.

Expert: Dave Andrews
Contact: www.daveandrews.org
Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department.
Filmmaker: Tim Brown

Category:

Science & Technology

Tags:

• Internet
• software
• computer programs
• computer software
• Microsoft
• Excel
• SQL
• Microsoft Excel
• Microsoft SQL
• email
• online
• Web sites
• HTML
• databases
• MYSQL
• FTP

[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