Re: $$Excel-Macros$$ Query on Extract word

2015-05-21 Thread Pankaj Sharma
little mistake,, but now done =IFERROR(TRIM(CONCATENATE(MOC ,MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,), ,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,), ,)))+3),2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),

$$Excel-Macros$$ Re: Looking for job

2015-05-21 Thread Mandeep Baluja
I have been looking for the same !!! Regards, Mandeep Baluja On Thursday, May 21, 2015 at 11:01:39 AM UTC+5:30, Priti_Verma wrote: Hi There, Is there any job for vba developer. Thanks Priti -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ VBA code for force selection of dropdown

2015-05-21 Thread Mandeep Baluja
Practice can teach you excel, because nobody knows the end of Excel. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=312532939 On Thursday, May 21, 2015 at 8:21:02 AM UTC+5:30, rahulbhardwaj1986 wrote: Hi

$$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread siga
bonjour je cherche un code vba qui affiche la date dans la cellule e après qu'on a saisie les données dans le cellule a b c d et que cette date soit fixe et ne change pas avec le temps. merci pour l'aid -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread elhechmi eladeb
thanks yes the problem is what you just said, each time you open the file the date changes. in this case I find a vien code in Internet. the problem that execute from i = 2 to i = 100 beyond the 100 code is not working. the code you find in this link:

Re: $$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread Mustapha LMIDMANI
Please try to use function now() it gives the actual date and hour when you write it. but it will updated each time you open the file ... and this is not what you're looking for I think... 2015-05-21 16:43 GMT+01:00 siga eladebelhec...@gmail.com: bonjour je cherche un code vba qui affiche

Re: $$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread Mustapha LMIDMANI
without reading in deep of the code, you can just give to i a verry big value this will solve your issue ? 2015-05-21 17:12 GMT+01:00 elhechmi eladeb eladebelhec...@gmail.com: thanks yes the problem is what you just said, each time you open the file the date changes. in this case I find a

Re: $$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread elhechmi eladeb
thanks 2015-05-21 17:18 GMT+01:00 Mustapha LMIDMANI lmidmani.musta...@gmail.com: without reading in deep of the code, you can just give to i a verry big value this will solve your issue ? 2015-05-21 17:12 GMT+01:00 elhechmi eladeb eladebelhec...@gmail.com: thanks yes the problem is

$$Excel-Macros$$ VBA Self study materials

2015-05-21 Thread Greg P
maybe someone will need http://training-course-material.com/training/Visual_Basic_for_Applications_(VBA)_in_Excel_-_Introduction_to_programming -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @