Please help.
I was trying to make input user in vb.
Example:
User form should ask me for item number and than for quantity for that item and than loop back for entering another item number.
I wonder can this be made without command buttons becouse I just wanted to put close button for exit.
A B
ITEMNO: QUANTITY
1 01 123
2 02 454
3 03 112
4
What user action do you want to trigger the placement of the values onto the sheet?
If you miskey an entry, how do you want to edit that?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I think you are going to have to use a separate button for data entry if you need to make several entries before you close the userForm.
Otherwise either the Control source cell value or the VBA UserForm.textBox.Value will just keep cycling with each new value you put in.
But Hey! thats only two buttons
John
It doesnt realy matters if I have aditional button to add entry but i dont want form to close i just want cursor again in itemnumber field.
Can you tell me how to do this form?
Are you using a UserForm or a form created on the sheet?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Preferaby Userform
Perhaps this would work
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks