Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am new to userforms. I have developed a spreadsheet that users will use to
request supplies. I have a userform that the user will enter an item number and quantity needed. This userform has two command buttons: (cmdbutton1)=ENTER and (cmdbutton2)=FINISHED. I tried to set up a Do-While loop w/ condition Do While CommandButton2 < True in an effort to allow user to enter items until FINISHED was clicked. After the user clicked ENTER, the code will place place the itemnum & qty in the appropriate cells. There will also be a check that the user entered a valid item number. Problem is I cannot get the loop to work for some reason. Right now, I can enter an item number and qty, then click ENTER. However, nothing happens. Is there a better way to do this. I may have to go to a For-Next loop in order to increase the value in the OFFSET command so that the cursor will advance to the next line. I also realize that I can just have a variable increase by 1 within the Do-While loop. Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help looping through textboxs on userform | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Userform Textboxes and Looping | Excel Programming | |||
looping through userform controls | Excel Programming | |||
looping through all checkbox's in a userform | Excel Programming |