WHAT I AM WANTING TO DO:
I have a userform that I use for entry purposes.
I have a second form that I use for editing the previous entries. The second form (editing form) largely mirrors the entry form, save for a few additional fields that are not present on the entry form.
I recently redesigned my entry form (pretty much completely from the ground up) and now updating the editing version of that form is going to be (somewhat) of a major task since almost all of the fields are new.
What I would like to do is take the existing entry form and duplicate it for use of the editing form (not a problem, that parts easy), but I would like to be able for all the existing objects (just the checkboxes, actually) and rename them the same name as the entry form but with a "1" at the end. Maybe there is a simpler way to do this, but what I was thinking was this: have a script capture all the object names (again, just checkboxes, if thats even possible) and then I can take those names it captured, copy-paste them into another worksheet and then I'll just add a "1" to the end of all of them. Then, run another script to append all those new names in place of the original ones on the editing form.
Is that even possible? Or.. is there another (simpler) way of executing what I have described? or, would I be better off just toggling through all of them and manually adding a "1' to each of the names as what I am trying to do would take more time than to simply go and change them all?
Thanks for any suggestions or ideas.
I have a userform that I use for entry purposes.
I have a second form that I use for editing the previous entries. The second form (editing form) largely mirrors the entry form, save for a few additional fields that are not present on the entry form.
I recently redesigned my entry form (pretty much completely from the ground up) and now updating the editing version of that form is going to be (somewhat) of a major task since almost all of the fields are new.
What I would like to do is take the existing entry form and duplicate it for use of the editing form (not a problem, that parts easy), but I would like to be able for all the existing objects (just the checkboxes, actually) and rename them the same name as the entry form but with a "1" at the end. Maybe there is a simpler way to do this, but what I was thinking was this: have a script capture all the object names (again, just checkboxes, if thats even possible) and then I can take those names it captured, copy-paste them into another worksheet and then I'll just add a "1" to the end of all of them. Then, run another script to append all those new names in place of the original ones on the editing form.
Is that even possible? Or.. is there another (simpler) way of executing what I have described? or, would I be better off just toggling through all of them and manually adding a "1' to each of the names as what I am trying to do would take more time than to simply go and change them all?
Thanks for any suggestions or ideas.
