View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nickm687 nickm687 is offline
external usenet poster
 
Posts: 20
Default ActiveCell and TextBox

I have on my worksheet a textbox that i want to display a message
depending on which cell is highlighted.

im using this code for the updatung of the text box
ActiveSheet.TextBox1.Object.Value = "message"

depending on which cell is selected a different message will be shown.

thanks in advance
nick