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

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?

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

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?