front end form

[Andy T]

Hi

I am very very new to excel but I need to start somewhere. I have a
little project I have started BUT I w ant to make it look less like an
excel spread sheet as that will put some users off. I would like to
have a nive little form that shows on scren instead.

I know a mate of mine years ago used VB to create a front end but
wondered if excel could do this on its own!?

thanks in advance
Regards Andy T

 

[Tom Ogilvy]

You can use a userform as an interface and hide the excel application, but
it will be visible for a very short time before this can happen, so It
wouldn't be possible to completely deny that knowledge.

 

[Andy T]

You can use a userform as an interface and hide the excel application, but
it will be visible for a very short time before this can happen, so It
wouldn't be possible to completely deny that knowledge.

not a problem that I dont wish to claim to be Bill gates but I dont
like the numbers down the left hand sdie showing as it confuses the
uses I want to see the sheet!

All I want them to see is the data and links

where do i find info on user forms then please??
Regards Andy T

 

[Bob Phillips]

If that is all you don't like, Tools>Options>View and uncheck Row and column
headers.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Tom Ogilvy]

http://j-walk.com/ss/excel/tips/tip84.htm

See this tutorial here
http://www.dicks-blog.com/excel/2004/09/linking_userfor.html

http://support.microsoft.com/default.aspx?scid=kb;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel


XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749


Here are some other sources of information:

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp