$$Excel-Macros$$ Combo box

2012-06-14 Thread Smitha S R
Is it possible to include the items in one sheet to a combo box in other sheet. For example, if in sheet 1 there is names and in the second sheet there is combo box with the heading names. Shall I get the names of other sheet in the combo box as and when I go on adding the names in the first

Re: $$Excel-Macros$$ Combo box

2012-06-14 Thread NOORAIN ANSARI
Hi Smitha, Please see atached sheet.- - Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 14, 2012 at 2:13 PM, Smitha S R sperdwo...@gmail.com wrote: Is it possible to include the items in one sheet to a combo box in other sheet. For

Re: $$Excel-Macros$$ Hi

2012-06-14 Thread NOORAIN ANSARI
Mihael, Please post ur excel macro query On Thu, Jun 14, 2012 at 8:39 AM, Michael Brumby mikebru...@yahoo.comwrote: this is crazy you should check the out http://www.business15canews.net/work/?read=5074813 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,

Re: $$Excel-Macros$$ Combo box

2012-06-14 Thread NOORAIN ANSARI
Hi Smitha, Check this one.. On Thu, Jun 14, 2012 at 3:09 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, Its not working. On Thu, Jun 14, 2012 at 3:01 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Smitha, Please see atached sheet.- - Thanks regards, Noorain

Re: $$Excel-Macros$$ Combo box

2012-06-14 Thread Smitha S R
Thanks Noorain. Its working. Shall I get the codes or basics to study on these codes so that I can use the controls in excel and make them working in a simple way. Please do send me any material with the basics of codes, so that I can understand the use and try from my end to apply it. I don't

Re: Re: $$Excel-Macros$$ Date

2012-06-14 Thread Chandra Shekar
Hello Ankur, Can you please send solved excel file. Thanks, Chandra Shekar B On Wed, Jun 13, 2012 at 5:51 PM, ankurpande...@gmail.com wrote: hi chandra try this TEXT(B2-A2,[h]:mm:ss) for Formula2(hr:mm:ss) On , Chandra Shekar chandrashekarb@gmail.com wrote: Hello, Thanks

RE: $$Excel-Macros$$ vba - run time error 9 out of range

2012-06-14 Thread Rajan_Verma
Check the worksheet name in below line : Set ws = Worksheets(Component List) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of cardak Sent: 14 June 2012 12:50 To: excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Multiple Challenging Excel Needs...

2012-06-14 Thread Paul Schreiner
You said that you have written a sort macro... line 3 must be where the sort command is expecting a range object. Probably Selection.sort. if you don't have a range selected, then it will fail. You can explicitly define the range: Range(A1:Z65000).Sort it should work. Can you show the this

RE: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

2012-06-14 Thread Mohammed Muneer
Dear Friends, Its working, thanks for the instant help. I finish my task this morning, I kick the ball in their ground to let the other department play. So happy! I thought I could not finish. But done! Regards, Muneer, CC -- FORUM RULES (986+ members already

Re: $$Excel-Macros$$ Forum feature : Highlight code syntax

2012-06-14 Thread Sam Mathai Chacko
Nice one. It's about time they added this. Regards Sam On Thu, Jun 14, 2012 at 10:57 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I would like to share one of the cool feature of new google groups. This is called *'Highlight code syntax'* where you can highlight the code in

Re: $$Excel-Macros$$ Forum feature : Highlight code syntax

2012-06-14 Thread Sam Mathai Chacko
Nice one. It's about time they added this. Regards Sam On Thu, Jun 14, 2012 at 10:57 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I would like to share one of the cool feature of new google groups. This is called *'Highlight code syntax'* where you can highlight the code in

RE: $$Excel-Macros$$ Forum feature : Highlight code syntax

2012-06-14 Thread Rajan_Verma
Can we use this in Email..? because most of user are using email to post on group. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: 14 June 2012 10:57 To:

$$Excel-Macros$$ Help for Regarding Excel

2012-06-14 Thread R@jiv Kum@r
Dear Sir, Noorain Sir plz tell me excel menu Insert= Name --Please Sir help me -- *Thanks Regards * *Rajiv Kumar * *Mawana Sugar Works, Mawana * *Mo.No: 09027414899* -- *Thanks Regards * *Rajiv Kumar * *Mawana Sugar Works, Mawana * *Mo.No: 09027414899* -- FORUM RULES (986+

$$Excel-Macros$$ Solutions Architect/Chicago,IL/6 month contract- potential extensions

2012-06-14 Thread Jacob john
Hello Consultant, Please let me know if you are interested in this requirement. If yes, kindly send us your resume along with contact information. If you are not looking for new projects, please feel free to pass on this email to your friends or relatives who might be interested.

$$Excel-Macros$$ SR LINUX SYS ADMIN/ATLANTA, GA/6 months contract

2012-06-14 Thread Jacob john
Hello Consultant, Please let me know if you are interested in this requirement. If yes, kindly send us your resume along with contact information. If you are not looking for new projects, please feel free to pass on this email to your friends or relatives who might be interested. Title:SR LINUX

Re: $$Excel-Macros$$ Combo box

2012-06-14 Thread Smitha S R
Hi, Shall I get the codes or basics to study on these codes so that I can use the controls in excel and make them working in a simple way. Please do send me any material with the basics of codes, so that I can understand the use and try from my end to apply it. On Thu, Jun 14, 2012 at 3:35 PM,

Re: $$Excel-Macros$$ Vba Password recovery excel password remover

2012-06-14 Thread NOORAIN ANSARI
Hi Deba brother.. As per our forum rule, We can't share this type of information. Please read rule No. 3 3) Don't post questions regarding breaking or bypassing any security measure. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, Jun 15,

Re: $$Excel-Macros$$ Vba Password recovery excel password remover

2012-06-14 Thread Deba Ranjan
OK No issue broi was not ware of that. Thanks Thanks Regards, *Deba Ranjan P* On Fri, Jun 15, 2012 at 10:38 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Deba brother.. As per our forum rule, We can't share this type of information. Please read rule No. 3 3) Don't

$$Excel-Macros$$ Lookup fomular

2012-06-14 Thread ATTAPAN_CHAINARONGBOON
Dear all experts I've some questions to ask in my sheet The sheet put for the forecast date and quantity each per forecast date I need to get the lastest forecast date and the quantity of that, So, the result which fomular which I use are Ok, but I think may be have better way to do that

$$Excel-Macros$$ delete blank columns

2012-06-14 Thread Smitha S R
How to delete all blank columns arising between various rows and columns? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

Re: $$Excel-Macros$$ delete blank columns

2012-06-14 Thread Smitha S R
Hi, Any one please help me in deleting all blank columns in a data report with many filled rows and columns. On Fri, Jun 15, 2012 at 11:11 AM, Smitha S R sperdwo...@gmail.com wrote: How to delete all blank columns arising between various rows and columns? -- FORUM RULES (986+ members