I have a textbox and an activeX textbox in a sheet.
And I'm trying to input a text into them with vba.
In either case I'm receiving object doesn't support this property.
I've tested :
ActiveSheet.MySerialNo=MyVariable
MySerialNo.Value=MyVariable
ActiveSheet.MySerialNo.Value=MyVariable
ActiveSheet.MySerialNo.Text=MyVariable
What is the correct format to insert a text in a textbox?
Any kind of insight is appreciated.
Note :
Cross posted here:
And I'm trying to input a text into them with vba.
In either case I'm receiving object doesn't support this property.
I've tested :
ActiveSheet.MySerialNo=MyVariable
MySerialNo.Value=MyVariable
ActiveSheet.MySerialNo.Value=MyVariable
ActiveSheet.MySerialNo.Text=MyVariable
What is the correct format to insert a text in a textbox?
Any kind of insight is appreciated.
Note :
- the textboxes are on the sheet, not a userform.
- The textbox is added from Insert tab , Textbox button
- ActiveX textbox is added from Developer tab, Insert, ActiveX textbox
Cross posted here:
How to input a text into a textbox?
I have a textbox and an activeX textbox in a sheet. And I'm trying to input a text into them with vba. In either case I'm receiving object doesn't support this property. I've tested : ActiveSheet.MySerialNo=MyVariable MySerialNo.Value=MyVariable ActiveSheet.MySerialNo.Value=MyVariable...
www.mrexcel.com
Last edited: