LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
input in number form is being multiplied by 1000 when i input. jweinograd Excel Discussion (Misc queries) 4 April 16th 07 11:18 PM
How can I have an input form to add a random no. to each input entry? saziz Excel Discussion (Misc queries) 2 January 25th 06 11:46 PM
input form alexanderd[_7_] Excel Programming 2 May 31st 04 08:01 AM
Input box/form acsell Excel Programming 11 October 9th 03 11:22 AM
Command Button vs Form Button T K Excel Programming 4 August 26th 03 07:26 PM


All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"