Combining Macros

[GordonP]

Hi all,

I need help with combining macros and I hope someone out there can put me out of my misery!

I need to write to a macro that when a name is entered into a field, it creates or unhides a worksheet. Also is it possible to combine a macro to do all this at once:
Create sheet & update tab with name entered in cell
The unhidden/created sheet will have a question set of either 5 or 10 (The column range will be 10 or 20 columns) and I need to define by cell entry the numbers of questions that should appear.

I hope this makes sense!

Thanks in advance:banghead:

[Northwolves]

Welcome Gordonp to the board

Your problen is not clearly enough.
Maybe an attachment is helpful.

Best Regrads
Northwolves

[lucas]

Well, it actually raises more questions.

What is a field? Is that a texbox, combobox, etc. on a userform?

Can the new sheet be created from a template?

you need to definde by cell entry the number of questions that should appear? What does this mean. Where do these questions come from?

If you have a small example started it would help if you could post it here. Go to the bottom left of the last post and hit post reply....then scroll down until you find a button that says "manage attachments"

[GordonP]

Hi all,

I've attached a small example of what I am looking for.

Cheers