Posts by PANKAJ UTEKAR

ok, let me create sample document and then I will post

Yes, this is for word. Activedocument is for active word document referring to.

Basically I'm trying to find index for particular text (so there are many text header's). Once I found index for text whichever I'm looking for then wanted to copy its corresponding value with another word document by finding the same text header..

Hope I'm able to clear what I'm trying to do.. Additionally kindly guide where to post word vba question and could you share any code concerning my above query..

Thanks..!!

Hi All,

could anyone correct me on below code- I'm getting error on .select

Windows("Sam file").Activate
ActiveDocument.Indexes(122).select

[INDENT][INDENT]Dear All Sir,

I have 2 problems. One with listbox query and the second with summation of cells.

1] query -
Listbox1 contain 2 values -A and B

Code:
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?

2] query -

In range c6:range c112 contain some values. for eg.-
c6 = 3.5kw
c7 = 5.5kw
c8 = 15.6kw
c9 = 25.5kw
and so 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.

I require best suggestion for above. So can anyone suggest for me?
[/INDENT][/INDENT]

[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.
Code:
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]

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

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?

Re: new record on new row line?

Can any one know d solution for following case?

Re: new record on new row line?

I m suprising with your knowledge !
Thank You for quick reply.

i have using 2 sheets wherein-
---In 1st sheet, e4 to j4 got the value by clicking the cmdbuton.
---D 2nd sheet only contains values, that is absolutly right.

and when again i will click on cmdbuton then the other records goes to e5 to j5 and for every new record to e6....e7 and on.

For this i require code.

Private Sub CommandButton4_Click()
Range("e4").Select
ActiveCell.FormulaR1C1 = Range("c4")


Range("f4").Select
ActiveCell.FormulaR1C1 = Range("c13")


Range("g4").Select
ActiveCell.FormulaR1C1 = Range("c22")


Range("h4").Select
ActiveCell.FormulaR1C1 = Range("c24")


Range("i4").Select
ActiveCell.FormulaR1C1 = Range("c26")


Range("j4").Select
ActiveCell.FormulaR1C1 = Range("c27")
End Sub

In above code, i have saved the record in the first row only. I didnt understand that, after added one record, how do i added every new record on every new row line.