View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Coco Coco is offline
external usenet poster
 
Posts: 34
Default Button using Form, Iteration and Input values

Hello everybody
I have a simple question about Buttons in a Form doing a loop; my question
is how can I implement or what this program needs because I know a little
bit of excel progamming.

I want to run this Form(that has 3 buttons, Start,Next,Close), after
entering values in the following TextBoxes:TxtQty and TxtValue, and pressing
"Start", the program will let me input VALUES for Txtvalue, after pressing
"Next" (TxtQty-1) times. After finishing the iteration will show me the
TxtResults in another TextBox.

Thanks for your advice.

Coco

Private Sub BtnStart_Click()
Dim x As Integer
x = 0
If TxtQty.Text 0 Then
For i = 1 To TxtQty.Text
TxtResult.Text = TxtResult.Text + TxtValue.Text

*** what function has to be added to pause the loop and wait for the next
TxtValue ***

Next
End If
End Sub