$$Excel-Macros$$ Array of CheckBox

2011-07-14 Thread Rash
Hi all, I am using MS word 2010. In the word / Excel Sheet document I have created one checkbox object and named it as CheckBox 1.Now , I want to create array of 10 checkbox. How can i do that. Advance thanx Rsh --

$$Excel-Macros$$ macro for copy down

2011-07-05 Thread Rash
Hi All, I have excel file with 12000+ rows, and 10 column where i have used Vlookup and sumif function in the second row, i need a macro which copy down the function till the last row with min. time frame. Appreciate your support in advance. Regards Rash

Re: $$Excel-Macros$$ Excel VBA for BOM

2011-07-03 Thread Rash
Hi, FYI, Sorry, the previously attached file already contains the macro, but its not full proof. It is not highlighting rows 137 to 142. because its not in sorted order. Rash -- -- Some important links for excel

Re: $$Excel-Macros$$ Excel to my computer path setting

2011-06-30 Thread Rash
Thank you very much santhosh. Is it possible to make an .exe file in excel so that no one can see the code behind and they just open it and use without opening the excel sheet. -- -- Some important links for excel

$$Excel-Macros$$ User form + Macro to activate certain region of active work sheet.

2011-06-29 Thread Rash
Hi all, Need Help... I have a user form in which i have 6 check boxes. ok and cancel button. when ever I click 1st check box, rows 1 to 10 should to be editable, rest all rows should be non editable and hidden. For check box 2, rows 11 to 20 editable, rest up and down area should be non

$$Excel-Macros$$ Excel to my computer path setting

2011-06-29 Thread Rash
Hi all, I have some files sorted depending on department in one of my E:/ location. Instead of going manually inside each folder I thought of automatic it using excel. I assume 4 check boxes. If I select 1st check box , HR folder should open automatically which is inside E:/ My files/All/HR

$$Excel-Macros$$ arithmetic progression like

2010-06-30 Thread Rash
of values) Eg: If selected horizontal button in user form, with input value = 2, step value=2, number of values=5, then from Cell A to E cell, it should display 2,4,6,8,10 If selected vertically, It should display 2,4,6,8,10 from cell A1 to A5. Plz help me out in solving this asap Rash