Hi everyone! I have Userform 2, that inputs data onto Userform 1's textbox after clicking submit. I am wondering how i can list the data in numerical order after each entry. An example would look like this:
1. Entry number 1 from Userform 2
2. Entry number 2 from Userform 2
3. Entry number 3 from Userform 2
I cannot figure out how to acheive this using VBA. Would anyone have any suggestions?
here is an example image
Capture.PNG
Hi, can you be more explicit?
How about attaching a sample dummy data file with what you have and what you want to achieve.
What numerical order? If you did not change the names of the text boxes they will automatically increment by one TextBox1, TextBox2 etc.
Look up using Controls in Userforms (Google) and you'll find hints, but for your question and if you want hel I suggest a sample file, don't expect us ti crate a file with a userform we think is like the one you have.
Assumptions are deadly
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks