LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default Button using Form, Iteration and Input values

Gary,
Is "MsgBox" a command that pops up another default form?
because, What I would like to do is to use the "same Form" that is already
running
and it has all the input TextBoxes.
Thanks for your comments
coco
ps. could you suggest me a link that let me practice with different ways to
interact dynamically: Buttons, TextBoxes and 1 single "form"?. Thanks.


"Gary Keramidas" wrote:

i changed it a little to get it to work, but hopefully it will help you out

Private Sub BtnStart_Click()
Dim txtqty As Integer
Dim x As Integer
txtqty = 10
x = 0
If txtqty 0 Then
For i = 1 To txtqty
MsgBox txtqty

txtqty = txtqty - 1
Next
End If
End Sub

--


Gary


"coco" wrote in message
...
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:01 AM.

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"