![]() ![]() Questions I can anticipate now: This will eventually export to some sort of database. Is there any major reasons NOT to use ActiveX controls on a relatively small document? Of course, because some of the Form Controls provide you with the index number of the input so you can use it inside INDEX function. My questions: what is the preferred way to approach using controls in your document? After some digging around I found that ActiveX controls seem to have more power to format it the way I want, BUT people seem to agree that you shouldn't use ActiveX controls unless necessary. I found a work around for the short term, but with scaling it up would lead to a lot of seemingly unnecessary VBA code. It's an expandable document, so I have discovered that hiding/unhiding rows can have some funky results with control forms. I am designing a data entry form for a work project and have decided to use some form of controls to help reduce the amount of data entry points. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. ![]() #Form vs activex controls in excel codeNOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |