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

U

usadream

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
selecting cells and getting their content into a string? 1
Named cells in an array to a column and to a row 3
Insert name and adress from a list in a word document 1
Array Substitution Based on Drop Down List 1
Array with many cells from a row but not in order or together 11
Automatically create names from values in cell 2
VBA code manipulation cells 2

Top