Ideally, I'd like to have this code streamlined. There will be a min of 1 and max of 5. Rather, not have the user input data unnecessarily. Maybe have an Inputbox where the user says how many values need to be entered...
Please Login or Register to view this content.
somethign like this maybe?
you could really streamline the code by using an array instead of 5 variables, but the user experiance would still be the same.Please Login or Register to view this content.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Not so worried about the user experience. Just trying to cut down on the code a bit.
I was thinking that it could be done where the "counter" dictated the cptX variable (where X is 1 to 5).
you can use an array like this
Please Login or Register to view this content.
Exactly what I was looking for. Used the same array for the Vlookup() based on cpt(i).
THANK YOU!!
no problem, glad to help.
could you please mark as solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks