insert elemnts from cells into array, create a userform with values checkboxes
 

Hi all,

i have a slightly complex problem (for me). What I need is to create
new excel worksheets named with the content of some cells in a startoff
sheet.
Let say there are cells in row 5 and column 5,8,11,14 with values
cat,dog,bird,tiger respectively (cells 6,7,9,10,12,13 are empty).
What i need to do is a button that once clicked opens a user forms with
checkboxes for the values of the cell in range (row=5 and columns = 5 to
14) (only those with values, not empty cells). The user then needs to be
able to make a selection of which names he wants to use and once the
selection is made and OK is clicked, excel creats new tabs named with
the user selection (eg cat, dog, bird).

Is there any staight forward way to do this? help is greatly
appreciated

regards
thomas


--
usadream
------------------------------------------------------------------------
usadream's Profile: http://www.excelforum.com/member.php...o&userid=32703
View this thread: http://www.excelforum.com/showthread...hreadid=528582