displaying the user form data

[cyzax7 via OfficeKB.com]

Hello there,

I want to create a form that will allow user to enter the value to be
displayed in the excel sheet.
In details:

- User wil enter:

Start number = 10 ==> This will be displayed in column A1
End number = 100 ==> This will be displayed in column A100

Stuff1 = 35 ==> displayed in column C
Stuff2 = 80 ==> displayd in column D

- Once the user has finished entering the form, the output in the sheet will
look like this:

A B C D
Row1: 10 35 80
Row2: 20 35 80
Row3: 30 35 80

 

[Paul Lautman]

Hello there,

I want to create a form that will allow user to enter the value to be
displayed in the excel sheet.
In details:

- User wil enter:

Start number = 10 ==> This will be displayed in column
A1
End number = 100 ==> This will be displayed in column A100

Stuff1 = 35 ==> displayed in column C
Stuff2 = 80 ==> displayd in column D

- Once the user has finished entering the form, the output in the
sheet will look like this:

A B C D
Row1: 10 35 80
Row2: 20 35 80
Row3: 30 35 80
.
.
.
.
Row100: 100 35 80

So, how to create the macro that will looks this way?
I've tried using the array loop, but it doesn't show like described
above.

The simplest way to do this is to go to Data->Form... It will autmagically
do all this for you.

 

[Guest]

Hi there,

Could you please say whether the sequence 10,20,30,40.....in column A will
always be in multiples of 10, or whether you need to choose the multiple?

Regards

Ian

 

[cyzax7 via OfficeKB.com]

Hello Ian,

The sequence in column A will always be in multiples of 10.

Hi there,

Could you please say whether the sequence 10,20,30,40.....in column A will
always be in multiples of 10, or whether you need to choose the multiple?

Regards

Ian

Hello there,

[quoted text clipped - 25 lines]

So, how to create the macro that will looks this way?
I've tried using the array loop, but it doesn't show like described above.