Hi Experts
still waiting for solution
Divaker
On Tue, Jun 26, 2012 at 8:25 PM, Divaker Pandey wrote:
> but it will lock modification in list through vba.
>
> Divker
>
>
> On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI
> wrote:
>
>> Hi Divaker,
>>
>> I have created a name range "List_Matters"
but it will lock modification in list through vba.
Divker
On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI wrote:
> Hi Divaker,
>
> I have created a name range "List_Matters",
>
> We called it through below coding..
>
> Sheet1.lstLookup.ListFillRange = "List_Matters"
>
> and in Property Boxt i ha
Hi Divaker,
I have created a name range "List_Matters",
We called it through below coding..
Sheet1.lstLookup.ListFillRange = "List_Matters"
and in Property Boxt i have marked columnHeads as true.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On T
Noorain,
It will be helpful if you give me VBA code to add header column.
I think listbox used header on the base of assigned range on
ListFillRange properties.
But it is not make sense to solve my query, because i have 72000 rows, and
take selected rows form them. i could not want write it aga
Hi Lalit,
I want to list out all company which string match in any column(available
data)
Divaker
On Tue, Jun 26, 2012 at 8:03 PM, Divaker Pandey wrote:
> Thanks Noorain, i want to list out all company details which match on
> entered value in textbox.
>
> By the way how you added header in
Thanks Noorain, i want to list out all company details which match on
entered value in textbox.
By the way how you added header in listbox.
Please tell me steps.
Thanks.
Divaker
On Tue, Jun 26, 2012 at 7:28 PM, ╰» ℓαℓιт мσαнη wrote:
> Hi Divaker,
>
> You query is not cleary mentioned can u pl
Hi Divaker,
You query is not cleary mentioned can u please share a file with the
full description so that we can help u as soon as possible
Regards,
Lalit Mohan
On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey wrote:
> Hi Experts,
>
> Still waiting for your response.
>
> Divaker
>
>
> On Tue, J
Hi Experts,
Still waiting for your response.
Divaker
On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey wrote:
> Hi Noorain & Experts,
>
> Thanks for respond. please find attached file.
> on tab sheet1 there is two activeX control
>
> 1. Textbox -txtLookup
> 2. ListBox - lstLookup
>
> if user cha
Dear Divaker,
Please share your Activelistbox with group.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey wrote:
> Hi Ayush,
>
> I want to add header column text in Activelistbox through vba.
>
> Can you
