vba textboxes

  reddwarfcrew 14:36 19 Feb 07
Locked

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 = UserForm1
MsgBox(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?

  VoG II 14:41 19 Feb 07

You need to use

Set xform = UserForm1

  reddwarfcrew 15:01 19 Feb 07

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.

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…