I wonder if someone can give me some syntax to be able to control a draw
text box on the sheet - not on a form

The text box object as in from the drawing toolbar as I need a couple of
textbox to overlap cells on the worksheet

I did run a bit of code which i found off msdn about listing through all the
text boxes

Dim tbox As TextBox
For Each tbox In ActiveSheet.TextBoxes
tbox.Text = UCase(tbox.Text)
Next tbox

Then i used the watch window and monitor tbox as it stepped through all of
them
I found that the values i need to address are as follows

Name = in my test case this was "sausage" as i had named the textbox
Caption = "this is a test"
Text = "this is a test"

But is there a way to directly write and read to the textbox named sausage
.. sorry still a bit of a novice at this !

I also understand the alternative is way is draw text box and then select it
; press f2 ; point it a cell ; then use my code to write to that cell

Hope someone can advise or point me in the right direction