I'd be willing to bet that the textboxes are from the drawing toolbar.

If I don't have any of those controls from the control toolbox toolbar (and no
userforms) in my workbook, then I'd need to set a reference to "microsoft forms
2.0 object library" to get by that line of code.

For John:
Go back to the VBE, select your workbook's project and do Insert|Userform. Then
run Tom's code.

I'm betting you'll see 0 for the control toolbox toolbar count.



Tom Ogilvy wrote:

Make that xl2002 - my typo.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
I pasted it in from the email in Excel 97 and Excel 2003. It ran fine in
both.

If there isn't anything wrong with the code, there isn't much I can say.
I
assume you are using at least xl97. If not, you are using xl5 or xl95,
then
the textbox from the control toolbox toolbar did not exist in those
versions.



--
Regards,
Tom Ogilvy


"John Ellis" wrote in message
...

Tom,

thanks for your patience.

That's exactlyhow I tried to do it in a new module.

I click save (under vbe) then click run () then the error I get is the
same.

Perhaps I am wearing a big pair of stupid glasses and I can not see my
errors ?

Thanks in advance

My private e mail is if this helps you ?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



--

Dave Peterson