userforms
 

I am volunteering for a non-profit charter school that is trying to set up
Excel 2003 to keep the students lunch money accounts straight. We have names
and current account balances, and are wanting to set up a userform(s) that
allow(s) a cashier to click on student's name, then click a command button to
deduct a set amount from account balance. Need two buttons, one for complete
lunch and another for milk only. Then have new balance replace old balance.
Can this be done?

Help! This reference book is sooo thick, and so's my head when it comes to
this stuff!

userforms
 

BeckyH Wrote:
I am volunteering for a non-profit charter school that is trying to se
up
Excel 2003 to keep the students lunch money accounts straight. We hav
names
and current account balances, and are wanting to set up a userform(s
that
allow(s) a cashier to click on student's name, then click a comman
button to
deduct a set amount from account balance. Need two buttons, one fo
complete
lunch and another for milk only. Then have new balance replace ol
balance.
Can this be done?

Help! This reference book is sooo thick, and so's my head when i
comes to
this stuff!

Sounds easy. Could you mail whatever worksheet you have designed fo
the purpose? I need to know the column you are using for balance, fo
names etc. If I can get the worksheet, I can add buttons and necessar
subs to do the work. My address is on the forum.

A V Veerka

--
avveerka
-----------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...fo&userid=3033
View this thread: http://www.excelforum.com/showthread.php?threadid=50667

userforms
 

Good Morning BeckyH
I worked up a userform that will probably meet your need, if you like I
email you copy for the excel program. My email address is
. If you like the form, or think it needs some
changes. Feel free ask. I hope this helps....

Rick, Fbks,AK


"BeckyH" wrote in message
...
I am volunteering for a non-profit charter school that is trying to set up
Excel 2003 to keep the students lunch money accounts straight. We have
names
and current account balances, and are wanting to set up a userform(s) that
allow(s) a cashier to click on student's name, then click a command button
to
deduct a set amount from account balance. Need two buttons, one for
complete
lunch and another for milk only. Then have new balance replace old
balance.
Can this be done?

Help! This reference book is sooo thick, and so's my head when it comes
to
this stuff!