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
12 matches
Mail list logo
