Hi All,
I have created a ActiveX ListBox of the type 'MultiSelectMulti'
The List Box is getting populated and also working fine w.r.t the
population of list box items and selections.
However, when I move the Excel Scroll Bar at the bottom of the excel sheet
towards the right, the List Box crea
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
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 have name list example
Name Moahn Mohan Kumar Mohan Doss Mathan Mathan Kumar Ashok ashok
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
I am trying to populate a list box with the results of a query. I have
created the following code, which only populates the first column of a two
column listbox. The items in MyArray are present for both bolumns.
Dim MyArray()
ReDim MyArray(mycount, 1)
usrGLDist.lstOutput.ColumnCount = 2
For
o: MS EXCEL AND VBA MACROS
> Sent: Thu, January 14, 2010 9:21:22 AM
> Subject: $$Excel-Macros$$ List Box
>
> Hi,
>
> I want to create a macro based on a number of selections from a
> listbox.
>
> I know that with 'single selection' you can return the number
Hi,
I want to create a macro based on a number of selections from a
listbox.
I know that with 'single selection' you can return the number of the
item using 'cell link' but I would like to be able to select a number
of items and return their respective codes?
Essentially I want to create a macro
23 matches
Mail list logo
