Creating Add-in with Data on a Sheet

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 Workbook
BCDEFG
1Week #This Weeks VerseBible VerseWeek TitleLookup Week
20Josh1: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-FebJosh1: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 1Week 1
322-FebPsa103: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
41-MarJer9: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
58-MarRom8: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
615-MarHeb4: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
722-Mar1Cor6: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
829-MarIsa53: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
95-AprPhi1: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
Excel 2007
Cell Formulas
RangeFormula
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
NameRefers 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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Hi,
Generally speaking no problem - and addin can have worksheets in it. You just have to be carefully when referencing the data so that you are correctly referencing the addin workbook (which is always a hidden workbook) and not the visible workbooks that the user sees.

ξ
 
Upvote 0

Forum statistics

Threads
1,224,599
Messages
6,179,831
Members
452,946
Latest member
JoseDavid

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top