RE: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

2012-12-15 Thread Asa Rossoff
Very nice calendars. I like how Deba Ranjan's has a month offset feature (Seems to be a hidden feature) by changing the value in G4, for a calendar that begins on any month of the year. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schrein

Re: $$Excel-Macros$$ Re: Find and the current data on Form

2012-12-15 Thread Bé Trần Văn
Welcome Prince. File TIEN TIM 3 if I format the Number type, the error happened 1004 (Unable to get the match property of the WorksheetFunction class), in column A, I need to be of type Number, you can help me to use the Number format (because I need the model number), like ComboBox2 (Find treatme

$$Excel-Macros$$ Help with INSTR

2012-12-15 Thread Matt
Hi, search the forum but couldn't find an example that fit. I'm trying to do a search off column "A" on the "Lookup" tab, and search for it in the yellow column in the "2010Chase" tab using the "Instr" function and return a value but can't seem to get the code to work unless the words are iden

Re: $$Excel-Macros$$ Re: Find and the current data on Form

2012-12-15 Thread Bé Trần Văn
Thanks Prince. Thanks for your quick reply, once again thank you. 2012/12/15, Prince : > Hi bé trần văn > > your data in column A:A have spaces thats why it is not matching with > current selection of the combo box. but for now i have trim the data in > column A and it is working. > please see th

$$Excel-Macros$$ Re: Find and the current data on Form

2012-12-15 Thread Prince
Hi bé trần văn your data in column A:A have spaces thats why it is not matching with current selection of the combo box. but for now i have trim the data in column A and it is working. please see the attached. regards prince On Friday, December 14, 2012 9:35:43 PM UTC+5:30, bé trần văn wrote:

Fw: Fwd: $$Excel-Macros$$ Capture both the action "check" and "uncheck"

2012-12-15 Thread chhajersandeep
Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Date: Sat, 15 Dec 2012 07:12:15 To: Reply-To: chhajersand...@gmail.com Subject: Re: Fwd: $$Excel-Macros$$ Capture both the action "check" and "uncheck" Dear Praveen, Thanks for the reply. Actually f

Re: Fwd: $$Excel-Macros$$ Capture both the action "check" and "uncheck"

2012-12-15 Thread Prince
Hi Sandeep. PFA Regards Prince On Saturday, December 15, 2012 12:42:15 PM UTC+5:30, sandeep chhajer wrote: > > Dear Praveen, > > Thanks for the reply. > Actually frankly speaking I don't have any file right now with me. But I > can discuss the problem. > I want to hide two rows with a click in

$$Excel-Macros$$ Invitation to use Google Talk

2012-12-15 Thread Google Talk
--- You've been invited by Zealous Valiant to use Google Talk. If you already have a Google account, login to Gmail and accept this chat invitation: http://mail.google.com/mail/b-7e6e4c6ccd-44896a9003-J8NhFft1KisPVITRDYKaAUlM6ME

$$Excel-Macros$$ Invitation to use Google Talk

2012-12-15 Thread Google Talk
--- You've been invited by Zealous Valiant to use Google Talk. If you already have a Google account, login to Gmail and accept this chat invitation: http://mail.google.com/mail/b-7e6e4c6ccd-09ebc263c0-umlkngYfePILV-WOU6Mu2UYPPMU