Thread: Data Forms
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Data Forms

From John's site:

The Enhanced Data Form is free, and is not crippled in any way. It is provided
with no strings attached, no nag messages, and no ads. It can be freely
distributed and used without a license. However, it may not be sold, or included
as part of any other product without the written permission of J-Walk &
Associates.

===
If you bought the source, you could include it in your workbook's project. If
you don't, it looks like you'd have to use separate files.



Cydney wrote:

Is it possible to "embed" this add-in so people have it pre-installed when I
distribute the Excel workbook?
--
THX cs

"Dave Peterson" wrote:

Maybe you can design your own form and control everything that happens.

John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Cydney wrote:

Hi, I'm suggesting that users of a very large spreadsheet use "Data | Forms"
to add or edit data to the sheet. However, for ease of knowing what changes
and additions have been made, I created a macro that highlights the
background color of the cell on the "On change" event of the worksheet. But
it doesn't seem to work when you use the Form. How can I make this happen?
--
THX cs


--

Dave Peterson


--

Dave Peterson