View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How To: create a form for a user to enter data

Ciscolo

You should have a look at John Walkenbach's "enhanced data form" add-in.

May do what you want.

For a nominal fee you can get the source code to make modofications for
customizing.

http://www.j-walk.com/ss/dataform/index.htm

Gord Dibben Excel MVP

On 15 Apr 2004 17:27:36 -0700, (Ciscolo Bandero) wrote:

I'm rather new to Excel and know nothing about VBS. I was trying to
find a way to create a form so I could enter data onto a worksheet.
Something along the lines of a button on the worksheet and that opens
a form to enter data that is entered to the sheet after the entry is
complete.

I've already tried using the Data|Forms option, even recorded a macro
that was actuated by a button placed on the worksheet.

So my question is this. Considering my skills, VB looks rather
complicated. Is the feat mentioned above doable or should I look at
quite a bit of reading/research before attempting?