View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Form development question

Matt,
It means you have an ActiveX textbox control embedded in the spreadsheet.
To work with the textbox, activate it by clicking it then right-click it and select properties.
That gives a you a multitude of options to configure.
If all else fails read "Using ActiveX Controls on Sheets" in vba help.
Regards,
Jim Cone
San Francisco, USA

"Matt Jensen" wrote in message ...
Great, thanks Guys.

I was wondering, what then does this code mean?
=EMBED("Forms.TextBox.1","")

To be more specific:
Does it mean I need to or can access the textbox as an object by way of
traversing the Forms object first?
Can I change/alter this code at all? eg. what can you put in the last ""
then? Also, when I try to change part of the forumla, it says invalid name
or object... What is a correct name or object?
Is there anything else I can do with the formula or use it in any other
ways?

Thanks
Cheers
Matt



"Jim Cone" wrote in message
...
Matt,

You may want to review "Using ActiveX controls on a document" in the VBA

help file.
Also, you may want to consider the controls from the Forms toolbar found

at...
View | Toolbars | Forms.
These are not as versatile, but easier to use with fewer problems.

Regards,
Jim Cone
San Francisco, USA

"Matt Jensen" wrote in message

...
Howdy
Is there anything wrong with creating an application by placing form
elements such as a text boxes directly onto a worksheet?
Cheers
Matt