Creating an input box - HELP!

[RandyLWalkerJr]

Hello all,

I hope that someone can help me out with a VBA I am trying to write.

I am hoping to create an input box that has four blank inputs

1) Description 2) Total amount 3) Amount paid 4) This period amount

Then, once I run the macro, I want each of these inputs to fill into the next blank cell in four adjacent columns (F- Description, I-Total Amount, J-Amount Paid, K-This period amount). I then want all the values to disappear so that new inputs can be filled in. Is this possible? Any help at all would be greatly appreciated.

Thanks so much in advance - I am desperate.

 

[Momentman]

Probably what you need is a userform, then on the userform you create 4 textboxes for all the fields you want to add to your workbook

 

[Momentman]

I have made a sample userform for you here. See https://www.dropbox.com/s/dhfwbhw7gfgsxbr/UserformPractice2.xlsm