Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
How can I have an input form to add a random no. to each input entry? | Excel Discussion (Misc queries) | |||
input form | Excel Programming | |||
Input box/form | Excel Programming | |||
Command Button vs Form Button | Excel Programming |