Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
displaying the user form data
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
displaying the user form data
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 -- Work performed in the spirit of service is worship...Baha'i Writings "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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200606/1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
displaying the user form data
Hello Ian,
The sequence in column A will always be in multiples of 10. Ian Digby wrote: 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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200606/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying data in bar form on a line chart | Charts and Charting in Excel | |||
Problem displaying a calculation result in a user form | Excel Programming | |||
MultiPage Form data not displaying when Value property changed | Excel Programming | |||
Displaying Cell Data on a Form | Excel Programming | |||
Displaying part of a sheet on a user form | Excel Programming |