input fields for users and then organising input data behind

Dinictus · Mar 20th, 2002, 03:30 AM

Hi,

I want to build a small app that starts with a few input screes for users. Like: name, adress, zip code etc.

I want to structure the inputted data in a excel sheet in a way that I get a nice organised set of info. (issue: the data set gets bigger and bigger so the cells in which to paste the date changes every time)

I`m sure I can look this up in a manual but I just looking for some quicks tips like: check out this function and try the following approach for this, etc.

Can anyone get me on the tracks a little bit?
Thanks a whole lot.

Dinictus
Holland.

Audiojoe · Mar 20th, 2002, 03:39 AM

So do you mean you want like a userform that asks the user questions? Then the answers that the users give are formatted into an Excel sheet so that at the end you have a formatted sheet of data taken from the answers they gave?

If this is the case, I have just been working on something very similar. I can send you a sample if you like, plus some pointers about the basics

Dinictus · Mar 20th, 2002, 03:59 AM

Wow that be great!

Will you do that for me?
Is there any way of exchanging a email adres without posting it here?

Audiojoe · Mar 20th, 2002, 04:18 AM

Yeah if you send me a private message. Just go to the top of the screen and under NEW TOPIC you'll see Private Messages. If you click on this and follow the instructions.

I've done a simple userform for you (couldn't send my one due to company privacy policy) but it has all the basics on it. After you've had a look, just private message me with any questions. You could email me but I dont check it very often so may not get back to you for a day or two. Best to Private Message me

Hope it helps

Audiojoe

Mar 20th, 2002, 03:30 AM	#1
Dinictus Board Regular Join Date: Mar 2002 Posts: 162	Hi, I want to build a small app that starts with a few input screes for users. Like: name, adress, zip code etc. I want to structure the inputted data in a excel sheet in a way that I get a nice organised set of info. (issue: the data set gets bigger and bigger so the cells in which to paste the date changes every time) I`m sure I can look this up in a manual but I just looking for some quicks tips like: check out this function and try the following approach for this, etc. Can anyone get me on the tracks a little bit? Thanks a whole lot. Dinictus Holland. __________________ NOx installed

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 03:39 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	So do you mean you want like a userform that asks the user questions? Then the answers that the users give are formatted into an Excel sheet so that at the end you have a formatted sheet of data taken from the answers they gave? If this is the case, I have just been working on something very similar. I can send you a sample if you like, plus some pointers about the basics

Mar 20th, 2002, 03:59 AM	#3
Dinictus Board Regular Join Date: Mar 2002 Posts: 162	Wow that be great! Will you do that for me? Is there any way of exchanging a email adres without posting it here?

Mar 20th, 2002, 04:18 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Yeah if you send me a private message. Just go to the top of the screen and under NEW TOPIC you'll see Private Messages. If you click on this and follow the instructions. I've done a simple userform for you (couldn't send my one due to company privacy policy) but it has all the basics on it. After you've had a look, just private message me with any questions. You could email me but I dont check it very often so may not get back to you for a day or two. Best to Private Message me Hope it helps Audiojoe