I want to run a macro which asks for inputs from the user to insert into a table. I have got it to work using bookmarks and the ask command but my problem is I need the answer to be rejected if the input is a letter or blank. Is there anyway to get the ask prompt box to be numeric or another way around it?
Instead of using Ask fields, use a UserForm. You can then check what the user has entered into each textbox on the UserForm and take appropriate action. See the article "How to create a Userform" at: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Daren White" wrote in message news:9936DD1F-CBE6-4BC2-9314-5A9CC664491E@microsoft.com... >I want to run a macro which asks for inputs from the user to insert into a > table. I have got it to work using bookmarks and the ask command but my > problem is I need the answer to be rejected if the input is a letter or > blank. Is there anyway to get the ask prompt box to be numeric or another > way > around it?
