Anybody?
Hello,
I have some code that I would like to make faster, but I do not know how. The code is in the excel sheet. Please help me !
1) Init combo boxes
2) Select Weeks
3) Select cycles
/B
Anybody?
Hello,
I have some code that I would like to make faster, but I do not know how. The code is in the excel sheet. Please help me !
1) Init combo boxes
2) Select Weeks
3) Select cycles
/B
Last edited by Beginner77; 07-17-2020 at 02:59 AM.
For starters...
Or initiate in workbook Open EventPlease Login or Register to view this content.
Not sure what you mean by other requests...perhaps you should explain in detail what you are wanting to achieve....
Last edited by sintek; 07-17-2020 at 07:06 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thanks. It is the other code that takes quite a long time to execute. I would like to run the code faster. That is my goal.
Cheers B
As per post 2...
perhaps you should explain in detail what you are wanting to achieve....
This will make us simplify...Your code is too complicated to follow with all the named variables...Also there is no sample data with before | after requirement...
I would like to have it running faster, say under 1 second if possible.
Have you tried the code? If you try you see that the code is not difficult to understand. I got three named area. Not so many. If you think you can not help, do do not need to answer.
Cheers
Last edited by Beginner77; 07-17-2020 at 08:09 AM.
I can help...If you think you can not help, do do not need to answer.
However, I would prefer you to explain in detail what you are wanting to achieve instead of having to decipher your code...Which in itself is not simplistic...
I have requested an explanation 3 times already...
Other members are going to ask the same...SEE TOP YELLOW BANNER....
If you are not prepared to explain then I am not prepared to help...
Don't want to have to figure out this...
Untitled.png
Last edited by sintek; 07-17-2020 at 08:25 AM.
How difficult would it have been for you to say...
"I want to create Templates from sheet2 dependent on selections made"
Perhaps someone else can simplify...Can only do 2 seconds for 12 X 12
Please Login or Register to view this content.
Last edited by sintek; 07-17-2020 at 10:49 AM.
@Beginner77, you are the one seeking help.I would like to make faster, but I do not know how
Re-read your second quote, rather a poor choice of wording towards someone that has offered you help.If you think you can not help, do do not need to answer.
@sintek is being polite about a 'dogs breakfast'.
You may find further down the road it would be prudent to get rid of 'merged cells' if you expect VBA to be stable.
torachan.
I just realized my code does not provide the correct output...I guess your explanation was not clear enough...
Perhaps this...
Please Login or Register to view this content.
Last edited by sintek; 07-17-2020 at 12:30 PM. Reason: Spacing....
Hi Beginner77
OK, here's my version attached.
It can be made tidier, but I spent the time learning a couple of Swedish words instead.
On my system it was pretty fast.
zeddy
Just for the fun of it...Without Merged cells etc etc...
Rule 1 of Excel...Do not use merged cells...Just causes havoc with VBA...See Horizontal Alignment as alternative...
Grid 12 x 12...Under a second....
For future reference...We do not request information "just to be funny"...It is in order to understand your requirement so as to
provide the most simplistic code possible for your scenario...
Be more forthcoming in the future...
I am certain other members will also offer more expedient solutions...
Thank you all for the help! Very appreciated!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
For future reference...As a courtesy...If you want to thank Members...You can click Star Left of Post...Add Reputation...
Hi
I was still working on a faster method.
I adapted sinteks file with my updates and managed to get the 12x12 grid in 0.016 sec (on Dell i7 laptop)
Could probably get it to 0.012 sec with further changes but then boss said stop doing that.
For automation, if things take less than 2 seconds, Users are generally happy. Anything longer than that, they start twiddling their thumbs or go for a coffee.
zeddy
--------------------------
@sintek
Re: "Rule 1 of Excel...Do not use merged cells"
You forgot Rule #2
Rule #2:
Read Rule #1 again.
Experience trumps academics every day of the week and twice on Sunday.
Three years for a reply to my post!
That is even more impressive than the slow pace of life I'm having on my tropical vacation.
It's rum o'clock now so it's back to the beach for me.
Best regards
zeddy
I promise (again)
Next time I check the dates a little closer.
Have a tasty toddy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks