Forum Discussion

Ian_Ryan's avatar
Ian_Ryan
Copper Contributor
Jan 07, 2020
Solved

Print to a Text Box on a User Form from VBA Module

Hello All, I am in need of some expert guidance to an issue I have.   Basically, I have created a User Form with some buttons on the form that trigger different Modules of VBA. This all works fine ...
Macros and VBA
  • JKPieterse's avatar
    JKPieterse
    Jan 08, 2020
    This means you need to refer to the userform instance that is displaying to access that routine. So if you have an object variable named "MyUF" which points to the currently running userform you can call the sub like so:
    MyUF.WriteToLogText "LogText", False
Ian_Ryan's avatar
Ian_Ryan
Copper Contributor
Jan 08, 2020

The Sub is on the code page of the User Form.

JKPieterse's avatar
JKPieterse
Silver Contributor
Jan 08, 2020
This means you need to refer to the userform instance that is displaying to access that routine. So if you have an object variable named "MyUF" which points to the currently running userform you can call the sub like so:
MyUF.WriteToLogText "LogText", False
  • Ian_Ryan's avatar
    Ian_Ryan
    Copper Contributor
    Jan 09, 2020

    JKPieterse,

     

    Worked perfectly. Thank you so much.

     

    Ian Ryan 

Resources