Info text box

O

One-Leg

Hello,

I'm using Excel to do my budget and I'm trying to figure out a way to create
a macro the, when launched, will give me a box in which I will enter some
details:

Field 1- Date (MM/DD/YYYY)
Field 2- Description
Field 3- In (enter an amount of money in section 3, 4, 5 or 6)
Field 4- Out [Paiements] (enter an amount of money in section 3, 4, 5 or 6) *
Field 5- Out [ATM] (enter an amount of money in section 3, 4, 5 or 6) *
Field 6- Others (enter an amount of money in section 3, 4, 5 or 6) *

* By default, I would need to see "0.00"

Once I click on DONE, it would take the info ond puit them at the bottom of
the list in the correct field:

Field 1 - At the bottom of column A
Field 2 - At the bottom of column B
Field 3 - At the bottom of column C
Field 4 - At the bottom of column D
Field 5 - At the bottom of column E
Field 6 - At the bottom of column F

Thanks!!!
 
D

Dave Peterson

Debra Dalgleish has a short tutorial:
http://contextures.com/xlUserForm01.html

But you may want to try selecting your range
and Data|Form

It may be sufficient.

One-Leg said:
Hello,

I'm using Excel to do my budget and I'm trying to figure out a way to create
a macro the, when launched, will give me a box in which I will enter some
details:

Field 1- Date (MM/DD/YYYY)
Field 2- Description
Field 3- In (enter an amount of money in section 3, 4, 5 or 6)
Field 4- Out [Paiements] (enter an amount of money in section 3, 4, 5 or 6) *
Field 5- Out [ATM] (enter an amount of money in section 3, 4, 5 or 6) *
Field 6- Others (enter an amount of money in section 3, 4, 5 or 6) *

* By default, I would need to see "0.00"

Once I click on DONE, it would take the info ond puit them at the bottom of
the list in the correct field:

Field 1 - At the bottom of column A
Field 2 - At the bottom of column B
Field 3 - At the bottom of column C
Field 4 - At the bottom of column D
Field 5 - At the bottom of column E
Field 6 - At the bottom of column F

Thanks!!!
Click to expand...
 
Top