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 |
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. |
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 |
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 |
All times are GMT +1. The time now is 10:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com