[RESOLVED] Office 2000 Questions

[Lochdanon]

Hi Guys / Gals

This is what I'm attempting to do in Office : Create a table with a dropdown list box with various selections in Cell A1 and in B1 the cell will reflect the changes in cell A1

ie: Cell A1 Cell B1
Make selection here Price change here

Now, depending on selection in cell A1 dynamically changes the price in call B1

How can this be done and also keep a running total at the bottom.

If you can't answer my question, can you please point me in a direction or web page that may have some helpful tips.

Thanks in advance.

[StevePorter]

What you ask to do is not difficult to do in Excel using VBA programming. Are you having trouble with the VBA part to develop the dropdown list, or the conditional test that depends on the result of the dropdown selection (or both)? http://forums.windrivers.com/cgi-bin/forum/smilies/cwm3.gif

------------------
Sometimes computer problems require extreme measures. Our hero, the Intrepid Spaceman Spiff, sets his blaster on "deep fat fry..." http://forums.windrivers.com/cgi-bin/forum/smilies/cwm27.gif

[Lochdanon]

Hi,

Yah, its the implementation of the VBA that I seem to be having problems with. Once done in Excel I can then link two documents together and create a cleaned up version for faxing to clients in Word.

[StevePorter]

I'll be glad to give it a shot if you give me some more details about what you're trying to do. How about an example problem for me to set up? http://forums.windrivers.com/cgi-bin/forum/smilies/cwm15.gif

------------------
Sometimes computer problems require extreme measures. Our hero, the Intrepid Spaceman Spiff, sets his blaster on "deep fat fry..." http://forums.windrivers.com/cgi-bin/forum/smilies/cwm27.gif