Re: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread N.Shivkumar 
Exactly and thanks for your reply ​











N.SHIVKUMAR
Mobile : +919422613567
Office  : +912332301775
Alternate Email: shiv1...@yahoo.com




On 16 June 2014 11:54, Ravinder  wrote:

> PFA, if you are looking for this.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *N.Shivkumar
> *Sent:* Monday, June 16, 2014 11:13 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Conditional formatting
>
>
>
> Dear friends
>
>
>
> Can anybody throw some light and help me as to where I am going wrong in
> conditional formatting!
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> N.SHIVKUMAR
>
> Mobile : +919422613567
> Office  : +912332301775
> Alternate Email: shiv1...@yahoo.com
>
> --
> 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 @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> 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 @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread N.Shivkumar 
Dear Vaibhavji
If the achievement is > 100% it should green arrow up, if it is less than
90% it should show red arrow down and if between 90 and 100 it should show
straight arrow.​










N.SHIVKUMAR
Mobile : +919422613567
Office  : +912332301775
Alternate Email: shiv1...@yahoo.com




On 16 June 2014 11:25, Vaibhav Joshi  wrote:

> whats issue?
>
>
> On Mon, Jun 16, 2014 at 11:12 AM, N.Shivkumar  wrote:
>
>> Dear friends
>>
>> Can anybody throw some light and help me as to where I am going wrong in
>> conditional formatting!
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> N.SHIVKUMAR
>> Mobile : +919422613567
>> Office  : +912332301775
>> Alternate Email: shiv1...@yahoo.com
>>
>>
>>  --
>> 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 @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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 @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

RE: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread Ravinder 
PFA, if you are looking for this.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of N.Shivkumar
Sent: Monday, June 16, 2014 11:13 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Conditional formatting

 

Dear friends

 

Can anybody throw some light and help me as to where I am going wrong in 
conditional formatting! 


 

 

 

 

 

   

 

   

    

 

N.SHIVKUMAR

Mobile : +919422613567
Office  : +912332301775
Alternate Email: shiv1...@yahoo.com

   

-- 
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 @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


CONDTION FORMATING WITH %.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread Vaibhav Joshi 
whats issue?


On Mon, Jun 16, 2014 at 11:12 AM, N.Shivkumar  wrote:

> Dear friends
>
> Can anybody throw some light and help me as to where I am going wrong in
> conditional formatting!
>
>
>
>
>
>
>
>
>
> N.SHIVKUMAR
> Mobile : +919422613567
> Office  : +912332301775
> Alternate Email: shiv1...@yahoo.com
>
>
>  --
> 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 @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Conditional formatting

2014-06-15 Thread N.Shivkumar 
Dear friends

Can anybody throw some light and help me as to where I am going wrong in
conditional formatting!









N.SHIVKUMAR
Mobile : +919422613567
Office  : +912332301775
Alternate Email: shiv1...@yahoo.com

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 12 updates in 7 topics

2014-06-15 Thread Cab Boose 
Hi
Having a problem with Google Groups.  Using Chrome Win7

To send a new message it comes up with email to, Subject heading, tags to
enter,  but there is no  message block! to type in a message. Is there
something I am missing !
Charles Harris


On Mon, Jun 16, 2014 at 11:23 AM,  wrote:

>   Today's topic summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
>- Event for dynamically add control in Excel VBA
><#146a1d7cb356a198_group_thread_0> [1 Update]
>- Data Fetching <#146a1d7cb356a198_group_thread_1> [1 Update]
>- Date Format Query <#146a1d7cb356a198_group_thread_2> [3 Updates]
>- plz add me to the group thanks <#146a1d7cb356a198_group_thread_3> [1
>Update]
>- how to crack Excel VBA password <#146a1d7cb356a198_group_thread_4>
>[1 Update]
>- Need help with making a macro revolving around finding certain
>numbers from a list <#146a1d7cb356a198_group_thread_5> [4 Updates]
>- Here is a Great Challenge - Retrieve data in from a multiple urls in
>one step <#146a1d7cb356a198_group_thread_6> [1 Update]
>
>   Event for dynamically add control in Excel VBA
> 
>
>"Ondřej Říha"  Jun 15 02:06PM -0700
>
>Hello,
>I would like to add sub for click event of dynamically add control
>button
>in user form for example in VBA for Excel. I found some examples on
>Internet but every finished with some error or didn't work.
>When I use for example this way:
>
>Application.VBE.CodePanes(1).CodeModule.InsertLines NumLines + 1,
>"Private Sub CommandButton3_Click()"
>Application.VBE.CodePanes(1).CodeModule.InsertLines NumLines + 2,
>"MsgBox ""Message here !"""
>Application.VBE.CodePanes(1).CodeModule.InsertLines NumLines + 3, "End
>Sub"
>
>for add new code at the end of code this code is added fine but work
>only
>after restart user form.
>Please can anybody make easy example to explain me how work adding
>controls
>to existing form with event for this control?
>Thank you very much Ondra
>
>
>
>   Data Fetching
> 
>
>Jocky Beta  Jun 15 11:27PM +0530
>
>Hi Team,
>
>I want to fetch data from one sheet to another sheet by referring the
>data,
>Attached sheet will explain you what i want exactly.
>
>Request all of you to kindly help me on this
>
>Regards
>
>
>
>   Date Format Query
> 
>
>GENIUS  Jun 14 10:36PM -0700
>
>look at the result
>
>
>
>
>Vaibhav Joshi  Jun 15 06:23PM +0530
>
>Hi
>
>You can change display format by going to cell property & select
>custom and
>type dd.mm.
>
>If by doing so if date format does not change then select single column
>then press Data tab in Menu then press Next 2 times then select Date
>(DMY)
>and press finish button.
>
>Cheers!!
>
>
>
>
>
>
>DELIN FRANCIS  Jun 16 01:24AM +0800
>
>Hi Pravin ...
>
>
>You can go to Format cell and custom the format of the date which ever
>result you need. furthermore you can see in the attachement.
>
>
>
>
>
>Delin.F
>
>
>
>
>On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi  wrote:
>
>
>
>Hi
>
>You can change display format by going to cell property & select
>custom and type dd.mm.
>
>If by doing so if date format does not change then select single
>column then press Data tab in Menu then press Next 2 times then select Date
>(DMY) and press finish button.
>
>Cheers!!
>
>
>
>On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal 
>wrote:
>
>Hi,
>
>>Kindly help.
>
>>Regards
>>Pravin Gunjal.
>--
>>To post to this group, send email to excel-macros@googlegroups.com.
>>Visit this group at http://groups.google.com/group/excel-macros.
>>For more options, visit https://groups.google.com/d/optout.
>
>--
>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 @
>https://www.facebook.com/discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like
>Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>Advice will not get quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security
>measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE : Don't ever post confidential data in a workbook. Forum owners
>and members are not responsible for any loss.
>---
>You received this message because you are subscribed to the Google
>Groups "MS EXCEL AND VBA MACROS" group.

$$Excel-Macros$$ Event for dynamically add control in Excel VBA

2014-06-15 Thread Ondřej Říha 
Hello,
I would like to add sub for click event of dynamically add control button 
in user form for example in VBA for Excel. I found some examples on 
Internet but every finished with some error or didn't work.
When I use for example this way:

Application.VBE.CodePanes(1).CodeModule.InsertLines NumLines + 1, 
"Private Sub CommandButton3_Click()"
Application.VBE.CodePanes(1).CodeModule.InsertLines NumLines + 2, 
"MsgBox ""Message here !"""
Application.VBE.CodePanes(1).CodeModule.InsertLines NumLines + 3, "End 
Sub"

for add new code at the end of code this code is added fine but work only 
after restart user form.
Please can anybody make easy example to explain me how work adding controls 
to existing form with event for this control?
Thank you very much Ondra

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ plz add me to the group thanks

2014-06-15 Thread ankur kochar 
On Feb 13, 2014 12:49 AM, "sudhansu mohan" 
wrote:

>
>  --
> 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 @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: how to crack Excel VBA password

2014-06-15 Thread David Sands 
Hiya, 

Can anyone please recover the VBA password(s) for this file, I have 
recovered the excel (2010 macro enabled workbook) workbook and worksheet 
passwords.
https://drive.google.com/file/d/0Bw6W1WHEetl7LUZyWC13WWw5cUU/edit?usp=sharing

I have tried a few freeware VBA password recovery programmes, alas no joy, 
so now seeing if anyone could help me out, 

Many thanks in advance, 
Dave



On Friday, 19 February 2010 23:46:00 UTC, JsinSk wrote:
>
> Post the file here and someone will crack it for you.
>
> On Feb 19, 9:24 am, sunil sasidharan 
> wrote:
> > *Hi All,*
> > **
> > *I need to edit an excel macro file but the VBA coing is protected and
> > nobody is aware of the password.*
> > **
> > *Could you please help me on how do i crack the excel password or is 
> there
> > any free software available?*
> > **
> > *Thanks in advance for your help
> >
> > Regards,
> > Sunny
> > *
>

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Date Format Query

2014-06-15 Thread Vaibhav Joshi 
Hi

You can change display format by going to cell property & select custom and
type dd.mm.

If by doing so if date format does not change then select single column
then press Data tab in Menu then press Next 2 times then select Date (DMY)
and press finish button.

Cheers!!


On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal  wrote:

> Hi,
>
> I wanted to convert the dates in this format *DD.MM.*
>
> Now it is not in system's date format ( MM/DD/ ) and it is displayed
> as DD/MM/ or as D/M/.
>
> Kindly help.
>
> Regards
> Pravin Gunjal.
>
> --
> 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 @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

2014-06-15 Thread Vaibhav Joshi 
Hi

You need to use count if formula to get what you want..in range you need to
specify both the column where probable value would be.

Refer file in my previous post with yellow colored range.

Cheers!!




On Sun, Jun 15, 2014 at 12:02 PM, Noah Shalii  wrote:

> Sorry I'm an excel noob, I don't understand what to do.
>
> On a side note though, i was wondering what the formula would be if it was
> just to find whether Cells(1, 1).Value exists in row B, and where it would
> be. Also what would the formula for selecting the bottom row with a value
> in it be?
>
> Sorry for the inconveniences.
>
>
> On Sunday, June 15, 2014 2:09:39 AM UTC+9, Noah Shalii wrote:
>>
>> Hi, I am in need of help making a macro formula for excel.
>>
>> I apologize in advance for my poor explanation, but I am trying to create
>> something which will;
>> 1. check the number in row 1 column A
>> 2. see if that same number is present in column B(any row)
>> 3. if it is anywhere in column B, add 1 value to column C of the same row
>> the number was found in column B
>> 4. if there number isn't found anywhere in column B, add the number to
>> the bottom of the list of column B, and add 1 value to column C next to it.
>> 5. repeat this with row 2 column A, then row 3 column A, etc. until the
>> last number in column A.
>>
>> for example,
>>A  B   C
>> 1 3   4   1
>> 2 6   3   1
>> 3  8   2
>>
>> would turn into:
>>3  41
>>6  32
>>82
>>61
>>
>> it would be greatly appreciated if someone can make a macro formula for
>> this or even explain one of the steps.
>> thanks.
>>
>  --
> 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 @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.