[This post is based on an email sent to members of the Tayo Solagbade Excel Heaven Visual Basic Automation club]<\/p>\n
\u00a0<\/p>\n
Few days ago, I hinted in a blog post that I was building an ExcelVB driven modeless Floating Automated Data Entry Form<\/a} into the \"simple accounting spreadsheet\" (featured at http:\/\/accountinator.com\/2012\/11\/simple-accounting-spreadsheet-excel\/<\/a><\/p>\n \u00a0<\/p>\n I also wrote an email to that effect, to \"Mark\" the US based owner of the Accountinator.com accounting spreadsheet, adding that I could help him convert it to a full Excel-VB driven software, like mine, complete with smart data entry forms and dynamic report generation menus etc.<\/p>\n \u00a0<\/p>\n Attached to this email are the following:<\/p>\n \u00a0<\/p>\n 1. a copy of the demo version of the spreadsheet with the fully functional auto form.<\/p>\n \u00a0<\/p>\n As you've done for other VBA coded workbooks, you'll need to enable macros when you open this workbook - otherwise the macro buttons in it will not work.<\/p>\n \u00a0<\/p>\n 2. Two screenshot images showing:<\/p>\n \u00a0<\/p>\n A. The Raw Data Entry Table with over 30 fields into which entries are to be made.<\/p>\n \u00a0<\/p>\n This version of the Accountinator.com spreadsheet allows for up to 15,000 rows of entries to be made. It can however be extended to take thousands more.<\/p>\n \u00a0<\/p>\n But the main benefit of automation added here is the modeless Floating Automated Data Entry Form which all entries can be made.<\/p>\n \u00a0<\/p>\n Click the Make Entries button at the top left of the spreadsheet table, to load the auto entry form.<\/p>\n \u00a0<\/p>\n Try posting entries using the drop menus and text fields on the form. The interface is intuitive, so I'm leaving you to play around with it for a few days, to see how it works.<\/p>\n \u00a0<\/p>\n NB: A short video showing me posting entries using the form will be emailed to you later in the week.<\/p>\n \u00a0<\/p>\n B. The Data Entry Table Title Settings Iinterface<\/p>\n \u00a0<\/p>\n To change any of the field\/column titles in the data entry table, this is where you type your changes.<\/p>\n \u00a0<\/p>\n Once you're done, click the sheet tab to go to the data entry table. There you'll see the new title appear in the corresponding field heading.<\/p>\n \u00a0<\/p>\n The change you made will also show up in the drop menu on the floating form's drop menu.<\/p>\n \u00a0<\/p>\n The above shows how one-size-fits-all automation can be used to save time and effort.<\/p>\n \u00a0<\/p>\n \u00a0<\/p>\n","protected":false},"excerpt":{"rendered":" [This post is based on an email sent to members of the Tayo Solagbade Excel Heaven Visual Basic Automation club] \u00a0 Few days ago, I hinted in a blog post that I was building an ExcelVB driven modeless Floating Automated Data Entry Form<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,1375,266,1440,10],"tags":[],"class_list":["post-10111","post","type-post","status-publish","format-standard","hentry","category-employeescareer-persons","category-excel-vb-solutions","category-my-dn-travel-news","category-recommended-websites-articles","category-self-development"],"aioseo_notices":[],"views":803,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/comments?post=10111"}],"version-history":[{"count":2,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10111\/revisions"}],"predecessor-version":[{"id":10113,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10111\/revisions\/10113"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=10111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=10111"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=10111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}