View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default vfp - excel programming

aaaah
thanks Chip :-)

--
Regards
Frank Kabel
Frankfurt, Germany


Chip Pearson wrote:
what is 'VFP'?


Probably Visual FoxPro.



"Frank Kabel" wrote in message
...
Hi
what is 'VFP'?

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Hi,

I try to crate excel validation method in VFP but I can't
do it. Anyone who can convert the following VB syntax to
VFP syntax

With Range("e5").validation
.Add Type:=xlValidateWholeNumber,
AlterStyle:=xlValidAlertStop,
Operator:=xlBetween,
Formula1:="5",
Formula2:="10"
.InputTitle = "Integers"
.ErrorTitle = "Integers"
.InputMessage = "Enter an integer from five to ten"
.ErrorMessage = "You must enter a number from 1 to 10"
End With

Thank you