displaying the user form data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cyzax7 - 09 Jun 2006 08:58 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 09 Jun 2006 20:46 GMT

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.

Signature

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

> Hello there,
>
[quoted text clipped - 27 lines]
> I've tried using the array loop, but it doesn't show like described
> above.

Reply to this Message