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