Data Input in Excel

[jerryhouston]

I would like to be able to input data into excel with a easy pop up, that would have inputs for Invoice #, Amount, Account Number, etc.

Does anyone know how to do this or any good links on the web on how to do this?

Thanks.

[Bob Phillips]

Create a userform

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp

Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

[mdmackillop]

Hi Jerry
Welcome to VBAX
Here's a simple example you can expand on. Remember to give your controls meaningful names and always use Option Explicit in your code. I've assumed you may be making multiple entries in a list.
Regards
MD

[jerryhouston]

Thanks for the example. What is the best way to look at it to inderstand how you created it?

Thanks

[mdmackillop]

Have a look at this site from our Resources page
Excel -- UserForms (http://www.contextures.com/xlUserForm01.html)

[jerryhouston]

Thank you, I will take a look and use it.

Thanks again.

[Norie]

Why not use the built-in data form under Data>Form...?

[mdmackillop]

Not a bad idea, Norie. I keep forgetting about that facility.

[Norie]

Personally I would go for a userform, it gives you a lot more control.

The only problem with that is obviously you need a fair bit of code unless
it's just basic data input.

Another option is an add-in, I'm sure I saw one that included an advanced data form but I can't remember where.

[Charlize]

Another option is an add-in, I'm sure I saw one that included an advanced data form but I can't remember where.
I believe J. Walkenbach has created such an enhanced dataform. The use of it is free but if you want to see the code you'll have to pay.

Charlize