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.
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.
Create a userform
Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp
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
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thanks for the example. What is the best way to look at it to inderstand how you created it?
Thanks
Have a look at this site from our Resources page
Excel -- UserForms
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thank you, I will take a look and use it.
Thanks again.
Why not use the built-in data form under Data>Form...?
Not a bad idea, Norie. I keep forgetting about that facility.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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.
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.Originally Posted by Norie
Charlize