$$Excel-Macros$$ Index function help needed

2012-04-13 Thread Mr Excellent
Hi All, Need a simple index function with a drop given to auto publish the values in the given table Please help Thanks Excellent -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formul

$$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs

2011-12-01 Thread Mr Excellent
Hi, Join the Fashion Group and get 1000rs on intial enrollment and get waived off in the initial transaction Fashion Group : A Place with more discounts and less money incurred...join in and believe it Believe it with below link : http://www.fashionandyou.com/fashionandyou-client-http-shop/shop

$$Excel-Macros$$ Count days in a Col

2011-10-17 Thread Mr Excellent
Hi All, I have three different dates in a Column A , suppose say in Col A i have A1 as 1- Dec -2010, A2 as 11- Jan-2011,A3 as 1- Mar -2011 then i need a count of number days as *3* in the cell A4 any idea? Thanks Prasad. -- ---

$$Excel-Macros$$ Conditional Formatting

2011-10-13 Thread Mr Excellent
Hi Group, Need a help in Conditional formatting I have 12 Columns in the sheet the first 6 Cols have the data and the next 6 Cols have the Checks, so based on the Values of "Yes" and "No for the Check1 to till Check6 the values in the first 6 Columns should be highlighted If It has "Yes" in the

Fwd: Fw: $$Excel-Macros$$ Help required

2011-10-13 Thread Mr Excellent
-- *From: *Mr Excellent *Sender: *excel-macros@googlegroups.com *Date: *Thu, 13 Oct 2011 04:52:12 +0530 *To: * *ReplyTo: *excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Help required Hi Group, Need a small help, i have a code which runs on the data and

$$Excel-Macros$$ Help required

2011-10-12 Thread Mr Excellent
Hi Group, Need a small help, i have a code which runs on the data and seggregates the details as per the Country, but additional to that i require the Country name should come on the top of each rows which are divided by country in the first column and the heading should be applicable to all the s

$$Excel-Macros$$ Export Data

2011-09-21 Thread Mr Excellent
Hi Group I have a spread sheet which has 3 TABS and the last tab is saved with the required information and i need a VBA code for exporting only the TAB named as "Details" to be exported on my desktop with xls format and file which has to be saved should be named as "Details - Present Date( DD-MM-

Re: $$Excel-Macros$$ Switching between windows when a form is opened

2011-09-16 Thread Mr Excellent
*DID YOU GET MY QUESTION AS THE ANSWER IS NOT RELEVANT* On Fri, Sep 16, 2011 at 1:07 PM, Anas Alam Habibullah wrote: > *Try > Ctrl + PageDown > > or > > Ctrl + PageUp > * > > On Fri, Sep 16, 2011 at 9:28 AM, Mr Excellent wrote: > >> Hi Group, >> >

$$Excel-Macros$$ Switching between windows when a form is opened

2011-09-16 Thread Mr Excellent
Hi Group, This might be a unique question to ask, but need to when the form is active on my screen and i want switch between form and other excel sheet , but it is not happening is there any possibility that when the form is opened and can switch between the windows, usally the need of swtching bt

$$Excel-Macros$$ Drop Down Combo box Error

2011-09-14 Thread Mr Excellent
Hi Group, I have a Combo box in which the list is selected from 1 to 8 and i have 2 pages in the form when click on 1,3,5,7 the Frame1 in Page 2 should be disabled and vice versa , please help Thanks Prasad -- -- So

$$Excel-Macros$$ Msg Box

2011-09-09 Thread Mr Excellent
Hi Group, I have a form which has a Close button and a Code assgined to it as below: Private Sub cmdClose_Click() MsgBox "Do you want to Save the details", vbYesNoCancel Unload Me End Sub But What i need is when i Click on "OK" button on the form should close or if i click on "No" the Form shoul

$$Excel-Macros$$ Link a Check Box to Other Check Box

2011-09-06 Thread Mr Excellent
Hi Group, I have check boxes in the form below , what i want is if i update a value in " Update Currency Type" in one Check box the value of the Other Check box "Only Indian Currency" shud be same, please let me know how to do it. Thanks Prasad. -- -

$$Excel-Macros$$ Calender needed in the check box

2011-09-05 Thread Mr Excellent
Hi team, I have a form where i have a check box where i need to update a date value in it, so what i need is a option of calender to enter the value of date in the given check box. Please help, as attached. Thanks Prasad. -- -

Re: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes

2011-09-05 Thread Mr Excellent
, how to add > many cases if the select any other country and opt for other check boxes, > please refer to the attachment > > Please help > > Thanks > Prasad. > > On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI > wrote: > >> Dear Surya, >> >> Ple

Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes

2011-09-05 Thread Mr Excellent
rya, > > Please see attached sheet if it help.. > > On Mon, Sep 5, 2011 at 7:06 AM, Mr Excellent > wrote: > >> Hi Group, >> >> Need a small help, i have a combo box in the form and when i click on >> particular name "INDIA" one of the list box which says

$$Excel-Macros$$ Need a help in Combo and Check Boxes

2011-09-04 Thread Mr Excellent
Hi Group, Need a small help, i have a combo box in the form and when i click on particular name "INDIA" one of the list box which says " Indian currency to be updated " should be enabled and the other list box should be disabled and vice versa as well, please help. Thanks, Prasad. -- -

$$Excel-Macros$$ Combox List in Userform

2011-08-30 Thread Mr Excellent
Hi All, Attached is the sheet where i need the data to be loaded Combo box of the userform given, i need a VBA Code which picks the data from the excel spread sheet and provides them in the combo box as a drop down list..please help Thanks Prasad. -- ---

Re: $$Excel-Macros$$ How to load data into Combo box in user form

2011-08-30 Thread Mr Excellent
Hi Rajan, Thanks for the attachment, but my requirement is to add the list in the Userform provided in excel sheet not on the excel spread sheet. Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad On Tue,