displaying the user form data
cyzax7 via OfficeKB.com wrote:
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.
|