How to open user form in another workbook automatically using VBA. Get all the details here: www.exceltrainingvideos.com/open-userform-in-another-workbook/
Try using the path to the file on the LAN. You can also try the Application.Run method using the path to the file on the network. Of course, you will need proper credentials to access the relevant file - username and password.
So i have created a userform to display all sheets name in that workbook and select sheet from that form , is this logic going to work in display sheets from active workbook and select a sheet.
यूज़रफोर्म में एंटर करनेसे दूसरे टेक्स बॉक्स में नहीं जाता हे जो पहले जाता था मेरे पास करीबन १० टेक्स बॉक्स यूज़रफोर्म में हे तो कैसे फिक्स करना हे आप मदद करसकते हो Please
