PDA

View Full Version : Data Input in Excel



jerryhouston
02-04-2007, 08:45 AM
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
02-04-2007, 08:57 AM
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
02-04-2007, 09:30 AM
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
02-04-2007, 09:47 AM
Thanks for the example. What is the best way to look at it to inderstand how you created it?

Thanks

mdmackillop
02-04-2007, 10:13 AM
Have a look at this site from our Resources page
Excel -- UserForms (http://www.contextures.com/xlUserForm01.html)

jerryhouston
02-04-2007, 10:16 AM
Thank you, I will take a look and use it.

Thanks again.

Norie
02-04-2007, 10:29 AM
Why not use the built-in data form under Data>Form...?

mdmackillop
02-04-2007, 10:31 AM
Not a bad idea, Norie. I keep forgetting about that facility.

Norie
02-04-2007, 11:28 AM
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
02-05-2007, 02:48 AM
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