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
[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 Software
hi all
I thank Marrie, SAM he helped lot thing with out him i am not get this
.
once again
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 ,
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 duraichan...@gmail.comwrote:
Dear Maries ,
First of i would thanks for valuable effort , but what i expected like
this only if Activate D1 Cell then
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
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 duraichan...@gmail.comwrote:
hi Sam,
when i type D1 cell customer name below data coming very perfect but if
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
Making Combo Box:
http://www.screencast.com/t/69UdkpgmFv
On Tue, Feb 21, 2012 at 10:34 PM, Maries talk2mar...@gmail.com 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.
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 talk2mar...@gmail.com wrote:
Making Combo Box:
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
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 Shaik,
Check this link...
http://www.screencast.com/t/69UdkpgmFv
Regards,
MARIES.
On Thu, Feb 16, 2012 at 3:05 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi Maries,
Can u tell me how did u do that..
On Thu, Feb 16, 2012 at 3:25 PM, Maries talk2mar...@gmail.com wrote:
Find the
Hi Maries,
Thats really great..Thank you..
On Fri, Feb 17, 2012 at 3:10 PM, Maries talk2mar...@gmail.com 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 waheedb...@gmail.comwrote:
Hi
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 : Formulaname manager ( I am using
excel 2010).I've tried it but it didn't work.
Please advise.
Regards
On Feb 17, 5:39 am,
Find the attachments..
On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran duraichan...@gmail.comwrote:
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
Hi Maries,
Can u tell me how did u do that..
On Thu, Feb 16, 2012 at 3:25 PM, Maries talk2mar...@gmail.com wrote:
Find the attachments..
On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran
duraichan...@gmail.comwrote:
Hi ,
Here with attchaed file we need smal macro when i type first
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
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 nus...@googlemail.com
To: MS
18 matches
Mail list logo