Hi I am trying to build some code that call the value from a text box (ie UserForm1.TextBox1.Value), but where the statement is made up from other VBA code. My simple code is:Dim xForm xForm = UserForm1MsgBox(xForm.TextBox1.Value) However it debugs with 'Object doesn't support this property or method in the msgbox line of code.Anyone got any ideas?
You need to useSet xform = UserForm1
I've been working on this since 11am.I've lost count the different ways I've been trying to do this.Easy when you know how!Thanks VoG.
This thread is now locked and can not be replied to.
iMac Pro review
See iconic duo Smith and Foulkes' epic animation for the BBC's Winter Olympics coverage
Idées cadeaux pour geeks et tech addicts
© Copyright 2018 IDG UK. All Rights Reserved.