Loading...

excel-macros@googlegroups.com

[Prev] Thread [Next]  |  [Prev] Date [Next]

Re: $$Excel-Macros$$ List Box Like Tally Software chandra sekaran Sat Feb 25 05:01:25 2012

sorry i am not attached my file


> Dear Maries & SAM & Abi
>
> Here with Attached   List Box like tally .xlxm   what i expected  it comes
> almost 90% which i attached   only thing its take time & E1  cell activate
> then my Listbox screen open Left cornor of window
>
> Point No. 2   This list Box should come Under Mydata  E1 cell   then ,
> Listbox should Resize based on My My Item add this should be appear in
> window screen .
>
> Point No. 3   if i have large data base  it will take so much time  plese
> sugguest to me  or modify my code once i type text box it wil come fast
>
>
>
> Pl  Advice me
>
> Thanks for support
>
> Regards
> Chandru
>
>
>
>
>
>
>
> On Wed, Feb 22, 2012 at 12:13 AM, chandra sekaran <[EMAIL PROTECTED]>wrote:
>
>> Dear Maries & SAM
>>
>> Lot of Thanks   Providing such a wonderful coding part,  i understand
>> form you,
>>
>> Once again Thanking  all
>> Have a Good day for you
>>
>> Regards
>> chandru
>>
>>
>>
>>
>>
>>
>> On Wed, Feb 22, 2012 at 12:05 AM, Maries <[EMAIL PROTECTED]> wrote:
>>
>>> Making Combo Box:
>>>
>>> http://www.screencast.com/t/69UdkpgmFv
>>>
>>>
>>> On Tue, Feb 21, 2012 at 10:34 PM, Maries <[EMAIL PROTECTED]> wrote:
>>>
>>>> Hi Chandru,
>>>>
>>>> If you want list box, only two option in Excel like Data Validation,
>>>> Combo Box.
>>>>
>>>> But both options, after selection only data will apply in cell value.
>>>>
>>>> Hence, there is no chance compare with database when typing or partial
>>>> string.
>>>>
>>>> I hope this clarify clear.
>>>>
>>>> Dear Group Friends, If you have any more ideas, Please share with us.
>>>>
>>>> Regards,
>>>>
>>>> MARIES.
>>>>
>>>>
>>>>
>>>> On Tue, Feb 21, 2012 at 10:11 PM, Sam Mathai Chacko <[EMAIL PROTECTED]
>>>> > wrote:
>>>>
>>>>> Boss, if you type L, all the customers starting with L is listed in
>>>>> the table below. Then why do you need a separate list in D1?
>>>>>
>>>>>
>>>>> On Tue, Feb 21, 2012 at 11:37 PM, chandra sekaran <
>>>>> [EMAIL PROTECTED]> wrote:
>>>>>
>>>>>>
>>>>>> hi  Sam,
>>>>>>
>>>>>> when i type D1 cell customer name  below data coming very perfect
>>>>>> but if type D1 cell  fist i donot know the Customer name when i D1 Cell
>>>>>> Activate then list of Customer name populate after that if type first
>>>>>> letter  like " L " then  in my Customer list  start with L  will shown
>>>>>> like that  it ready reference with  Tally List Box  sheet  pl....
>>>>>>
>>>>>> Regards
>>>>>> chandru
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Tue, Feb 21, 2012 at 11:31 PM, Sam Mathai Chacko <
>>>>>> [EMAIL PROTECTED]> wrote:
>>>>>>
>>>>>>> Use this in Cell A5 and drag down and across
>>>>>>>
>>>>>>>
>>>>>>> =IFERROR(INDEX(Data!A$3:A$82,SMALL(IF(LEFT(Data!$E$3:$E$82,LEN(MyOutput!$D$1))=MyOutput!$D$1,ROW(INDIRECT(("1:"&ROWS(Data!$E$3:$E$82)))),""),ROW()-ROW(MyOutput!A$4))),"")
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Sam Mathai Chacko
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Feb 21, 2012 at 8:17 PM, chandra sekaran <
>>>>>>> [EMAIL PROTECTED]> wrote:
>>>>>>>
>>>>>>>> hi  exell famly
>>>>>>>>
>>>>>>>> can any one give my logic  code  if possible, please...........
>>>>>>>>
>>>>>>>> chandru
>>>>>>>>
>>>>>>>>  On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran <
>>>>>>>> [EMAIL PROTECTED]> wrote:
>>>>>>>>
>>>>>>>>> Dear Maries ,
>>>>>>>>>
>>>>>>>>> First of i would thanks for valuable effort , but what i expected
>>>>>>>>> like this only if Activate D1 Cell then Immdiataly like below Unique
>>>>>>>>> Customer will shown below on the D1 Cell , than i Enter  L    letter
>>>>>>>>> than Start with L only Bold & selected  like that .
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>    *Cutomer  Name* Lotus  ABC COMPAY      Adako Tarim    Forward
>>>>>>>>> International    HAND ASSO    *LOTUS 123 PVT* **    *LOTUS PVT* **
>>>>>>>>>    MURUGA COPANY LTD    Reckitt Benckiser    SCJ Argentina
>>>>>>>>> VAPCO     XYZ  LTD
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Thanks for your help
>>>>>>>>>
>>>>>>>>> Regards
>>>>>>>>> chandru
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Mon, Feb 20, 2012 at 8:28 PM, Maries <[EMAIL PROTECTED]>wrote:
>>>>>>>>>
>>>>>>>>>> Hi,
>>>>>>>>>>
>>>>>>>>>> I got your logic. Check the attachment.
>>>>>>>>>>
>>>>>>>>>> Type your text in cell D1 & Enter. It will give answer.
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>>
>>>>>>>>>> MARIES.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran <
>>>>>>>>>> [EMAIL PROTECTED]> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi maries,
>>>>>>>>>>>
>>>>>>>>>>> thanks for your Reply,
>>>>>>>>>>>
>>>>>>>>>>> MyOutput Sheet  D1 Activate  then  My List of Cutomer  may
>>>>>>>>>>> shwon  seperate  list box or Below D1 Cell   there itself we want 
>>>>>>>>>>> to select
>>>>>>>>>>> or  like  sheet Name  Tally List box like that  if possible  [ 
>>>>>>>>>>> First time i
>>>>>>>>>>> do not know what are the customer are there in my Data  so once D1 
>>>>>>>>>>> is
>>>>>>>>>>> Activate  Unique My Cutomer will display   if possible  please ....
>>>>>>>>>>>
>>>>>>>>>>> Regards
>>>>>>>>>>> chandru
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Mon, Feb 20, 2012 at 5:54 PM, Maries <[EMAIL PROTECTED]>wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hi,
>>>>>>>>>>>>
>>>>>>>>>>>> Find the attached file. If you type first name in search cell,
>>>>>>>>>>>> respective datas will show below.
>>>>>>>>>>>>
>>>>>>>>>>>> Regards,
>>>>>>>>>>>>
>>>>>>>>>>>> MARIES.
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran <
>>>>>>>>>>>> [EMAIL PROTECTED]> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Dear all
>>>>>>>>>>>>> Here with attached  List Box like Tally   is this possible
>>>>>>>>>>>>> with excel    once  Active  List box or Cell   shown under  all 
>>>>>>>>>>>>> name  after
>>>>>>>>>>>>> enter first letter  than showing start with all names  like that
>>>>>>>>>>>>> Advance Thanks for all
>>>>>>>>>>>>>
>>>>>>>>>>>>> Regards
>>>>>>>>>>>>> chandru
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> --
>>>>>>>>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>>>>>>>>
>>>>>>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles,
>>>>>>>>>>>>> like Please Help, Urgent, Need Help, Formula Problem, Code 
>>>>>>>>>>>>> Problem, and
>>>>>>>>>>>>> Need Advice will not get quick attention or may not be answered.
>>>>>>>>>>>>>
>>>>>>>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>>>>>>>
>>>>>>>>>>>>> 3) Don't post questions regarding breaking or bypassing any
>>>>>>>>>>>>> security measure.
>>>>>>>>>>>>>
>>>>>>>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>>>>>>>
>>>>>>>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this
>>>>>>>>>>>>> forum in signatures are prohibited.
>>>>>>>>>>>>>
>>>>>>>>>>>>> NOTE : Don't ever post personal or confidential data in a
>>>>>>>>>>>>> workbook. Forum owners and members are not responsible for any 
>>>>>>>>>>>>> loss.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>>>>>>>>> To post to this group, send email to
>>>>>>>>>>>>> [EMAIL PROTECTED]
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>   --
>>>>>>>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>>>>>>>
>>>>>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles,
>>>>>>>>>>>> like Please Help, Urgent, Need Help, Formula Problem, Code 
>>>>>>>>>>>> Problem, and
>>>>>>>>>>>> Need Advice will not get quick attention or may not be answered.
>>>>>>>>>>>>
>>>>>>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>>>>>>
>>>>>>>>>>>> 3) Don't post questions regarding breaking or bypassing any
>>>>>>>>>>>> security measure.
>>>>>>>>>>>>
>>>>>>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>>>>>>
>>>>>>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this
>>>>>>>>>>>> forum in signatures are prohibited.
>>>>>>>>>>>>
>>>>>>>>>>>> NOTE : Don't ever post personal or confidential data in a
>>>>>>>>>>>> workbook. Forum owners and members are not responsible for any 
>>>>>>>>>>>> loss.
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>>>>>>>> To post to this group, send email to
>>>>>>>>>>>> [EMAIL PROTECTED]
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>>>>>>
>>>>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
>>>>>>>>>>> Need
>>>>>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>>>>>>
>>>>>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>>>>>
>>>>>>>>>>> 3) Don't post questions regarding breaking or bypassing any
>>>>>>>>>>> security measure.
>>>>>>>>>>>
>>>>>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>>>>>
>>>>>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this
>>>>>>>>>>> forum in signatures are prohibited.
>>>>>>>>>>>
>>>>>>>>>>> NOTE : Don't ever post personal or confidential data in a
>>>>>>>>>>> workbook. Forum owners and members are not responsible for any loss.
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>>>>>>> To post to this group, send email to
>>>>>>>>>>> [EMAIL PROTECTED]
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>   --
>>>>>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>>>>>
>>>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
>>>>>>>>>> Need
>>>>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>>>>>
>>>>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>>>>
>>>>>>>>>> 3) Don't post questions regarding breaking or bypassing any
>>>>>>>>>> security measure.
>>>>>>>>>>
>>>>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>>>>
>>>>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this
>>>>>>>>>> forum in signatures are prohibited.
>>>>>>>>>>
>>>>>>>>>> NOTE : Don't ever post personal or confidential data in a
>>>>>>>>>> workbook. Forum owners and members are not responsible for any loss.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>>>>>> To post to this group, send email to
>>>>>>>>>> [EMAIL PROTECTED]
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>> --
>>>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>>>
>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>>>
>>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>>
>>>>>>>> 3) Don't post questions regarding breaking or bypassing any
>>>>>>>> security measure.
>>>>>>>>
>>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>>
>>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this
>>>>>>>> forum in signatures are prohibited.
>>>>>>>>
>>>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>>>> Forum owners and members are not responsible for any loss.
>>>>>>>>
>>>>>>>>
>>>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>>>> To post to this group, send email to [EMAIL PROTECTED]
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Sam Mathai Chacko
>>>>>>>
>>>>>>> --
>>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>>
>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>>
>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>
>>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>>> measure.
>>>>>>>
>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>
>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>>>> in signatures are prohibited.
>>>>>>>
>>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>>> Forum owners and members are not responsible for any loss.
>>>>>>>
>>>>>>>
>>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>>> To post to this group, send email to [EMAIL PROTECTED]
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>>
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>
>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>>> in signatures are prohibited.
>>>>>>
>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>> Forum owners and members are not responsible for any loss.
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>> To post to this group, send email to [EMAIL PROTECTED]
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Sam Mathai Chacko
>>>>>
>>>>> --
>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>>
>>>>> 2) Don't post a question in the thread of another member.
>>>>>
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>>
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>
>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>> in signatures are prohibited.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> Forum owners and members are not responsible for any loss.
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------------------------------
>>>>> To post to this group, send email to [EMAIL PROTECTED]
>>>>>
>>>>
>>>>
>>>   --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> ------------------------------------------------------------------------------------------------------
>>> To post to this group, send email to [EMAIL PROTECTED]
>>>
>>
>>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to [EMAIL PROTECTED]