Excel Programming
I recently had a friend ask me how to make a form in MS Excel that allow inputing data into a spreadsheet then auto sort that data so that lookup function could be used to retrieve that data in a layout that was easy to read, whew. Anyone say run on sentence there.
So today I start my new project for cigar buddy MM. This is new for me also, since my excel programs are more lookup and calc then anything else. I never needed a form to add extra data into. So we’ll see how long and hard this will be.
Jun 14, 2009 @ 16:30:35
OK.. that was easier than I thought cause I'm done….Aparently we did not need a complicated dialog box. A simple form at the top a command button and a custom macro assigned to that button did the trick. Now when MM needs to add a new address to his spreadsheet its fast simple and organized. This macro auto inserts a new line of data and then resorts the entire list so that it is searchable using a v-lookup function.