Stand Alone Form

P

Pastel Hughes

I have created a form in Excel which has some limitations which I have been
unable to overcome. Specifically I want to inhibit the user from moving to
the next field until they have provided valid input for the current field. I
think this is possible in Access, however I am uncertain whether an Access
form can act in a "stand alone" capacity. Most of the people using this form
do not and will not have Access resident. This leads to the ultimate
question "what software would be most appropriate under these
circumstances?". Any ideas?
 
D

DL

It is possible in Access, but as you realise it wouldn't appear suitable in
your situation.
I would imagine you would have to use vba in excel to accomplish.

There is specific 'Forms' software available, some of which may be free
 
B

Beth Melton

I'm not sure what you are trying to do exactly, you can add validation
to a UserForm in Excel but if you want it to be completely stand alone
then you need to use an application designed to create stand alone
applications such as VB or VB.Net

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Top