How to modify a function (i think it's a function at least)?

F

Fish

From the terminology in my question you can tell I'm obviously not very
skilled with Excel (using 2002). I'll try to explain the best I can.

I was provided with a spreadsheet template. Within this template I click on
a "button" of some type. Then a pop up window appears and I enter the
information that relates to what I'm trying to track/log into the
spreadsheet.

Once I enter the info, it automatically places the information in the
appropriate cells in the spreadsheet. The problem is the default settings
within this pop up are no longer accurate.

For example, when I type in a specific product, the purchase price of that
product is no longer correct.

How can I find where the default settings are for this "pop up" and update
them?

Hope I explained that well enough, doubt it, but just maybe...lol.
 
B

Bob Phillips

If it is well designed, those values will be stored in the workbook
somewhere, maybe in a data worksheet, which may or may not be hidden.

Go into the VB IDE (Alt-F11), and see if the number of worksheets in the
explorer window are more than you see. If so, select them one by one and see
if any have a Visible property that is not xlSheetVisible.

Other than that, it will be a case of trawling through the code to see where
it is stored.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top