Re: $$Excel-Macros$$ userform with animation

2010-06-04 Thread Víctor González
SOMEBODY COULD HELP ME THANKS El 2 de junio de 2010 22:15, Víctor González escribió: > hello friends need to do a userform with an animation > I searched the Internet but I did not understand the solution works > > if anyone can give me an idea or help with an element that would be ideal. > th

$$Excel-Macros$$ Setting a textbox to accept keyboard input

2010-06-04 Thread Jerry
I have a textbox the content of which I need to validate once the user has updated it in the _AfterUpdate event.If a character is invalid, I highlight it and display an error message in a label control. E.G. tbInput.SelStart = i - 1 tbInput.SelLength = 1 and try to give it the focus:

$$Excel-Macros$$ Excel 2007

2010-06-04 Thread lymabeane
Where I work they will be upgrading our Office 2003 to Office 2007. I describe myself as an Excel power user. I have customized my toolbars with drop downs, buttons and macros. This creativity of mine has spanned over the past 8 years or so as I make additions and improvements. With Office 2007

Re: $$Excel-Macros$$ Vba function in which a value is looked up in referenced range from a formula result

2010-06-04 Thread Paul Schreiner
it looks like you have  a function  called PrecDate that is accepting PrecTask and Link as as inputs. can you share what this PrecDate function looks like? Paul From: Philip To: MS EXCEL AND VBA MACROS Sent: Fri, June 4, 2010 9:03:06 AM Subject: $$Excel-Macr

Re: $$Excel-Macros$$ reading excel worksheet into an array?

2010-06-04 Thread Paul Schreiner
if you'll show me the code you're using, I'll rewrite it to access the cells directly. Paul From: molinari To: MS EXCEL AND VBA MACROS Sent: Fri, June 4, 2010 11:26:38 AM Subject: Re: $$Excel-Macros$$ reading excel worksheet into an array? Well., I don't exp

Re: $$Excel-Macros$$ Formula Help Required Urgent

2010-06-04 Thread Venkatesan c
Dear Andy, Thank u On Fri, Jun 4, 2010 at 3:55 PM, Aindril De wrote: > Hi Venkat, > > This can be achieved using array formulas in Excel. > Suggest you to look into the discussion in the attached link that should > resolve your issue: > http://www.mrexcel.com/forum/showthread.php?t=312142 >

Re: $$Excel-Macros$$ reading excel worksheet into an array?

2010-06-04 Thread molinari
Well., I don't expect the array to ever reach even hundreds of rows or columns. Right now, the largest array has 4 columns and 8 rows. I don't expect it to get much larger. How would I do it by processing the range values directly? The reason I liked the method I'm using is because the code is ve

Re: $$Excel-Macros$$ Excel tutor file

2010-06-04 Thread sudhir kumar
Hi kiran I download it but it can't perform. please suggeste me. thanxs On 6/4/10, Kiran PAREKH wrote: > > Dear All > The attached zip file contain Excel file which is of good help to persons > new to Excel and as well as for the referace to users of Excel > -- > With Best Regards > - Kiran P

$$Excel-Macros$$ Vba function in which a value is looked up in referenced range from a formula result

2010-06-04 Thread Philip
Consider the Function I created below (to generate task dates of a project schedule) and its procedure equivalent after that. The Test procedure works perfectly, because the lookup function for PrecDate is able to return the date value. But the lookup function for PrecDate in the STARTDATE functi

Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-04 Thread Azhar Rai
Hello Gurus I am afraid I did not receive response from anyone. AZHAR RAI Cell: +92-333-552-7731 Skype: azhar.rai On Thu, Jun 3, 2010 at 10:03, Azhar Rai wrote: > Hi Gurus > > My work relates to prepare a large number of reports and I use mail merge > for all this process. I have to save each

$$Excel-Macros$$ Help

2010-06-04 Thread Gagan Deep Gupta
Please help in getting code for Dynamically copy and paste a formula for the no of occoupied eows in excel. Best Regards Gagan Deep Gupta -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

$$Excel-Macros$$ Fwd: Urgent help required.

2010-06-04 Thread Born to Win
Thanks, Chandrabhan Singh -- Forwarded message -- From: Born to Win Date: Fri, Jun 4, 2010 at 3:29 PM Subject: Urgent help required. To: excel-macros@googlegroups.com Dear All, I need your Favour.I have a database in which no. & calls summary are mentioned below.But i am not

Re: $$Excel-Macros$$ commandbar dropdown menu to count worksheets

2010-06-04 Thread manish
dear swapnil this coding is working and gives a POPUP MENU SHOWING number of worksheets. Is there other way to add worksheets in a combobox in the menu you created so that if we click that particular sheet we can navigate to the clicked sheet using your menu regards manish On Jun 3, 6:33 pm, Swapn

$$Excel-Macros$$ Urgent help required.

2010-06-04 Thread Born to Win
Dear All, I need your Favour.I have a database in which no. & calls summary are mentioned below.But i am not able to find Any formula to map Calls Against Calls summary.If possible Please let me know is it possible through VBA.Please Find Attached Raw Dump & Format of data exactly i have to give.

Re: $$Excel-Macros$$ Pivot table for Datewise Bank Balance

2010-06-04 Thread SUMIT VYAS
good On Wed, Jun 2, 2010 at 4:52 PM, prabhakar thakur wrote: > Dear, > Please find the attached your query. > Thanks, > Prabhakar Thakur > New Delhi > +919953736776 > > > > > On Wed, Jun 2, 2010 at 12:37 PM, Ashish Khandelwal > <4everash...@gmail.com>wrote: > >> Dear friend

$$Excel-Macros$$ not allow user to paste any thing in data validation column

2010-06-04 Thread ashish koul
hi need any macro that will not allow user to paste any thing in data validation column for example i have put validation on col a anyone can copy data from any cell and paste in any cell of col a .. how can it be stopped or not allowed . regards ashish -- --

$$Excel-Macros$$ Dear Group Help Me Regarding Conditional Formating

2010-06-04 Thread Jai
Pleaese Check the Attachment -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://

Re: $$Excel-Macros$$ Formula Help Required Urgent

2010-06-04 Thread Aindril De
Hi Venkat, This can be achieved using array formulas in Excel. Suggest you to look into the discussion in the attached link that should resolve your issue: http://www.mrexcel.com/forum/showthread.php?t=312142 Regards, Andy On Thu, Jun 3, 2010 at 6:57 PM, Venkatesan c wrote: > Dear Group, > >

Re: $$Excel-Macros$$ Re: popup on s sheet ?

2010-06-04 Thread Swapnil Palande
Hi, It is possible to set visibility of chart. You can use the code given in http://cjoint.com/data/fFrTGZSr2t.htm Do following changes in that code: Instead of "ActiveSheet.Shapes("AutoShape 3").Visible = False" use "ActiveSheet.ChartObjects("Chart 1").Visible = False" Attached is the excel f

Re: $$Excel-Macros$$ Allocating in the Order

2010-06-04 Thread Vikas Chouhan
Dear Han, please send example sheet. On Thu, Jun 3, 2010 at 1:16 PM, Han wrote: > Hi Everyone, > > > > I need some help with this formula problem I'm working on, so if you > have any free time you can help me solve it would be great. > > Tab #4 on the attached spreadsheet is the closest I have