Require suggestion...

  • Dear All,

    I am totally new vba.
    I have some problems in excel vba. I tryed i lot that is not getting proper solution.
    Hope you all, will provide your expert solutions.

    Problem 1. - Listbox contain 2 values.
    I coded in this part.

    Private Sub Worksheet_Activate()
    ListBox1.AddItem "A"
    ListBox1.AddItem "B"
    End Sub

    Whenever i am try to open newly, listbox items not displayed. So i have to go "alt-11" option that is in coding part. Run this perticular part. and then only this items listed.

    Is there any option, when open the sheet, values also dislpys?

    Problem 2 - Is a big problem.:crying:

    range c6:range c112 contain some values.
    c6 = 3.5kw
    c7 = 5.5kw
    c8 = 15.6kw
    c9 = 25.5kw
    and on.

    My problem is, i want sum of all in range c115.
    but when this addtion doing, this string "kw" is not giving the value.

    So, is there any solution for this, even i require "kw" in range c115 after the addition.

    Can anyone please solve the problem?

  • Re: Require suggestion...

    Welcome on board.
    Require suggestion is certainly what everyone asking questions in this forum is looking for
    Title is very important as it is used for searching information in the forum.
    Please review it to make it more obvious.

    Triumph without peril brings no glory: Just try

  • Query on listbox and summation of cells

    Dear Sir, (Message Board)

    Thank You for your reply.
    Yes, It is important to make a proper subject, that is my mistake.

    Can u please give me the that how i can post a new thread. I am not getting this.
    Even this link...i dont know where i clicked.

    i got it.........

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!