userform template [Resolved]

[chaos7]

hi,

im writing a small program where my form contains 8 command boxes. 5 of these boxes will use the same form that comes up each time the button is pressed (only difference being the title of form, and selections made by user). is there any way of making this easier rather than creating the same form design for each of the 5 buttons (don't think i can copy and paste as not sure if this will affect the individual userforms?? or would templates be an easier solution (not sure how to do that though)? anything that makes it a little easier??) -- any ideas????

thanks

[salvelinus]

When you open the form, set it's caption to whatever title you want based on the button clicked. Same for selections, although since you didn't give any examples of that I can't give you specifics there.

[chaos7]

Hi,

So would copy and pasting a userform to another userform have any effects on the previous userforms settings/procedures?? My code is to basically go through each room in house and set light/temp settings, so i thought all i need is same userform just with the title of userform being different. Wasn't sure if copying and pasting fm one userform to another would alter functionality of the userform??

Thanks..

[westconn1]

what salvelinus suggested ws to use a single form, just change it's caption appropriatly, then save the values entered for each room, then show the same form again with whatever changes needed for the next room

pete