Thread: Text Box has the focus
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spencer Hutton Spencer Hutton is offline
external usenet poster
  
Posts: 45
Default Text Box has the focus
i have a form with several text boxes on it. let's just say TextBox1 through
TextBox5. i have Label1, which i wish to display a short help message when
that textbox has the focus. the help statements are in range A1:A5. how can
i translate this message into VBA:
if TextBox1 has the focus then Label1.Caption = range("A1").Value

TIA
Reply With QuoteReply With Quote