LinkBack URL
About LinkBacks
You can use such a form to enter/modify/delete data and display it i.e all of the appropriate table. Data entry can then transfer to your worksheet.
Attached is demo of a userform: does this address ( in principle) your requirement?
You can use such a form to enter/modify/delete data and display it i.e all of the appropriate table. Data entry can then transfer to your worksheet.
Attached is demo of a userform: does this address ( in principle) your requirement?
Last edited by JohnTopley; 10-26-2022 at 11:53 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
This is VERY cool! I think I can definitely find some very useful applications for this, but I don't think it'll work for what I'm intending to achieve in this instance. Basically, I want the experience to be as easy as possible for the user, while still being able to easily see what resources and # of work days they have selected for each installation phase. The way I currently have it set up is what I want it to look like for the user, but I want them to be able to add rows in each phase easily so they are limited to adding only 8 resources. I hope that makes sense. I know it seems easy enough to manually insert a blank row, but believe me, the people I work with wouldn't even be able to figure that out with a full tutorial hahaOriginally Posted by JohnTopley
You cannot add rows via formula so some form of VBA is required
There is no significant difference in selecting via the userform vs selectiing on your sheet with the advantage there is no need to concern the user with adding rows.
vsable to add rows in each phase easilythe people I work with wouldn't even be able to figure that outand somewhat insulting to your colleagues.
And ypu cannot have a scrollable sub-set so you are left with having a fixed range for each phase which will have to bethe likely maximum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks