LinkBack URL
About LinkBacks
Hello,
I hava a problem
I would like the values on the label to be updated.
Everything in the attachment
Please help.
Hello,
I hava a problem
I would like the values on the label to be updated.
Everything in the attachment
Please help.
Try this code
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Thank you, but something does not work
Try the attached.
YasserKhalil's code does work if it is actually in the right place
Form first fellover because insufficient labels to receive data requested.
Press 'SHOW FORM' button and all will be revealed.
torachan.
Thanks, but I made a mistake :/
This code must add up to 8 characters from the left.Please Login or Register to view this content.
And the last problem, after adding a new value, the label does not update.
Sorry for the confusion.
It is not possible for the label to update beyond what is in sheet "A2"
How are you updating the data in "A2"
Copies manually to A2.
Textbox.1 to A1 lastrow.
It's not a big problem like this This ... code must add up to 8 characters from the left.
To view just the leading eight characters alter your code
from
toPlease Login or Register to view this content.
also labels 8 & 9 are reversed on the formPlease Login or Register to view this content.
HOWEVER:- Garbage in, Garbage Out.
You have 10 entries on "A1" with a count of 12 on "A2"
Manual entry onto "A2" is not a good idea.
Perhaps time to re-visit the concept ?
Thanks, but I do not mean it.
A2 :
P3/1231B
A1 :
P3/1231B 13
P3/1231B 14
P3/1231B 15
P3/1231B 16
Left on A1 no A2.
Score is : P3/1231B 4/4.
And display no last 9 in A2, but last 9 A1.
I described everything in the attachment
Last edited by Bolo19911; 02-02-2019 at 12:08 PM.
Capture.JPG
I have pasted data from "A1" alongside data on "A2"
Sorted and grouped.
Please explain what the numbers in column "B" relate too.
They do not appear to have any logical relationship to column "A" or "D"
Column B = general amount.
e.g - P8/0101A - total value = 11
Column D are scans, because can be them max 11. In this case 2. = 2/11.
When they appear new scans e.g - P8/0101A 13, value = 3/11 and so on.
Column A - contract number
Fixed values = A And B
Variable values = D
Last edited by Bolo19911; 02-02-2019 at 02:57 PM.
For starters.
Please Login or Register to view this content.
Last edited by bakerman2; 02-02-2019 at 11:31 PM.
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.
Bakerman2, perfect !!!
Thanks.
Glad to help and thanks for rep+.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
bakerman2,
I have one question
CURRENTLY - FIRST 10 ON A2
EXPECTED - LAST 10 ON A1
CAN BE ?
It's possible but how to know how many items for each value.
Please Login or Register to view this content.
Maybe 1 label with function Multiline ?
It will not be easier ?
Or reference to the control ... separately e.g :
10Please Login or Register to view this content.
9Please Login or Register to view this content.
8Please Login or Register to view this content.
e.g
Last edited by Bolo19911; 02-03-2019 at 10:30 AM.
What I mean is on sheet A2 whe have our numbers in A-Column and the number of items in B-Column.
If we extract the last 10 on A1 how are we to know how many items for each number are needed to make our fraction. eg 1/2 or 2/10 or 3/7 ?
can be displayed on 1 label ?
this macro can stay :
in this way I see the problem in :Please Login or Register to view this content.
"i" depending on the label.Please Login or Register to view this content.
I would like to one label on multiline + the above macro (tst).
"i" the range is the entire column - "A" in A2
I do not see any other way
I'd go for a Listbox instead of a multiline Label because that's easier to handle.
But first you need to answer my question before we can proceed.
In all your previous examples the numbers on Sheet A2 Column A were predefined along with their general amount in Column B.
Now you want to retrieve the last 10 numbers on Sheet A1 and put them in Column A of Sheet A2. Were do we retrieve the general amount for these numbers in Column B ?????
Edit: Added example file with a ListBox.
Last edited by bakerman2; 02-03-2019 at 09:28 PM.
Thanks for reply,it's better but.
Well, we need to get the general value from column B.
He is almost good, but ,I want to display only 10 current columns from A1, because the values are variable, they can be 100,000.
Why ?
These are scans from the scanner
Sheet A2 is only for comparison with the last 10 contracts with A1.
Finaly, thank you.
This should cover it all.
Please Login or Register to view this content.
Perfect
Glad we got it sorted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks