Hello Excel Experts Out There,
I am a newbie and basically I am trying to read a global variable declared in a module (using Microsoft Visual Basic for Application) from a userform. The global variable "RTfile" is not declared anywhere else except in the module. "RTfile" is only read by the private sub in the userform. But the compiler keeps giving me "Ambiguous Name detected: RTfile" when it hits "RTfile.Close False" in the userform.
I am sure the userform is able to see the global variable in the module.
But not sure of a work around.
Any suggestion or feedback is welcomed.
Thanks.
1) Module "Sort_ConvProg" (under "Module" folder) code:
2) Userform "Sort_Input1" (under "Form" folder) code:
2020-06-05_13h44_00.png
2020-06-05_13h45_48.png
Bookmarks