Dialog Boxes

[nick1408]

Hello all.

I have a workbook with numerous sheets. What I would like is to write a macro that will do the following (in order):

- Copy sheet 1
- Dialog Box to rename new sheet
- Select cell A2
- Dialog Box "Input Date"
- Select cell A3
- Dialog Box "Input 2nd Date"
- Select cell C2
- Dialog Box "Name"
- Select cell E2
- Dialog Box "Input 2nd Name"
- Select cell C3
- Dialog Box "Ranking"
- Select cell E3
- Dialog Box "Input 2nd Ranking"
- Select cell C6
- Dialog Box "Weight 1"
- Select cell E6
- Dialog Box "Weight 2"
- Select cell C7
- Dialog Box "Stride 1"
- Select cell E7
- Dialog Box "Stride 2"
- Select cell C8
- Dialog Box "Med 1"
- Select cell E8
- Dialog Box "Med 2"
- Select cell C9
- Dialog Box "Phys 1"
- Select cell E9
- Dialog Box "Phys 2"
- Select cell C10
- Dialog Box "Vet 1"
- Select cell E10
- Dialog Box "Vet 2"
- Select cell C11
- Dialog Box "Gate 1"
- Select cell E11
- Dialog Box "Gate 2"
- Select cell C12
- Dialog Box "Accell 1"
- Select cell E12
- Dialog Box "Accell 2"
- Select cell C13
- Dialog Box "Muscle 1"
- Select cell E13
- Dialog Box "Muscle 2"
- Select cell C14
- Dialog Box "Stam 1"
- Select cell E14
- Dialog Box "Stam 2"
- Select cell C15
- Dialog Box "Heart 1"
- Select cell E15
- Dialog Box "Heart 2"
- Select cell D11
- Dialog Box "Gen Gate 1"
- Select cell F11
- Dialog Box "Gen Gate 2"
- Select cell D12
- Dialog Box "Gen Accell 1"
- Select cell F12
- Dialog Box "Gen Accell 2"
- Select cell D13
- Dialog Box "Gen Muscle 1"
- Select cell F13
- Dialog Box "Gen Muscle 2"
- Select cell D14
- Dialog Box "Gen Stam 1"
- Select cell F14
- Dialog Box "Gen Stam 2"
- Select cell D15
- Dialog Box "Gen Heart 1"
- Select cell F15
- Dialog Box "Gen Heart 2"
- Select cell N5
- Dialog Box "Starting Rating"

Thanks for the help.

 

[nick1408]

how would I do a userform?

 

[Norie]

Well to start with all you would probably need would be a textbox in place of each dialog.

If you know how to add a textbox or two to a userform that doesn't take as long as you might think.

I just added 4 textboxes in a row with 2 labels.

I then just selected them all and copied them down to create the other textboxes.

That's the easy part, the next part is naming the textboxes and giving the lable captions.

You would need to do that manually and it would be best to use names and captions that mean something.

If that all sounds a bit much you could just start with the first few inputs and once you've got them down you can go on and do the rest.

Also, you can design the form however you want/need - it's not necessary to have a row of 4 textboxes.

You might even want to group some of the related inputs together in a frame.

PS I'm not saying you can't use inputboxes, and the code stefan posted would be a good start for that.

 

[nick1408]

I might have a play around later. At the moment I have Stefan's code working so it is sometihng to work with later