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.Clear
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?

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.........