s still a compatibility issue,
just post back :)
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Monday, February 27, 2012 9:03 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ List Box Like Tally Soft
For the position, use
Private Sub UserForm_Activate()
Me.Top = 150
Me.Left = 250
End Sub
adjust it based on your requirement... to make it dynamic for any excel
application or screen size, you'll have to use API
For ISERROR problem in Excel 2003, use
=IF(ISERR(INDEX(Data!$A$3:$A$640,SMA
Dear all
this file not working with excel2003 iserror function
regards
chandru
On Mon, Feb 20, 2012 at 8:28 PM, Maries 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 a
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 ,
Li
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 wrote:
> Making Combo Box:
>
> http://www.screencast.com/t/69UdkpgmFv
>
>
> On Tue,
Making Combo Box:
http://www.screencast.com/t/69UdkpgmFv
On Tue, Feb 21, 2012 at 10:34 PM, Maries 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
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
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 wrote:
>
> hi Sam,
>
> when i type D1 cell customer name below data coming very perfect but if
> type D1 cell fist
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 tha
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 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
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 Lletter than Start
with L only Bold & selected like that .
*Cutomer Name* Lotus
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 Dat
Maries,
That was awesome!! I was asking myself what if there is a need to
expand the range? So I am wondering if using a range name will do the
trick i.e update the range : Formula>>>name manager ( I am using
excel 2010).I've tried it but it didn't work.
Please advise.
Regards
On Feb 17, 5:39 am
Hi Maries,
Thats really great..Thank you..
On Fri, Feb 17, 2012 at 3:10 PM, Maries wrote:
> Hi Shaik,
>
> Check this link...
>
> http://www.screencast.com/t/69UdkpgmFv
>
> Regards,
>
> MARIES.
>
>
> On Thu, Feb 16, 2012 at 3:05 PM, Shaik Waheed wrote:
>
>> Hi Maries,
>> Can u tell me how
Hi Shaik,
Check this link...
http://www.screencast.com/t/69UdkpgmFv
Regards,
MARIES.
On Thu, Feb 16, 2012 at 3:05 PM, Shaik Waheed wrote:
> Hi Maries,
> Can u tell me how did u do that..
>
> On Thu, Feb 16, 2012 at 3:25 PM, Maries wrote:
>
>> Find the attachments..
>>
>>
>> On Thu, Feb 16,
Hi Maries,
Can u tell me how did u do that..
On Thu, Feb 16, 2012 at 3:25 PM, Maries wrote:
> Find the attachments..
>
>
> On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran
> wrote:
>
>> Hi ,
>>
>> Here with attchaed file we need smal macro when i type first
>> Letter than shown start wit
Find the attachments..
On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran wrote:
> Hi ,
>
> Here with attchaed file we need smal macro when i type first Letter
> than shown start with first if type second letter then based on my
> cretria shown all list can any one help me
>
> Like i ha
Works for me. Put a break point onto the last line and check the array data.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Richard
Envoyé : lundi 13 juin 2011 22:14
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ List Box
I am try
It's been a while since I've done it, so I would have to locate
an old file, or create it from scratch, but basically:
You loop through the items in the list and check the "selected"
property (I think) of each item.
Paul
- Original Message
> From: Nush
> To: MS EXCEL AND VBA MACROS
19 matches
Mail list logo
