Thread: Checking Entry
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Checking Entry

A MessageBox does not have input. You are probably referring to an InputBox.

Look at Help for the InputBox Method rather than the InputBox Function. The
former allows you control over the input type.

--

Vasant


"mushy_peas " wrote in message
...
Is there a way of checking the input of a Msgbox in terms of if its
numeric or alphabetical

eg if i only want alphabetical, and someone enter a number or
alpnumric, then get to to display a warning.

Cheers


---
Message posted from http://www.ExcelForum.com/