Know it is totally related to Excel and Office.

should be

No, it is totally related to Excel and Office.

--
Regards,
Tom Ogilvy

Tom Ogilvy wrote in message
...
Know it is totally related to Excel and Office. It puts up a dialog that
looks like a light switch plate and the textboxes look like where the
switch
goes - how ever it isn't used as a mask for the worksheet - the
information
is typed in the holes and the code transfers the information to the
appropriate cells.



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
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

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


http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


John Walkenbach's site:
http://j-walk.com/ss/excel/tips/userformtips.htm
Userform Tips

Peter Aiken Articles:

watch word wrap. the URL should all be one line.
Part I

http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartI.asp
Part II

http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartII.asp


--
Regards,
Tom Ogilvy


mike allen wrote in message
...
i do not know what a userform is.
is it something totally unrelated to excel?

"Tom Ogilvy" wrote in message
...
It sounds like you are describing userform with textboxes - If you
know
what
a userform its, then maybe not, but that is what it sounds like.

--
Regards,
Tom Ogilvy

mike allen wrote in message
...
i have seen formatting that looks like a lightswitch cover in a
house:
a
plastic plate w/ rectangular holes where the lightswitches come out.
on
a
spreadsheet, this is used to make it obvious where you are to input
data
(the rectangular holes, or cells) and obvious where you are NOT
supposed
to
input data (the plastic plate, or protected unwritable cells).

say i want to only allow inputs in cells a4, a5, d4, and d5 and not
allow
inputs in any other cell on the sheet. i know i can protect all but
these
4, then shade w/ colors, bold, etc. but it doesn't look as
good/professional
as this "plate" effect. any thoughts? thanks, mike allen