Questions & Answers for: Microsoft Office loop setting

...is, instead of writing 30 lines to retrive the 30 values from the recordset, how can I write a FOR loop and get the values in least lines of code. For example: For iCount = 1 To 30 iCount = 1 ...

...setting up a sub routine to set/reset the values on your form. Then just run the sub routine before you open or enter the form. Private Sub resetForm() 'formname.itemname = value UserForm1.Label1 = ...

...to use in excel 2000 which simulates the countifs function completely You need to write a for..next loop that loops through the range you would set in the COUNTIF function. In each iteration of that ...

...gt; 3 Then MyNumber = Left(MyNumber, Len(MyNumber) - 3) Else MyNumber = "" End If Count = Count + 1 Loop Select Case Dollars Case "" Dollars = "No Dollars" Case "One" Dollars = "One Dollar" Case Else ...