View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin S. Robin S. is offline
external usenet poster
 
Posts: 1
Default SetFocus method in VBA

I'm trying to do some data validation during
the 'LostFocus' event of a textbox. If the validation
test fails, I want to return the user to the textbox.

I'm trying 'txtAmount.SetFocus' which I found in the MSDN,
but I'm getting an error that the method is not supported
by the object. Has SetFocus method been removed from
Office XP? If not, what's the syntax and how can I make
it work?

Robin