Hi everybody. I am trying to create a loop to get some values from a sheet and put it in a textbox in another sheet.
I surely misunderstood something very basic about loops.... fist try and the loop is not working and give me error like type mismatch.
Have a look at the example please... and tell me what is so very wrong with it!
Thanks
Hi,
What's the ultimate end game here? Can you explain in a narrative since there may be better ways of achieving what you want. Loops should always be a last resort since with large ranges they can seriously affect the time taken to achieve the task.
Don't tell us you want to fill the text box tell us what do you do with the information in the text box and how do you use it?
To answer your specific question the following code is probably what you want
If the data sheet 'Game' was in a different layout so that it was a normalised 2 dimensional range with columns for
Please Login or Register to view this content.
Date
Game
Un.
Custo/Un.
then you'd be able to use Pivot Tables for all sorts of analysis and avoid macros or even formulae.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard, thanks for aanswer me.
The text box content is just for reading, and later there will be a couple of math operations with the prices values.
I would like to avoid to show the database to user, instead I thought to use a textbox.
This way i can have two textboxes on the main page with different data from a second data sheet and visually compare.
I do not know another way to have two separate scroll-able windows/textxboxes in the same page....
I changed the lines you indicated but still... I only get two zeros in the textbox...
Hi @Alex Piotto
You can give a try to this code
Please Login or Register to view this content.
Last edited by vichopalacios; 04-11-2018 at 10:14 AM.
Barriers are there for those who don't want to dream
Hi vichopalacios
thanks for your time and the dedication.
Your code works fine.
What I unfortunately noticed is that the tabs distances get messy.... and i imagine it is impossible to put the contents of the textbox organized by column as in an activex listbox.
So i tried an activex listbox... to discover that the very moment i try to use the mouse wheel to scroll, it makes excel crash.
The other listbox, the excel one, do not scroll but at list do not crash.
It is possible to have columns of data organized in a standard listbox as in an activex one?
The all purpose of the code is, in the end, to have two lists of items visible at the same time on the sheet, with the possibility to scroll them separately without scrolling the page.
This way the user can watch and visually compare two lists...
Any idea?
Instead of placing objects on the worksheet try creating a user form and putting your objects there instead
- in my experience that gives fewer problems
Last edited by kev_; 04-11-2018 at 12:09 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
You are right, kev.
In fact i just inserted a listbox-x into a userform and it is not crashing... nor scrolling as a matter of fact.
I could use a big form and accommodate the two listboxes in there, but there is the border and the close button of the userform that are not required... any sugestion about it?
Make everything smaller - font sizes, box sizes and fit in more data
You could use 2 userforms and toggle between the 2 to give you more space
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks