Re: $$Excel-Macros$$ Dependent Combo box

2014-02-23 Thread Rupesh Patil 
Dear Ravinder,

Thanks your quick reply. I got same error. at
ufmailfrom.Controls(cntrl.Name).Value = ufmailfrom.cb_all.Value line Run
time error 380.


On Mon, Feb 24, 2014 at 10:40 AM, Ravinder wrote:

> PFA. IF HELPS
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil
> *Sent:* Saturday, February 22, 2014 4:51 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Dependent Combo box
>
>
>
> Hi Expert,
>
>
>
> I need your help, I have one multipage with 11 combo boxes. all combo box
> have same value, value are "Yes", "No", "Don't No".
>
> there is one combo box called "All"
>
>
>
> what I want is that suppose user select("Yes") value from "All" combo box,
> other combo boxes value should be same ("Yes") as "All" selected or if user
> select "No" then others values should be "No"
>
>
>
> For your reference I have attache demo file, please help
>
>
>
> --
>
> Thanks and Regards, Rp.
>
> --
> 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/groups/opt_out.
>



-- 
Thanks and Regards, Rp.

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

RE: $$Excel-Macros$$ Dependent Combo box

2014-02-23 Thread Ravinder 
PFA. IF HELPS

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Saturday, February 22, 2014 4:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Dependent Combo box

 

Hi Expert,

 

I need your help, I have one multipage with 11 combo boxes. all combo box
have same value, value are "Yes", "No", "Don't No". 

there is one combo box called "All" 

 

what I want is that suppose user select("Yes") value from "All" combo box,
other combo boxes value should be same ("Yes") as "All" selected or if user
select "No" then others values should be "No"

 

For your reference I have attache demo file, please help 

 

-- 

Thanks and Regards, Rp.

-- 
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/groups/opt_out.


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

Re: $$Excel-Macros$$ Dependent Combo box

2014-02-23 Thread Rupesh Patil 
Dear Ashish,

Thanks you very much. I tried you code and I got this run time error "Run
time Error '380' could not set the value property. Invalid property value".
could you please assist me  why this error come.

Thanks and regards, Rp


On Sat, Feb 22, 2014 at 7:13 PM, ashish koul  wrote:

> Private Sub cb_all_Change()
> Dim cnt As Control
>
> If Me.cb_all.Value = "Yes" Then
> For Each cnt In Me.Controls
> If TypeName(cnt) = "ComboBox" Then
> cnt.Value = Me.cb_all.Value
> End If
> Next
> End If
> End Sub
>
>
> On Sat, Feb 22, 2014 at 4:50 PM, Rupesh Patil 
> wrote:
>
>> Hi Expert,
>>
>> I need your help, I have one multipage with 11 combo boxes. all combo box
>> have same value, value are "Yes", "No", "Don't No".
>> there is one combo box called "All"
>>
>> what I want is that suppose user select("Yes") value from "All" combo
>> box, other combo boxes value should be same ("Yes") as "All" selected or if
>> user select "No" then others values should be "No"
>>
>> For your reference I have attache demo file, please help
>>
>> --
>> Thanks and Regards, Rp.
>>
>> --
>> 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.
>>
>
>
>
> --
> *Regards*
>
> *Ashish Koul*
>
>
> *Visit*
> http://www.excelvbamacros.in
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>
>
> --
> 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.
>



-- 
Thanks and Regards, Rp.

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

$$Excel-Macros$$ VBA Code to access pictures from drive C

2014-02-23 Thread Hilary Lomotey 
Hello Experts,

embedding pictures in excel sheet can take a lot of size so i need an
assistance with  a code to access pictures based on a drop down selection.
ie assuming i have a combo box with three names a, b and c, if i select a i
want to link it to a particular picture on the c drive.  kindly assist with
code. 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/groups/opt_out.

Re: $$Excel-Macros$$ Macro to Download csv file from a dynamic date based url to a specified file location

2014-02-23 Thread Shankhajit Srimani 
Ashish,

Thanks a lot for the help. This does 90% of what I am looking for. This is
awesome and thanks yet again.. However, I require a little more help from
your end please, if possible.

How do I get some form function (like a button) to trigger popping up  pop
up box which will ask for a date range like 'From Date' and 'To
Date'..basically I want to input this date range and want that the url I
specified 
http://nseindia.com/content/nsccl/fa...i_21022014.csv*the
last portion * '21022014' is a dynamic value that I want to be called from
the Date range input I provide. So if I provide 01-02-2014 to 21-02-2014
(preferably if these r calendar fields), then it should download me 15
files (exclude saturday, sunday and holidays in the range) from the website
archive databaselike *http://nseindia.com/content/nsccl/fa...i_20022014.csv
,
**http://nseindia.com/content/nsccl/fa...i_19022014.csv
 and so
on*

*I see you have provided some code. Not sure how or where to use them to
get it merged with my main requirement. In terms of the links you provided,
I find myengineering link very useful..*

*Thanks in advance. Eagerly waiting for your response.*

*Regards*
*Shankhajit*


On Sun, Feb 23, 2014 at 1:52 PM, ashish koul  wrote:

>
> http://www.myengineeringworld.net/2013/11/excel-vba-download-internet-files.html
>
>
> http://www.lazerwire.com/2011/11/excel-vba-download-files-from-internet.html
>
> http://www.cpearson.com/excel/downloadfile.aspx
>
> Declare Function URLDownloadToFile Lib "urlmon" Alias _
> "URLDownloadToFileA" (ByVal pCaller As Long, _
> ByVal szURL As String, _
> ByVal szFileName As String, _
> ByVal dwReserved As Long, _
> ByVal lpfnCB As Long) As Long
>
> Function DownloadFile(URL As String, LocalFilename As String) As Boolean
> Dim lngRetVal  As Long
> lngRetVal = URLDownloadToFile(0, URL, LocalFilename, 0, 0)
> If lngRetVal = 0 Then DownloadFile = True
> End Function
>
> Sub downfile()
> 'http://www.cpearson.com/excel/downloadfile.aspx
> Dim sURLAs String
> Dim LocalFilename   As String
> Dim filename As String
>
> Const UNC = "C:\Documents and Settings\Ashish Koul\Desktop\sample
> files\"
> filename = "fao_participant_oi_21022014.csv"
>
> sURL = "
> http://nseindia.com/content/nsccl/fao_participant_oi_21022014.csv";
> LocalFilename = UNC & filename
>
> End Sub
>
>
>
>
>
>
>
> On Sun, Feb 23, 2014 at 12:39 PM, Shankhajit Srimani <
> srimani202...@gmail.com> wrote:
>
>> Hi,
>>
>> I have a requirement to download a lot of historical data files from the
>> archieve of an website. The url goes something like this:
>> *http://nseindia.com/content/nsccl/fa...i_21022014.csv*
>>
>> This downloads file for 21022014 ie. 21-Feb-2014. I need to be able to
>> have a facility to have a selection criteria on my user form (in excel)
>> where I specify a date range and the macro automatically downloads all the
>> valid excel files available within that date range (*files for Saturday,
>> Sunday and some holiday dates will not be available in the website archive
>> database*) one after the other (like at single clcik of button) into a
>> specific location (predefined viz.. c:/Users/EOD files/) on my laptop.
>>
>> Request an urgent help and response please.
>>
>> Regards
>> Shankhajit
>>
>>  --
>> 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.
>>
>
>
>
> --
> *Regards*
>
> *Ashish Koul*
>
>
> *Visit*
> http://www.excelvbamacros.in
> Like

Re: $$Excel-Macros$$ Macro to Download csv file from a dynamic date based url to a specified file location

2014-02-23 Thread ashish koul 
http://www.myengineeringworld.net/2013/11/excel-vba-download-internet-files.html

http://www.lazerwire.com/2011/11/excel-vba-download-files-from-internet.html

http://www.cpearson.com/excel/downloadfile.aspx

Declare Function URLDownloadToFile Lib "urlmon" Alias _
"URLDownloadToFileA" (ByVal pCaller As Long, _
ByVal szURL As String, _
ByVal szFileName As String, _
ByVal dwReserved As Long, _
ByVal lpfnCB As Long) As Long

Function DownloadFile(URL As String, LocalFilename As String) As Boolean
Dim lngRetVal  As Long
lngRetVal = URLDownloadToFile(0, URL, LocalFilename, 0, 0)
If lngRetVal = 0 Then DownloadFile = True
End Function

Sub downfile()
'http://www.cpearson.com/excel/downloadfile.aspx
Dim sURLAs String
Dim LocalFilename   As String
Dim filename As String

Const UNC = "C:\Documents and Settings\Ashish Koul\Desktop\sample
files\"
filename = "fao_participant_oi_21022014.csv"

sURL = "
http://nseindia.com/content/nsccl/fao_participant_oi_21022014.csv";
LocalFilename = UNC & filename

End Sub







On Sun, Feb 23, 2014 at 12:39 PM, Shankhajit Srimani <
srimani202...@gmail.com> wrote:

> Hi,
>
> I have a requirement to download a lot of historical data files from the
> archieve of an website. The url goes something like this:
> *http://nseindia.com/content/nsccl/fa...i_21022014.csv*
>
> This downloads file for 21022014 ie. 21-Feb-2014. I need to be able to
> have a facility to have a selection criteria on my user form (in excel)
> where I specify a date range and the macro automatically downloads all the
> valid excel files available within that date range (*files for Saturday,
> Sunday and some holiday dates will not be available in the website archive
> database*) one after the other (like at single clcik of button) into a
> specific location (predefined viz.. c:/Users/EOD files/) on my laptop.
>
> Request an urgent help and response please.
>
> Regards
> Shankhajit
>
>  --
> 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.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

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

Re: $$Excel-Macros$$ Study material for LOOPS

2014-02-23 Thread xlstime 
Please check below link

http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=122:excel-vba-loops-with-examples-for-loop-do-while-loop-do-until-loop&catid=79&Itemid=475

.

Enjoy
Team XLS



On Sun, Feb 23, 2014 at 11:42 AM, suresh k  wrote:

> Dear Experts,
>
> Anyone having study material for learning all kinds of LOOPS. Please do
> forward.
>
> Many thanks.
>
> /Suresh
>
> --
> 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/groups/opt_out.