How do I create a TextBox on a DialogSheet in VBA?

's Computer Specifications

I have tried, without success, to add a TextBox to a newly created
DialogSheet. Other controls were created using the 'Add' method, like
'ActiveSheet.Buttons.Add' or 'ActiveSheet.CheckBoxes.Add', but the TextBox
control doesn't accept this method. Any suggestions?

's Computer Specifications

Controls.Add("Forms.TextBox.1", "txtName")

"snowbear" wrote:

> I have tried, without success, to add a TextBox to a newly created
> DialogSheet. Other controls were created using the 'Add' method, like
> 'ActiveSheet.Buttons.Add' or 'ActiveSheet.CheckBoxes.Add', but the TextBox
> control doesn't accept this method. Any suggestions?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create array of Textbox Dynamically and retrieve data from that textbox in asp .net	Raju	Microsoft C# .NET	1	8th Feb 2006 02:33 PM
Create array of Textbox Dynamically and retrieve data from that textbox in asp .net	Raju	Microsoft C# .NET	0	8th Feb 2006 06:17 AM
Cant find dialogsheet	Piotr	Microsoft Excel Discussion	3	24th Feb 2005 12:27 PM
Updating textbox from class that did not create the textbox?	Tinus	Microsoft Dot NET Framework Forms	3	17th Sep 2004 10:59 AM
What's DialogSheet?How To Get Help OF it?	EdgeOfCity	Microsoft Excel Worksheet Functions	0	20th Nov 2003 01:03 PM