Hi,
I'm building a nested userform (5 tabs, split in to a further 5 subsections).
On each of the 25 tabs, I have a series of sliders and linked text box objects, together with some code that updates the text box when a slider is adjusted. The idea is that the user can adjust monthly uplifts/downlifts for each of the categories, so I need to be able to grab the value of the slider for calculations when they click "Go".
As such, I've named each slider something sensible that specifies the page it's on (e.g. "Tab1 Subtab1 Slider1" say for argument).
I'm at the stage of having done this on page 1. I now want to copy the objects in to the other 24 multitab pages. The problem I have is that if I do this, all the object names are lost and replaced by the defaults, e.g. TextBox2, and renaming them is a very time consuming process.
Question
Is there a way of partially retaining the object names but changing the relevant sheet name when I copy on to a new tab. E.g. if I copy my slider1 to tab1, subtab 2, its name becomes "Tab1 Subtab2 Slider1". Fairly sure there must be a way of doing this through code - but not sure how to run VBA on a 'VBA' environment.
Thanks
Bookmarks