Listbox Query and summation of cells not able to doing..

  • [INDENT]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.ClearListBox1.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.

    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? [/INDENT]

  • Re: Listbox Query and summation of cells not able to doing..

    As this seems to be a replacement for your other post (Require suggestion...) you should be aware that, as well as requiring accurate thread titles, duplicate posts are not allowed, your should have edited your title in that post. For future reference, to edit the title, click the 'Edit Post' link before the message. You will then see a 'Go advanced' button. Click that to allow editing the thread title.

    Your other post will be locked to ensure any replies are posted in this thread.

    Please read the rules (click here) and ensure you comply with them in future.

Participate now!

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