Please help me to enhance my userform and the coding.
Please help me to enhance my userform and the coding.
Last edited by 323100N; 05-08-2018 at 03:29 AM.
any help because my userform looks like very loaded
Last edited by 323100N; 05-08-2018 at 03:28 AM.
is it possible guys? please help. thank you
Last edited by 323100N; 05-08-2018 at 03:31 AM.
Hi guys, I think my tool is kind a manual still, I think I didn' eliminate the manual keying, Is there any way that I can change the userform in more automated one? Thank you
Use loops to read and write, for instance to empty your TB's
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Which part should i include that code? thank you
Replace your Reset/clear button code withj the one I gave you.
since the data is put and load with sequence,
it is good to use a loop to do all the things.
bakermans' code is totally replace the Sub CommandButton3_Click()
the remain code, can apply similar things as well.
Tips,
Cells(1,1) also refer to Range("A1")
for example:
Please Login or Register to view this content.
Last edited by BoredWorker; 05-10-2018 at 05:09 AM.
Hope you can learn every time you visit here.
If you still confuse on how it work, kindly ask or go to
i) Formula - Formula (Ribbon) > Formula Auditing (Section) > Evaluate Formula > Evaluate; or
ii) VBA/Code - Click F8 to see how it work step by step.
It it take care of your question, Please:
Mark tread as [Solved] [Thread Tools->Mark thread as Solved];and
Click *Add Reputation to thank anyone solved your question.
Oh my I still need to learn more about coding, I think it will takes time to learn everything. Thank you i'll try those suggestions.
Last edited by 323100N; 05-10-2018 at 05:22 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks