I have a list for AutoFiltering with the top left corner at A12. I'd
like to have a button that I can push that will bring up prompts to
fill out a new entry.

Also, I'd like the first column to be a drop down list of values in a
Range Name called "TYPE"


--
SanctifiedRock
------------------------------------------------------------------------
SanctifiedRock's Profile: http://www.excelforum.com/member.php...o&userid=34485
View this thread: http://www.excelforum.com/showthread...hreadid=542552

Turn on the macro recorder and then manually apply data validation to the
first column using the List option and specifying your named range as the
source

=Type

No idea what the first part of your question is about. Perhaps use
Data=Form. . .


--
Regards,
Tom Ogilvy


"SanctifiedRock" wrote:


I have a list for AutoFiltering with the top left corner at A12. I'd
like to have a button that I can push that will bring up prompts to
fill out a new entry.

Also, I'd like the first column to be a drop down list of values in a
Range Name called "TYPE"


--
SanctifiedRock
------------------------------------------------------------------------
SanctifiedRock's Profile: http://www.excelforum.com/member.php...o&userid=34485
View this thread: http://www.excelforum.com/showthread...hreadid=542552

I'm creating this for my boss, he knows nothing about Excel, so I'd like
to make a command button that will do the job of Data/Form for him, by
prompting InputBoxes.


--
SanctifiedRock
------------------------------------------------------------------------
SanctifiedRock's Profile: http://www.excelforum.com/member.php...o&userid=34485
View this thread: http://www.excelforum.com/showthread...hreadid=542552

I couldn't imagine going through a series of input boxes to enter data in
cells.

Perhaps you need to put up a userform.

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

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

http://support.microsoft.com/default...b;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.

--
Regards,
Tom Ogilvy


"SanctifiedRock" wrote:


I'm creating this for my boss, he knows nothing about Excel, so I'd like
to make a command button that will do the job of Data/Form for him, by
prompting InputBoxes.


--
SanctifiedRock
------------------------------------------------------------------------
SanctifiedRock's Profile: http://www.excelforum.com/member.php...o&userid=34485
View this thread: http://www.excelforum.com/showthread...hreadid=542552

Thanks muc

--
SanctifiedRoc
-----------------------------------------------------------------------
SanctifiedRock's Profile: http://www.excelforum.com/member.php...fo&userid=3448
View this thread: http://www.excelforum.com/showthread.php?threadid=54255