Database with userforms in excel

robwels · May 22nd, 2002, 05:26 AM

Hi all.
I would like to make for example an adress book, with input trough a userform and store the data in a worksheet with colums name etc.. After that i would like to lookup adresses, change and delete them with a userform. I know how to make a userform buth dont know how to store it in a worksheet and can retrieve the data from a search etc.
Thanks.
Rob

Ian Mac · May 22nd, 2002, 05:45 AM

Quote:

On 2002-05-22 04:26, robwels wrote:
Hi all.
I would like to make for example an adress book, with input trough a userform and store the data in a worksheet with colums name etc.. After that i would like to lookup adresses, change and delete them with a userform. I know how to make a userform buth dont know how to store it in a worksheet and can retrieve the data from a search etc.
Thanks.
Rob

What about using Excel's built in Form found under Data>Form

It has all the features you describe

robwels · May 22nd, 2002, 05:53 AM

thanks for the reply.
I would like to use a userform in vba and save the input in a sheet and also like to search and delete with the same userform.
Thanks
Rob

Ian Mac · May 22nd, 2002, 06:46 AM

Quote:

On 2002-05-22 04:53, robwels wrote:
thanks for the reply.
I would like to use a userform in vba and save the input in a sheet and also like to search and delete with the same userform.
Thanks
Rob

What is the reason behind using VBA, the Form I mention does EXACTLY what you want.

robwels · May 22nd, 2002, 06:53 AM

because i have a userform with about 30 textboxes, printbuttoms, savebottoms ect. and find it has a good look this way for users. i now save every form seperate as a file, buth would like to have one file for all the seperate data.
thanks

Q · May 22nd, 2002, 06:55 AM

From what you have posted and not knowing the use of the spreadsheet it sounds like Access would be a better choice to develop this database.

[ This Message was edited by: Q on 2002-05-22 05:56 ]

Rocky E · May 22nd, 2002, 06:58 AM

Well I vote with Rob. The data form is limited as best as I can tell. If you just want data entry it works fine. If you want a user interface then the user form opens up a whole world of possibilities. Unfortunately like Rob I am not experienced enough to actually create it. It would be interesting to create a basic user form that mimicked the data form.

Let see if the user wants fish we give him a steak, right?

Rocky...

Ian Mac · May 22nd, 2002, 07:07 AM

Quote:

On 2002-05-22 05:58, Rocky E wrote:
Well I vote with Rob. The data form is limited as best as I can tell. If you just want data entry it works fine. If you want a user interface then the user form opens up a whole world of possibilities. Unfortunately like Rob I am not experienced enough to actually create it. It would be interesting to create a basic user form that mimicked the data form.

Let see if the user wants fish we give him a steak, right?

Rocky...

Rocky,

If I may, the orginal question posted was answered quite adequately by my suggestion. Without knowing the full extent I couldn't have known about the Printing, Saving Etc.

Rob,

My apologies, How far have you got with this? if you could provide some more information and any code you have so far.
I doubt VERY much I'll be able to help but others may be able to extend on what you have already.

Sorry I can't help more.

robwels · May 22nd, 2002, 07:46 AM

thanks Rocky.
I dont know how th send all the code, because i use the VBA Editor to create userforms and buttons, the major thing is i want to know how i can save data entry from the userform to the different cels in the worksheet, can search the records and printing and deleting them. Is there a way to send all the code or my excel file ?
Basicly i want to understand how the data can be saved from a userform, looked up again and printed like the first printout and deleted. I have made a range of cells the document printout form. So when i search the record the cells must be updated for a printout and must be in the userform.
I hope you still understand. Otherwise i have to go back to a more simple example....

Also i want to make a compliment for the fast reply's.

Kind regards,

RobDutch

Ian Mac · May 22nd, 2002, 08:19 AM

Quote:

On 2002-05-22 06:46, robwels wrote:
thanks Rocky.
I dont know how th send all the code, because i use the VBA Editor to create userforms and buttons, the major thing is i want to know how i can save data entry from the userform to the different cels in the worksheet, can search the records and printing and deleting them. Is there a way to send all the code or my excel file ?
Basicly i want to understand how the data can be saved from a userform, looked up again and printed like the first printout and deleted. I have made a range of cells the document printout form. So when i search the record the cells must be updated for a printout and must be in the userform.
I hope you still understand. Otherwise i have to go back to a more simple example....

Also i want to make a compliment for the fast reply's.

Kind regards,

RobDutch

As I'm not sure how far you are with this so I've set up a VERY simple example of how to get the details onto the sheet.
If you'd like me to E.mail it I'd be happy to.
This is as far as I can get you (currently).

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

May 22nd, 2002, 05:26 AM	#1
robwels Board Regular Join Date: May 2002 Posts: 74	Hi all. I would like to make for example an adress book, with input trough a userform and store the data in a worksheet with colums name etc.. After that i would like to lookup adresses, change and delete them with a userform. I know how to make a userform buth dont know how to store it in a worksheet and can retrieve the data from a search etc. Thanks. Rob

May 22nd, 2002, 05:53 AM	#3
robwels Board Regular Join Date: May 2002 Posts: 74	thanks for the reply. I would like to use a userform in vba and save the input in a sheet and also like to search and delete with the same userform. Thanks Rob

May 22nd, 2002, 06:53 AM	#5
robwels Board Regular Join Date: May 2002 Posts: 74	because i have a userform with about 30 textboxes, printbuttoms, savebottoms ect. and find it has a good look this way for users. i now save every form seperate as a file, buth would like to have one file for all the seperate data. thanks

May 22nd, 2002, 06:55 AM	#6
Q Board Regular Join Date: Apr 2002 Location: 20 Minutes outside Manhattan Posts: 64	From what you have posted and not knowing the use of the spreadsheet it sounds like Access would be a better choice to develop this database. [ This Message was edited by: Q on 2002-05-22 05:56 ]

May 22nd, 2002, 06:58 AM	#7
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	Well I vote with Rob. The data form is limited as best as I can tell. If you just want data entry it works fine. If you want a user interface then the user form opens up a whole world of possibilities. Unfortunately like Rob I am not experienced enough to actually create it. It would be interesting to create a basic user form that mimicked the data form. Let see if the user wants fish we give him a steak, right? Rocky...

May 22nd, 2002, 07:46 AM	#9
robwels Board Regular Join Date: May 2002 Posts: 74	thanks Rocky. I dont know how th send all the code, because i use the VBA Editor to create userforms and buttons, the major thing is i want to know how i can save data entry from the userform to the different cels in the worksheet, can search the records and printing and deleting them. Is there a way to send all the code or my excel file ? Basicly i want to understand how the data can be saved from a userform, looked up again and printed like the first printout and deleted. I have made a range of cells the document printout form. So when i search the record the cells must be updated for a printout and must be in the userform. I hope you still understand. Otherwise i have to go back to a more simple example.... Also i want to make a compliment for the fast reply's. Kind regards, RobDutch