How To: create a form for a user to enter data
I'm rather new to Excel and know nothing about VBS. I was trying to
find a way to create a form so I could enter data onto a worksheet. Something along the lines of a button on the worksheet and that opens a form to enter data that is entered to the sheet after the entry is complete. I've already tried using the Data|Forms option, even recorded a macro that was actuated by a button placed on the worksheet. So my question is this. Considering my skills, VB looks rather complicated. Is the feat mentioned above doable or should I look at quite a bit of reading/research before attempting? |
How To: create a form for a user to enter data
I can appreciate how you might think VBA looks difficult
but if I can learn anyone can. First and formost, buy a good book. This book might be a good place to start: Microsoft Excel VBA Programming for the Absolute Beginner Second and almost as equal as the first record macros then open the code window. Then hit F8. This will step you through the code one line at a time so you can watch what happens. Third, when you run into a specific problem this is a great forum to get you over the hump. But please be specific Using these three methods you'll be coding in no time. If I had to guess, you could achieve you goal within a month. Good luck! -----Original Message----- I'm rather new to Excel and know nothing about VBS. I was trying to find a way to create a form so I could enter data onto a worksheet. Something along the lines of a button on the worksheet and that opens a form to enter data that is entered to the sheet after the entry is complete. I've already tried using the Data|Forms option, even recorded a macro that was actuated by a button placed on the worksheet. So my question is this. Considering my skills, VB looks rather complicated. Is the feat mentioned above doable or should I look at quite a bit of reading/research before attempting? . |
How To: create a form for a user to enter data
The approach your doing is probably your best bet until you become more familiar. so try this for now.
Put this code in your button's code. and this will automatcally bring up your dataform for all your input Make sure you have headers on all your columns Range("a1").Selec ActiveSheet.ShowDataFor ----- Ciscolo Bandero wrote: ---- I'm rather new to Excel and know nothing about VBS. I was trying t find a way to create a form so I could enter data onto a worksheet Something along the lines of a button on the worksheet and that open a form to enter data that is entered to the sheet after the entry i complete I've already tried using the Data|Forms option, even recorded a macr that was actuated by a button placed on the worksheet So my question is this. Considering my skills, VB looks rathe complicated. Is the feat mentioned above doable or should I look a quite a bit of reading/research before attempting |
How To: create a form for a user to enter data
Ciscolo
You should have a look at John Walkenbach's "enhanced data form" add-in. May do what you want. For a nominal fee you can get the source code to make modofications for customizing. http://www.j-walk.com/ss/dataform/index.htm Gord Dibben Excel MVP On 15 Apr 2004 17:27:36 -0700, (Ciscolo Bandero) wrote: I'm rather new to Excel and know nothing about VBS. I was trying to find a way to create a form so I could enter data onto a worksheet. Something along the lines of a button on the worksheet and that opens a form to enter data that is entered to the sheet after the entry is complete. I've already tried using the Data|Forms option, even recorded a macro that was actuated by a button placed on the worksheet. So my question is this. Considering my skills, VB looks rather complicated. Is the feat mentioned above doable or should I look at quite a bit of reading/research before attempting? |
All times are GMT +1. The time now is 10:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com