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