Macro for adding new items to list
 

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

Macro for adding new items to list
 

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

Macro for adding new items to list
 

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

Macro for adding new items to list
 

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

Macro for adding new items to list
 

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