Re: $$Excel-Macros$$ VBA Help

[Sundarvelan N]

Thank you very much.

I'm learning VBA

Thanks
N.Sundarvelan
9600160150

On 19 August 2016 at 22:34, mrExcel4u  wrote:

> Hi,
> Please use the below mentioned code on Add command Button click
>
> Private Sub CommandButton1_Click()
>
> Dim Rcount As Integer
>
> Rcount = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
>
> Rcount = Rcount + 1
>
> Range("b" & Rcount).Value = Me.TextBox1.Value
> ActiveCell.Offset(0, 2).Value = Me.TextBox2.Value
> Range("A" & Rcount).Value = Rcount - 1
>
> End Sub
>
> Thanks
>
>
> Thanks & regards,
>
> www.MrExcel4U.com 
>
> On Fri, Aug 19, 2016 at 1:10 PM, Sundarvelan N  wrote:
>
>> Dear Friends,
>>
>> I'm trying to learn VBA,
>>
>> PFA, i'm trying to add data from userform text to excel table.
>>
>> Please help
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> --
>> 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 https://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 https://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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ VBA Help

[mrExcel4u]

Hi,
Please use the below mentioned code on Add command Button click

Private Sub CommandButton1_Click()

Dim Rcount As Integer

Rcount = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row

Rcount = Rcount + 1

Range("b" & Rcount).Value = Me.TextBox1.Value
ActiveCell.Offset(0, 2).Value = Me.TextBox2.Value
Range("A" & Rcount).Value = Rcount - 1

End Sub

Thanks


Thanks & regards,

www.MrExcel4U.com 

On Fri, Aug 19, 2016 at 1:10 PM, Sundarvelan N  wrote:

> Dear Friends,
>
> I'm trying to learn VBA,
>
> PFA, i'm trying to add data from userform text to excel table.
>
> Please help
>
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> 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 https://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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ VBA help required for specific Output from Input

[Vaibhav Joshi]

Great!!
ᐧ

On Tue, Jan 20, 2015 at 6:34 PM, sach so itssac...@gmail.com wrote:

 Dear Vabz,

 Thanks! It works as i required.

 Regards,
 Sachin

 On Sunday, January 18, 2015 at 7:40:16 PM UTC+5:30, Vabz wrote:

 Sach,

 Amended code to suits your need..

 Cheers!!

 On Fri, Jan 16, 2015 at 5:28 PM, sach so itss...@gmail.com wrote:

 Dear Expert,

 I required some changes in VBA, file attached here.  I have data sheet,
 for Input i have input sheet  for output have output sheet. when I run
 macro i will get output.

 *My requirment- *In data sheet if product  product id is allocated
 then macro need to pick next (non allocated) value for given input, when i
 run macro.

 Kindly do the needful.

 Regards,
 Sachin

 --
 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...@googlegroups.com.
 To post to this group, send email to excel-...@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$$ VBA help required for specific Output from Input

[sach so]

Dear Vabz,

Thanks! It works as i required.

Regards,
Sachin 

On Sunday, January 18, 2015 at 7:40:16 PM UTC+5:30, Vabz wrote:

 Sach,

 Amended code to suits your need..

 Cheers!!

 On Fri, Jan 16, 2015 at 5:28 PM, sach so itss...@gmail.com javascript: 
 wrote:

 Dear Expert,

 I required some changes in VBA, file attached here.  I have data sheet, 
 for Input i have input sheet  for output have output sheet. when I run 
 macro i will get output.

 *My requirment- *In data sheet if product  product id is allocated then 
 macro need to pick next (non allocated) value for given input, when i run 
 macro.

 Kindly do the needful.

 Regards,
 Sachin

 -- 
 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...@googlegroups.com javascript:.
 To post to this group, send email to excel-...@googlegroups.com 
 javascript:.
 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$$ VBA help required for specific Output from Input

[Vaibhav Joshi]

Sach,

Amended code to suits your need..

Cheers!!

On Fri, Jan 16, 2015 at 5:28 PM, sach so itssac...@gmail.com wrote:

 Dear Expert,

 I required some changes in VBA, file attached here.  I have data sheet,
 for Input i have input sheet  for output have output sheet. when I run
 macro i will get output.

 *My requirment- *In data sheet if product  product id is allocated then
 macro need to pick next (non allocated) value for given input, when i run
 macro.

 Kindly do the needful.

 Regards,
 Sachin

 --
 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.


Book11_SP (1).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ VBA help

[Vaibhav Joshi]

Hi

Can you share sample data with desired result..

Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Tue, Nov 11, 2014 at 1:17 PM, Mandeep Baluja rockerna...@gmail.com
wrote:

 I have made this code for I have two worksheets that are in the same
 workbook.

 I want to check the values of WS 2, Column B to WS 1, Column B. If there
 is a match, then copy/write the row of WS1 to WS 2. but in my code I am
 retreiving the values through cells one by one I want *if cell matches
 criteria whole row will get copies and paste to next celll. *

 Sub compareranges()

 'Specify the two ranges
 Dim Firstrng As Range
 Dim secondrng As Range
 Dim i As Integer
 Dim j As Integer


 Set Firstrng = Application.InputBox(Enter first rng, select rng, ,
 Type:=8)
 Set secondrng = Application.InputBox(Enter Second rng, select rng, ,
 Type:=8)

 Debug.Print Firstrng.Address
 Debug.Print secondrng.Address

 For i = 2 To Firstrng.Rows.Count


 For j = 2 To Firstrng.Rows.Count

 If Sheets(2).Cells(i, 2).Value = Sheets(1).Cells(j, 2).Value Then

 Sheets(2).Cells(i, 2).Offset(0, 1).Value = Sheets(1).Cells(j, 2).Offset(0,
 1).Value
 Sheets(2).Cells(i, 2).Offset(0, 2).Value = Sheets(1).Cells(j, 2).Offset(0,
 2).Value
 Sheets(2).Cells(i, 2).Offset(0, 3).Value = Sheets(1).Cells(j, 2).Offset(0,
 3).Value
 Sheets(2).Cells(i, 2).Offset(0, 4).Value = Sheets(1).Cells(j, 2).Offset(0,
 4).Value

 End If

 Next j

 Next i


 End Sub

 --
 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$$ VBA help

[NOORAIN ANSARI]

Dear Pavan,

Please use..

Sub Close_excelApplication()
Application.Quit
End Sub

-- 
Thanks  regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com



On Tue, May 29, 2012 at 3:18 PM, Pavan Chowdary
pavansai.vall...@gmail.comwrote:

 Hi,

 This is pavan.
 Here i had a doubt. is there any vba code to close whole excel application?
 if it there you please let me know by reply to this mail.

 Thanks,
 Pavan

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ VBA Help

[Mahesh parab]

Hi Pavan

Try

Public Sub CloseAll()
Dim WB As Workbook
Application.DisplayAlerts = False
For Each WB In Workbooks
If Not WB.Name = ThisWorkbook.Name Then
WB.Close SaveChanges:=False ' Or True if you want changes saved
End If
Next WB
ThisWorkbook.Close SaveChanges:=False
End Sub

HTH
Mahesh

On Thu, Mar 8, 2012 at 3:18 PM, pavan chowdary
pavansai.vall...@gmail.comwrote:

 Hi,

 This is pavan.
 Here i had a doubt. is there any vba code to close whole excel application?
 if it there you please let me know by reply to this mail.

 Thanks,
 Pavan.

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ VBA Help

[NOORAIN ANSARI]

Dear pavan,

Apart of Mahesh code,
You can use also below code to close all excel application even
Thisworkbook also

Sub Excel_Application_Close()
Dim wb As Workbook
For Each wb In ActiveWorkbook
wb.Close Savechanges:=True
Next
Application.Quit
End Sub


On Thu, Mar 8, 2012 at 3:18 PM, pavan chowdary
pavansai.vall...@gmail.comwrote:

 Hi,

 This is pavan.
 Here i had a doubt. is there any vba code to close whole excel application?
 if it there you please let me know by reply to this mail.

 Thanks,
 Pavan.

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Thanks  regards,
Noorain Ansari
 *http://noorainansari.com/* http://excelmacroworld.blogspot.com/
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ VBA Help

[Bé Trần Văn]

2012/3/9 NOORAIN ANSARI noorain.ans...@gmail.com

 Dear pavan,

 Apart of Mahesh code,
 You can use also below code to close all excel application even
 Thisworkbook also

 Sub Excel_Application_Close()
 Dim wb As Workbook
 For Each wb In ActiveWorkbook
 wb.Close Savechanges:=True
 Next
 Application.Quit
 End Sub


  On Thu, Mar 8, 2012 at 3:18 PM, pavan chowdary 
 pavansai.vall...@gmail.com wrote:

 Hi,

 This is pavan.
 Here i had a doubt. is there any vba code to close whole excel
 application?
 if it there you please let me know by reply to this mail.

 Thanks,
 Pavan.

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




 --
 Thanks  regards,
 Noorain Ansari
  *http://noorainansari.com/* http://excelmacroworld.blogspot.com/
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/


 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com



You put the code in the module, you run to close the Macro File name
CloseExcel

Public Sub CloseExcel()
Dim Excel As Workbook
Application.DisplayAlerts = False
For Each Excel In Workbooks
If Not Excel.Name = ThisWorkbook.Name Then
Excel.Close SaveChanges:=False
End If
Next Excel
Application.Quit
End Sub

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ VBA Help

[dguillett1]

This simple one liner leaves


sub closewholeexcelapplication()
application.quit
end sub

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: pavan chowdary 
Sent: Thursday, March 08, 2012 3:48 AM
To: excel-macros 
Subject: $$Excel-Macros$$ VBA Help

Hi, 

This is pavan.
Here i had a doubt. is there any vba code to close whole excel application?
if it there you please let me know by reply to this mail.

Thanks,
Pavan.
-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

RE: $$Excel-Macros$$ vba help

[Naresh Veerabomma]

Thanks for your reply...

Can you please do a small favour for me.

Now I want to copy the same data not in to more sheets, it should be into 
different workbooks.






Thanks and Regards,
Naresh V,
Sr Analyst,
iSpace global services India pvt ltd.

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Paul Schreiner
Sent: Friday, September 09, 2011 9:42 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vba help

If you do it that way, you're going to skip some rows:

first loop:
i = 1, selects 1 to 200
  i = i + 200 = 201
second loop: INCREMENTS i
i = 201, for loop increments to 202, selects 202 to 401
  i = i + 200 = 402
loop increments 402 to 403,
  selects 403-602

what you SHOULD use for the loop is:

For I = 1 to 2000 step 200

that way, the loop is:
I = 1
I = 201
I = 401
I = 601
etc.


Paul

-
Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can. - John Wesley
-



From: ashish koul koul.ash...@gmail.com
To: excel-macros@googlegroups.com
Sent: Fri, September 9, 2011 11:40:55 AM
Subject: Re: $$Excel-Macros$$ vba help

Sub breaksheet_data()

For i = 1 To 2000
Sheets(1).Rows(i  :  i + 199).Copy
Sheets.Add After:=Sheets(Sheets.Count)
Cells(1, 1).Select
ActiveSheet.Paste
i = i + 200

Next

End Sub


On Fri, Sep 9, 2011 at 12:47 PM, naresh v 
naresh.veerabo...@gmail.commailto:naresh.veerabo...@gmail.com wrote:
Hi Group,

   I have one excel sheet with 2000 records. i want to split those records.

those 2000 records should copy into moresheets

for ex:
main sheet -- 2000 records;
sheet1 -- 1 to 200
sheet2 -- 201 to 400
sheet3 -- 401 to 600
.
.
.
sheet10 -- 1801 to 2000

thanks in advance


regards,
naresh v

--
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
Regards

Ashish Koul
akoul.blogspot.comhttp://akoul.blogspot.com/
http://akoul.posterous.com/
akoul.wordpress.comhttp://akoul.wordpress.com/
My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.


--
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


DISCLAIMER: This e-mail and any attachments are intended only for the 
individual or company to which it is addressed and may contain information 
which is privileged, proprietary, confidential and prohibited from disclosure 
or unauthorized use under applicable law. If you are not the intended recipient 
of this e-mail, you are hereby notified that any use, dissemination, or copying 
of this e-mail or the information contained in this e-mail is strictly 
prohibited by the sender. If you have received this transmission in error, 
please return the material received to the sender and delete all copies from 
your system.


-- 
--
Some important links

Re: $$Excel-Macros$$ vba help

[ashish koul]

Sub breaksheet_data()

For i = 1 To 2000
Sheets(1).Rows(i  :  i + 199).Copy
Sheets.Add After:=Sheets(Sheets.Count)
Cells(1, 1).Select
ActiveSheet.Paste
i = i + 200

Next

End Sub


On Fri, Sep 9, 2011 at 12:47 PM, naresh v naresh.veerabo...@gmail.comwrote:

 Hi Group,

I have one excel sheet with 2000 records. i want to split those
 records.

 those 2000 records should copy into moresheets

 for ex:
 main sheet -- 2000 records;
 sheet1 -- 1 to 200
 sheet2 -- 201 to 400
 sheet3 -- 401 to 600
 .
 .
 .
 sheet10 -- 1801 to 2000

 thanks in advance


 regards,
 naresh v

 --

 --
 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://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
http://akoul.posterous.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ vba help

[Paul Schreiner]

If you do it that way, you're going to skip some rows:

first loop:
i = 1, selects 1 to 200
  i = i + 200 = 201
second loop: INCREMENTS i
i = 201, for loop increments to 202, selects 202 to 401
  i = i + 200 = 402
loop increments 402 to 403,
  selects 403-602

what you SHOULD use for the loop is:

For I = 1 to 2000 step 200

that way, the loop is:
I = 1
I = 201
I = 401
I = 601
etc.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: ashish koul koul.ash...@gmail.com
To: excel-macros@googlegroups.com
Sent: Fri, September 9, 2011 11:40:55 AM
Subject: Re: $$Excel-Macros$$ vba help



Sub breaksheet_data()

For i = 1 To 2000
Sheets(1).Rows(i  :  i + 199).Copy
Sheets.Add After:=Sheets(Sheets.Count)
Cells(1, 1).Select
ActiveSheet.Paste
i = i + 200

Next

End Sub


On Fri, Sep 9, 2011 at 12:47 PM, naresh v naresh.veerabo...@gmail.com wrote:

Hi Group,

       I have one excel sheet with 2000 records. i want to split those records.

those 2000 records should copy into moresheets

for ex:
main sheet -- 2000 records;
sheet1 -- 1 to 200
sheet2 -- 201 to 400
sheet3 -- 401 to 600
.
.
.
sheet10 -- 1801 to 2000

thanks in advance


regards,
naresh v

--
--

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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



-- 

Regards
 
Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/

akoul.wordpress.com
My Linkedin Profile
 
PBefore printing, think about the environment. 
-- 
--

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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ VBA Help

[C.G.Kumar]

You can use EDATE if using Excel  2007. Rest you can define in Macro.


Regards,

C.G.Kumar


On Sat, Oct 23, 2010 at 12:07 AM, halpie97 shal...@sterlingstamos.comwrote:

 I'm a beginner with VBA and looking for some guidance in how to
 establish what I'm trying to do.

 Column A   Column B   Column C   Column D
 1/15/2010   6/30/2009
 3/2/2010 4/15/2008

 I'm trying to create a VBA formula that will do the following in
 columns C and D:
 Column C should just be one year from Column A and insert the new
 date.
 Column D should be 180 days from Column B only if the date in Column A
 is less than 180 days and column B is greater than Column B.
 (Bascially trying to create a schedule for a date stamp of one year
 from Column A and then 180 dats from Column B but not if Column A
 happened within the 180 days).

 I'm looking for the function to insert the calcuated date value in
 both columns C and D for future reference.

 Thanks in advance for the help.

 --

 --
 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://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 
Regards,

C.G.Kumar

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ VBA Help

[Srinivasan Ethirajalu]

refer attachment


On Sat, Oct 23, 2010 at 9:35 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:

 You can use EDATE if using Excel  2007. Rest you can define in Macro.


 Regards,

 C.G.Kumar


 On Sat, Oct 23, 2010 at 12:07 AM, halpie97 shal...@sterlingstamos.comwrote:

 I'm a beginner with VBA and looking for some guidance in how to
 establish what I'm trying to do.

 Column A   Column B   Column C   Column D
 1/15/2010   6/30/2009
 3/2/2010 4/15/2008

 I'm trying to create a VBA formula that will do the following in
 columns C and D:
 Column C should just be one year from Column A and insert the new
 date.
 Column D should be 180 days from Column B only if the date in Column A
 is less than 180 days and column B is greater than Column B.
 (Bascially trying to create a schedule for a date stamp of one year
 from Column A and then 180 dats from Column B but not if Column A
 happened within the 180 days).

 I'm looking for the function to insert the calcuated date value in
 both columns C and D for future reference.

 Thanks in advance for the help.

 --

 --
 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://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




 --
 Regards,

 C.G.Kumar

  --

 --
 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://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 
Srinivasan Ethirajalu,
+919840544295

-- 
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts


dates.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ VBA Help

[rf1234 rf1234]

Hello Dear,
You can bind the uses of VBA for specific industry.I am working with
mainframe and
we have to record the jcl log,We send all jcl log to the VBA Admin to
arrange it date/time wise
according to time.


but my others friend are working in Other domain,told me that vba is also
important for them also.


vba generally used for automate the result,consolidate sheet and workbook.




I hope it will help.


:) happy to help.







On Sat, Feb 27, 2010 at 9:59 PM, Dilip Pandey dilipan...@gmail.com wrote:

 Hi Chethan,

 Finance, Consulting - Analytics industries (KPO-BPO) uses VBA most, and I
 would suggest you to update your resume in some top job portals and then
 you'll automatic receive job opportunities.


 --
 Thanks  Regards,

 DILIP KUMAR PANDEY
   MBA-HR,B.Com(Hons),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 62, India


 On 2/10/10, chethan Bhadravathi chethan...@gmail.com wrote:

 Hi Everybody,


 i want to know which industry use VBA for excel programming most.?


 So that i can apply for jobs who does VBA excel programming and also
 suggest me the links or websites to apply jobs for VBA excel programming.



 Thanks in advance.



 Regards,
 Chethan

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com
 
 HELP US GROW !!

 We reach over 6,700 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe




  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678

 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ VBA Help

[Paul Schreiner]

Shiv,

Are you not using Excel help?
or are you reading a book and trying to understand it?
Or are you in school and this is your homework?

 
Option Explicit Statement 
Used at module level to force explicit declaration of all variables in that 
module.
Syntax
Option Explicit
Remarks
If used, the Option Explicit statement must appear in a module before any 
procedures.
When Option Explicit appears in a module, you must explicitly declare all 
variables using the Dim, Private, Public, ReDim, or Static statements. If you 
attempt to use an undeclared variable name, an error occurs at compile time.
If you don't use the Option Explicit statement, all undeclared variables are of 
Variant type unless the default type is otherwise specified with a Deftype 
statement.
   Note
Use Option Explicit to avoid incorrectly typing the name of an existing 
variable or to avoid confusion in code where the scope of the variable is not 
clear. 


Application.InputBox Method 
 Displays a dialog box for user input. Returns the information entered in the 
dialog box. 
expression.InputBox(Prompt, Title, Default, Left, Top, HelpFile, HelpContextID, 
Type)


UCase Function 
Returns a Variant (String) containing the specified string, converted to 
uppercase.
Syntax
UCase(string)
The required string argument is any valid string expression. If string contains 
Null, Null is returned.
Remarks
Only lowercase letters are converted to uppercase; all uppercase letters and 
nonletter characters remain unchanged.
 
 
so: 
MonthOfSales = InputBox(prompt:= Enter month of sales,  title:= Month)
 
prompts the user to enter a month and stores it in the variable MonthOfSales
 
then:
Range(A1).Value = UCase(MonthOfSales)

converts MonthOfSales to uppercase and puts it in Cell A1.


P



From: Shiv Goel shivyn...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, February 11, 2010 2:34:06 AM
Subject: $$Excel-Macros$$ VBA Help


Option Explicit

Sub InputSales()
 Dim MonthOfSales As String
 Dim SalesData(1 to 4)
 MonthOfSales = InputBox(prompt:= Enter month of sales, _
  title:= Month)
 SalesData(1) =InputBox(prompt:= Enter sales for week 1)
 SalesData(2) =InputBox(prompt:= Enter sales for week 2)
 SalesData(3) =InputBox(prompt:= Enter sales for week 3)
 SalesData(4) =InputBox(prompt:= Enter sales for week 4)
 Range(A1).Value = UCase(MonthOfSales)
 Range(B2:E2).Cells(1).Value = SalesData(1)
 Range(B2:E2).Cells(2).Value = SalesData(2)
 Range(B2:E2).Cells(3).Value = SalesData(3)
 Range(B2:E2).Cells(4).Value = SalesData(4)
 Range(B2:E2).NumberFormat = £0.00
 Columns(A:E).EntireColumn.AutoFit
End Sub
Can any body help me out to crack this code


1. Why they use Option Explicit

2. What is the meaning of this code Range(A1).Value = UCase(MonthOfSales)

3. What is the meaning of this codeMonthOfSales = InputBox(prompt:= Enter 
month of sales, _
  title:= Month)








-- 
Shiv Goel
8NBYN060
ICFAI National College,YNR
9416275776
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com

HELP US GROW !!
 
We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com

HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe