PDA

View Full Version : Solved: Forms



JKwan
05-20-2009, 07:16 AM
Right off the bat, I don't deal with Excel forms that much - green newbie.
My question is that is there a quick and dirty way to whip up a form that I can link the fields to the spreadsheet cells (with add, change and delete of records - easily??). I don't want to use the Activesheet.ShowDataForm - it has the simple functions that I need, however, not the look. I need to do something fancier than that - where I can group my fields into logical sections.

Bob Phillips
05-20-2009, 07:28 AM
Then it ain't quick and dirty, you are down to managing it all, the loading, the validation, and the saving.

Sorry!

JKwan
05-20-2009, 07:36 AM
Thanks for the reply. I thought that I may as well ask.... I had that "no quick and dirty" answer in mind already.

Kenneth Hobs
05-20-2009, 07:49 AM
As xld said, it is not trivial. Of course database programs like Access make it easy.

If you are bent on doing it in Excel, there are two approaches, (1) userforms and (2) macros in a sheet. For this last method, this example sort of does it in a view mode. It is more for a mail merge kind of thing. Of course if I were doing a mailmerge I would do it in MSWord. http://www.j-walk.com/ss/excel/tips/tip92.htm

I did an example based on the one above using method (1) with an MSWord mailmerge but it needs a bit of work still. I had most of it done but my hard drive went out.

Kenneth Hobs
05-22-2009, 02:29 PM
I did a bit more work on the example that I was talking about. It not only shows a custom userform for data entry but allows a MailMerge as well. You can select a row and make active and use the AutoFilter and the Advanced Filter to filter the data for the merge as well. I also used my kb api's that create a unique name that was recently accepted.

So, this may be a bit more than you need but here it is.

JKwan
05-23-2009, 06:07 AM
Thanks Kenneth, I will take a look and see what I can learn from it.