Parts lists pop-up

28130

New Member
Joined
Sep 6, 2019
Messages
7
Office Version
  1. 365
Hi there, i made a small parts list. In column A 1-99 each cell will have an item. Ex. A1 saw, A2 hammer, A3 screwdriver. When i click on an item such as A1, I would like a form with labels and text boxes to pop-up. i know i can make a form that matches my headers but i would like certain things to be only in the pop-up window only such as the description. Microsoft Access has a home inventory asset details form that pops up when an item is clicked on. Am i able to copy the Access form somehow or am I able to create my own form. Thank you
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Is there a way without using VBA as i have limited coding experience. TY for your time
 
Upvote 0
Not if you want a pop-up form of some description an want to use Excel.
 
Upvote 0
As Fluff alluded to, if you want to use Excel with User Forms, you need to use VBA. You cannot assign values from the Form to the Worksheet without VBA.

You mentioned Access, why not just use Access for the whole thing? When it comes to Forms, I like Access much better, as you can bind the Form fields to Table fields, without having to use VBA to assign them.
 
Upvote 0
Hi, the reason I've used excel is because someone gave the formula to me so every item is adjusted for inflation every year on the first of the year. As in the chair purchased in 2010 would have 9 years of different yearly cpi"s inflation factored in. Where as the table purchased in 2015 would only factor in the last 4 years of inflation. Anal i know, but he got it to work. I don't believe i can incorporate this formula in to access. Thanks for the reply.
 
Upvote 0
I don't believe i can incorporate this formula in to access.
It depends on what the formula looks like (and if it uses some special functions).
But there is a decent chance that it might be able to be done in Access (but I really cannot see without seeing what that formula looks like).
 
Upvote 0
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
ABCDEFG
1ArticleDate AcquiredValueValue Adjusted
for Inflation
YearInflation Rate
2Dining Chairs x 407-May-10$ 800$ 930.8820092.70%
3Dining Table07-May-18$ 1,000$ 1,019.0020101.50%
4Rolecks Watch12-Mar-09$ 25$ 29.8820113%
5Gold Ring Man's14-Feb-13$ 1,500$ 1,641.6220121.70%
6Gold Ring Woman's14-Feb-13$ 3,850$ 4,213.4920131.50%
7Painting "Dogs Playing Poker"01-Jan-88$ 450$ 537.7620140.80%
8Painting "Scenic Scene"01-Jan-10$ 12,500$ 14,545.0720150.70%
920162.10%
1020172.10%
1120181.90%
1220190.00%

<tbody>
</tbody>

Sheet1

Worksheet Formulas
CellFormula
D2=IF(YEAR(B2)>=YEAR(TODAY()),C2,FVSCHEDULE(C2,INDIRECT(ADDRESS(MATCH(MAX(YEAR(B2),$F$2)+1,$F$2:$F$99,0),COLUMN(G1))&":"&ADDRESS(MATCH(YEAR(TODAY()),$F$2:$F$99,0),COLUMN(G1)))))

<tbody>
</tbody>


<tbody>
</tbody>

</body>
ABCDEFG
1ArticleDate AcquiredValueValue Adjusted
for Inflation
YearInflation Rate
2Dining Chairs x 407-May-10$ 800$ 930.8820092.70%
3Dining Table07-May-18$ 1,000$ 1,019.0020101.50%
4Rolecks Watch12-Mar-09$ 25$ 29.8820113%
5Gold Ring Man's14-Feb-13$ 1,500$ 1,641.6220121.70%
6Gold Ring Woman's14-Feb-13$ 3,850$ 4,213.4920131.50%
7Painting "Dogs Playing Poker"01-Jan-88$ 450$ 537.7620140.80%
8Painting "Scenic Scene"01-Jan-10$ 12,500$ 14,545.0720150.70%
920162.10%
1020172.10%
1120181.90%
1220190.00%

<tbody>
</tbody>

Sheet1

Worksheet Formulas
CellFormula
D2=IF(YEAR(B2)>=YEAR(TODAY()),C2,FVSCHEDULE(C2,INDIRECT(ADDRESS(MATCH(MAX(YEAR(B2),$F$2)+1,$F$2:$F$99,0),COLUMN(G1))&":"&ADDRESS(MATCH(YEAR(TODAY()),$F$2:$F$99,0),COLUMN(G1)))))

<tbody>
</tbody>


<tbody>
</tbody>
 
Upvote 0
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
ABCDEFG
1ArticleDate AcquiredValueValue Adjusted
for Inflation
YearInflation Rate
2Dining Chairs x 407-May-10$ 800$ 930.8820092.70%
3Dining Table07-May-18$ 1,000$ 1,019.0020101.50%
4Rolecks Watch12-Mar-09$ 25$ 29.8820113%
5Gold Ring Man's14-Feb-13$ 1,500$ 1,641.6220121.70%
6Gold Ring Woman's14-Feb-13$ 3,850$ 4,213.4920131.50%
7Painting "Dogs Playing Poker"01-Jan-88$ 450$ 537.7620140.80%
8Painting "Scenic Scene"01-Jan-10$ 12,500$ 14,545.0720150.70%
920162.10%
1020172.10%
1120181.90%
1220190.00%

<tbody>
</tbody>

Sheet1

Worksheet Formulas
CellFormula
D2=IF(YEAR(B2)>=YEAR(TODAY()),C2,FVSCHEDULE(C2,INDIRECT(ADDRESS(MATCH(MAX(YEAR(B2),$F$2)+1,$F$2:$F$99,0),COLUMN(G1))&":"&ADDRESS(MATCH(YEAR(TODAY()),$F$2:$F$99,0),COLUMN(G1)))))

<tbody>
</tbody>

<tbody>
</tbody>



This is the general layout with the formula as well.
 
Upvote 0
OK, I see the conundrum. It does use the financial function FVSCHEDULE, which I don't think Access has an equivalent for.

However, you may be able to find/use things that others have come up with, like the stuff found here: https://www.fmsinc.com/MicrosoftAccess/StatisticalAnalysis.html
Of course, you still then need to figure out how to translate your current formula to Access. You might need the assistance of someone who is familiar with those kind of financial statistic formulas.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,916
Members
448,533
Latest member
thietbibeboiwasaco

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