Consulting

Results 1 to 4 of 4

Thread: Userfom to count items and show clicks and percentage vs target

  1. #1
    VBAX Regular
    Joined
    Dec 2017
    Posts
    11
    Location

    Userfom to count items and show clicks and percentage vs target

    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?
    C372E1B2-0CD2-46CF-8316-81180B966F73.jpg

    item control.xlsm

  2. #2
    VBAX Regular
    Joined
    Dec 2017
    Posts
    11
    Location
    Any help please?

  3. #3
    VBAX Expert
    Joined
    May 2016
    Posts
    604
    Location
    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.

  4. #4
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location
    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) & "."
    Semper in excretia sumus; solum profundum variat.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •