chrisham7276
New Member
- Joined
- Feb 16, 2010
- Messages
- 13
Hi,
I am trying to create an Add-in to aid in my study of Memorizing the Bible verses.
I have a developed the VBA code that retrieves its information from a Sheet that contains the verses.
I would like to create an Add-in, but the I would like the Sheet containing the verses to be a part of the add-in when installed.
Is this possible?
thanks,
Chrisham
Excel 2007
I am trying to create an Add-in to aid in my study of Memorizing the Bible verses.
I have a developed the VBA code that retrieves its information from a Sheet that contains the verses.
I would like to create an Add-in, but the I would like the Sheet containing the verses to be a part of the add-in when installed.
Is this possible?
thanks,
Chrisham
Excel Workbook | ||||||||
---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | |||
1 | Week # | This Weeks Verse | Bible Verse | Week Title | Lookup Week | |||
2 | 0 | Josh1:8 This book of the law shall not depart out of thy mouth; but thou shalt meditate therein day and night, that thou mayest observe to do according to all that is written therein: for then thou shalt make thy way prosperous, and then thou shalt have good success. | 15-Feb | Josh1:8 This book of the law shall not depart out of thy mouth; but thou shalt meditate therein day and night, that thou mayest observe to do according to all that is written therein: for then thou shalt make thy way prosperous, and then thou shalt have good success. | Week 1 | Week 1 | ||
3 | 22-Feb | Psa103:1 Bless the LORD, O my soul: and all that is within me, bless his holy name. Psa103:2 Bless the LORD, O my soul, and forget not all his benefits: Psa103:3 Who forgiveth all thine iniquities; who healeth all thy diseases; Psa103:4 Who redeemeth thy life from destruction; who crowneth thee with lovingkindness and tender mercies; | Week 2 | |||||
4 | 1-Mar | Jer9:23 Thus saith the LORD, Let not the wise man glory in his wisdom, neither let the mighty man glory in his might, let not the rich man glory in his riches: Jer9:24 But let him that glorieth glory in this, that he understandeth and knoweth me, that I am the LORD which exercise lovingkindness, judgment, and righteousness, in the earth: for in these things I delight, saith the LORD. | Week 3 | |||||
5 | 8-Mar | Rom8:28 And we know that all things work together for good to them that love God, to them who are the called according to his purpose. | Week 4 | |||||
6 | 15-Mar | Heb4:12 For the word of God is quick, and powerful, and sharper than any twoedged sword, piercing even to the dividing asunder of soul and spirit, and of the joints and marrow, and is a discerner of the thoughts and intents of the heart. | Week 5 | |||||
7 | 22-Mar | 1Cor6:19 What? know ye not that your body is the temple of the Holy Ghost which is in you, which ye have of God, and ye are not your own? 1Cor6:20 For ye are bought with a price: therefore glorify God in your body, and in your spirit, which are God's. | Week 6 | |||||
8 | 29-Mar | Isa53:4 Surely he hath borne our griefs, and carried our sorrows: yet we did esteem him stricken, smitten of God, and afflicted. Isa53:5 But he was wounded for our transgressions, he was bruised for our iniquities: the chastisement of our peace was upon him; and with his stripes we are healed. Isa53:6 All we like sheep have gone astray; we have turned every one to his own way; and the LORD hath laid on him the iniquity of us all. | Week 7 | |||||
9 | 5-Apr | Phi1:6 Being confident of this very thing, that he which hath begun a good work in you will perform it until the day of Jesus Christ: | Week 8 | |||||
Verses |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2 | =IFERROR(VLOOKUP(TODAY()+B2,WeeklyVerse,2),E2) | |
G2 | =VLOOKUP(TODAY()+B2,WeeklyVerse,3) | |
D3 | =D2+7 | |
D4 | =D3+7 | |
D5 | =D4+7 | |
D6 | =D5+7 | |
D7 | =D6+7 | |
D8 | =D7+7 | |
D9 | =D8+7 |
Excel Workbook | |||
---|---|---|---|
Name | Refers To | ||
Verse | =Verses!#REF! | ||
week | ={0;1;2;3;4;5} | ||
WeeklyVerse | =OFFSET(Verses!$D$2,0,0,COUNTA(Verses!$D$2:$D$1048576),3) | ||
Workbook Defined Names |