PDA

View Full Version : Userfom to count items and show clicks and percentage vs target



gotid
01-17-2018, 04:20 PM
Hello,
I have done a userform to count some items that I have in stock.
I would like to have a userform that could count each item and that number would appear on the the textbox.
The other values that appeared in the image, total items, percentage vs target, etc would also appear on the frame.
Is it possible?
21380

21382

gotid
01-19-2018, 01:48 AM
Any help please?

offthelip
01-19-2018, 08:22 AM
I had a look at your problem but I cannot understand your requirement at all. for example, you state :

I have done a userform to count some items that I have in stock.
However looking at the code in you worksheet, it doesn't seem to count anything. So to get help you need to tell us where the data is, and how it is arranged and what you want to count, then we might be able to help.

paulked
01-21-2018, 11:04 AM
If you want text in the frames then you just put a Label in them and use something like:



Label1.Caption = "This is " & Sheet1.Cells(x, y) & " of " & Sheet1.Cells(x + 1, y + 1) & "."