RE: Can anyone povide step by step instructions on how to do the f



"JLatham" wrote:

There are a couple of approaches to take to easily solve this.

On the same *** you could simply have 2 cells with Data Validation set up
to get the budget category entry and date from and another cell to enter the
amount into and a Worksheet_Change() event to detect when the budget amount
entry changes and go put the amount in the proper cell.

Another way, and this seems a little more like what I think you are looking
for, would be to set up a user form that would do much the same actions - 2
list boxes and an text entry box and a couple of command buttons should do it.

Third way would be to set up much like 1st way I described, but on a
separate *** in the workbook.

If Excel's Help on topics such as Data Validation, the work*** On Change
event and user forms don't get you the information you need, feel free to get
in touch with me at HelpFrom @ jlathamsite.com (remove spaces).


++++++++++++++++++++++++++++++++++++
Thankyou JLatham

Ive now learnt how to create a Data Validation List..

What i did was create 2 fields..
1st field.. Date Selection Validation List
2nd Feild.. Category Of Expense validation List

My only question at this point is...

How do i create a data entry box, then have it so the data entered will
use the validation selections to put the text into the right cell?

EG
Select Date: ( 03 Jan 07 )
Select Expense: (Entertainment)
Enter Amount : ( $25 ) Then press Enter

I want to type $25, hit enter, it saves, and it appears below on the correct
field, it then clears the box for another entry)

Expenses | Home & Garden | Entertainment | Food |
Date
01 jan 07
02 jan 07
03 Jan 07 $25
04 Jan 07
05 Jan 07


thankyou for your patience with this.
.