Excel macro. how to fix a column so that it could only enter

bkyeong · Apr 10th, 2002, 07:19 AM

in my assignment,i need to fix a few column so that the column only allow user to enter numeric number in that particular column.it will prompt the user if the user enter non numeric number in it.Pls help me since i am new in excel macro.

Von Pookie · Apr 10th, 2002, 08:06 AM

Did the assignment specifically say it had to be a macro?

If not, just use Data Validation.

bkyeong · Apr 10th, 2002, 08:58 PM

he just suggest using excel macro. which 1 is easier? how to use data validation?
pls help.

Apr 10th, 2002, 08:06 AM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Did the assignment specifically say it had to be a macro? If not, just use Data Validation. __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 07:19 AM	#1
bkyeong New Member Join Date: Apr 2002 Posts: 24	in my assignment,i need to fix a few column so that the column only allow user to enter numeric number in that particular column.it will prompt the user if the user enter non numeric number in it.Pls help me since i am new in excel macro.

Apr 10th, 2002, 08:58 PM	#3
bkyeong New Member Join Date: Apr 2002 Posts: 24	he just suggest using excel macro. which 1 is easier? how to use data validation? pls help.