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

I would suggest that you ask in microsoft.public.excel.programming

This group is for questions in connection with the use of mailmerge and
fields in Word. You are quite a way off topic.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"cyzax7 via OfficeKB.com" u22797@uwe wrote in message
news:61814b0158721@uwe...
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.

--
Message posted via http://www.officekb.com