none
Excel VBA userform, Output to label field. RRS feed

  • Question

  • Hi, I have a countifs formula in several cells to count the OK and the NOK products for a customer.  I am trying to simplify the worksheet by only displaying the requested customer.

    My question is: If I have a column (A) of customer names and a column of products in (B) as Ok or NOK, How could I code this in a VBA user form?

    The user form has 3 customer names each with a optionbutton and 2 output labels, one for the count of OK and NOK.

    Thanks for the help.

    Monday, October 31, 2016 8:25 PM

All replies

  • Hi,

    It is possible to do it in Excel VBA form, but is there any specific need why do you want to do it in VBA form?

    I would recommend you to make a summary sheet within the workbook and you can create the same in excel sheet itself just by using the formulas. 

    If you can share your sample sheet, i would be able to share a sample summary sheet using formula.


    Vish Mishra

    Tuesday, November 1, 2016 12:06 PM