Hello
What I want to do is:
from this workbook (thisWB), I want to access a userform's properties that are in another Workbook (toolWB)
I can do this for worksheets, but I want to do it as well for the userform
I have searched the help files, forums and went through all of the properties of workbooks and worksheets to no avail.
I have a way to go around my problem but not without rewriting a lot of code.
If someone has any ideas on the subject, please let me know.
Thanks
P :oD
What I want to do is:
from this workbook (thisWB), I want to access a userform's properties that are in another Workbook (toolWB)
I can do this for worksheets, but I want to do it as well for the userform
I have searched the help files, forums and went through all of the properties of workbooks and worksheets to no avail.
I have a way to go around my problem but not without rewriting a lot of code.
If someone has any ideas on the subject, please let me know.
Code:
Option Explicit ' this code is on a thisWB module Public toolWB As Workbook Public deskSHEET As Worksheet Public deskFRM As UserForm Sub setToolWB() Set toolWB = toolWB Set deskSHEET = toolWB.Sheets("Desk Bureau") ' this works Set deskFRM = toolWB.[???] ' HELP! End Sub
P :oD
Comment